Re: backup script error with could not connect to database

2019-12-19 Thread mallikarjun t
Dear team, Do onething ident authentication problem to overcome on create .pgpass file and what username and password, port number and dbname put it on .pgpass file. Now you never ever getting this error. On Thu, Dec 19, 2019, 12:25 AM Pepe TD Vo wrote: > hello expert, > > I had to do a backup

Re: backup script error with could not connect to database

2019-12-19 Thread Pepe TD Vo
I made it work.  I changed all in pg_hba.conf to trust and backup scripts run fine. thank you so much. Bach-Nga No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him jus

Re: backup script error with could not connect to database

2019-12-19 Thread bw
Did you try root su -c postgres pg_dumpall > postgresdump.sql On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo wrote: > > hello expert, > > I had to do a backup on replication master-slave servers. I also have asked > this question before, but I don't understand why I followed the information > and

backup script error with could not connect to database

2019-12-18 Thread Pepe TD Vo
hello expert, I had to do a backup on replication master-slave servers.  I also have asked this question before, but  I don't understand why I followed the information and same scripting to run on the replication servers and didn't work.  I can run pg_dumpall successful but not with the script.