not able to connect. - Mailing list pgsql-novice

Hi All,

I have setup postgresql and was trying passwordless pg_basebackup.

So I defined .pgpass as below in home location of master as well as slave :-

-bash-4.2$ ls -lart

total 20

-rwx------.  1 postgres postgres  266 Mar 17 16:02 .bash_profile

drwxr-xr-x. 35 root     root     4096 Mar 17 16:04 ..

drwx------.  4 postgres postgres   51 Mar 17 18:13 10

-rw-------.  1 postgres postgres   44 Mar 18 00:32 .pgpass

-bash-4.2$ cat .pgpass

10.85.4.39:5432:replication:repuser:repsuer

postgres=# show hba_file ;

             hba_file

-----------------------------------

/mnt/disks/data/pdata/pg_hba.conf

(1 row)

postgres=# \q

-bash-4.2$ cat /mnt/disks/data/pdata/pg_hba.conf

local   all             postgres              trust

host    all             all              0.0.0.0/0                   scram-sha-256

host    all             all              ::/0                        scram-sha-256

host    all             all              10.85.4.39/32                 md5

host    replication     repuser          10.85.4.39/32                 md5

host    replication     repuser          10.85.4.37/32                 md5

host    replication     repuser          10.85.4.41/32                 md5

-bash-4.2$ psql -d postgres -h 10.85.4.39 -p 5432 -U repuser

Password for user repuser:

psql: FATAL:  password authentication failed for user "repuser"

from slave :-

-bash-4.2$  pg_basebackup -h 10.85.4.39 -D /mnt/disks/data/pdata/ -P -U repuser --wal-method=stream -w

pg_basebackup: could not connect to server: FATAL:  password authentication failed for user "repuser"

password retrieved from file "/var/lib/pgsql/.pgpass"

pg_basebackup: removing contents of data directory "/mnt/disks/data/pdata/"

I am not able to connect, please help. Without pgpass I have to manually give password at slave to setup replication via pg_basebackup but I was trying to disable password and got stuck as shown above.

Please help.

Thanks,

Aman