Hello,
my pg_backup_rotated.sh script ran fine since Dec 20 and after rebuild the
slave now it's broken and I do not know why. I can run pg_dumpall >
/tmp_all_db_backup.sql but not from the script. From the log its pg_dumall:
could not connect to database "template1": FATAL: Ident authentication
failed for user "postgres". I tried to reset postgres in psql as "alter
user postgres with PASSWORD 'xxxxx'; (as same as the old one and the
postgres os).
I run pg_backup_rotated.sh as postgres and it promp me for the password and
then password for user postges and repeat it again and again until all the
databases backup.
From the script it gives me pg_dumpall: could not connect to database
"template1": FATAL: password authentication failed for user "postgres" and
even I run the script as root, it prompted me for password,
it gives me pg_dumpall: could not connect to database "template1": FATAL:
password authentication failed for user "postgres"
Typically, I make a backup based on the current day, and rotate the seven
days in the backup file name, all successful until Feb 19.
How can I resolve this issue? Any good backup tips I should be aware of.
Thanks for all the tips
Bach-Nga
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html