Questions tagged [pg-hba.conf]
53 questions
0
votes
0 answers
psql: FATAL: Peer authentication failed for user "trifacta" and Ident authentication failed for user
When I try to login to postgres I get the following error:
# psql -U trifacta -h 127.0.0.1 trifacta
psql: FATAL: Ident authentication failed for user "trifacta"
# psql -d trifacta -U trifacta -w
psql: FATAL: Peer authentication failed for user…
Ravin2015
- 1
- 4
0
votes
1 answer
Cannot connect PostgreSQL cluster though replication user
I am replicating multiple PostgreSQL clústers in single server using streaming replication and dedicated replication slot.
We also want to monitor some parameters such as the status of replication slots on each master and, for this reason, we want…
bitifet
- 3,514
- 15
- 37
0
votes
1 answer
Setup to share Postgresql database between two local machines (macOS high sierra)?
This might seem trivial, but how can I connect one machine ('A') to another machine's ('B') so that databases in 'A' and 'B' are synced at all times. Both machines run on macOS High Sierra and PostgreSQL v10 was installed with homebrew. Basically, I…
roberto swiss
- 155
- 8
0
votes
1 answer
Linux (Fedora) Cannot run psql command in terminal - role does not exist
I have seen all the questions here on stackoverflow about similar topic, but I would like to know why this happens, where is the problem, and what to do to set it up correctly. I am learning to code, so I apologize for any misunderstandings. Please,…
Matthew
- 33
- 6
0
votes
1 answer
Cannot connect to postgres database even with 'trust' settings
I'm currently really struggling with a postgres 9.1 database which i need for testing my software. I did not create this database but i used to log in before with postgres as a user and password. However, right now it is impossible for me to create…
flixe
- 626
- 1
- 11
- 36
0
votes
1 answer
Postgres will not allow alter role superuser and my default user isn't superuser
I cannot connect to Postgres using Elixir:
** (Mix) The database for PhoenixChat.Repo couldn't be created: FATAL 28P01 (invalid_password): password authentication failed for user "postgres"
00:08:59.053 [error] GenServer #PID<0.3214.0>…
codyc4321
- 9,014
- 22
- 92
- 165
0
votes
1 answer
MapServer error : FATAL: Ident authentication failed for user "..."
I'm trying to run a MapServer 5/PostGIS installation on a Centos 6 virtual machine.
I deployed MapServer in my cgi-bin folder, but now when I query (using firefox) mapserv file
with the url [virtual machine local…
MattOnyx
- 172
- 12
-1
votes
2 answers
Online edit a file(pg_hba.conf) using ansible and jenkins
guys,
I want to use ansible to open a file, for example pg_hba.conf in realtime (like vim) and be able to edit it on the fly.
I want to be able to choose the group of target servers from jenkins, read the contents of pg_hba.conf of a particular…
Grigor Ivanov
- 9
- 1