backup broken

From: bvo <pepevo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: backup broken
Date: 2020-02-24 15:23:43
Message-ID: 1582557823739-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-02-24 15:24:08 Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Previous Message Nick Renders 2020-02-24 12:48:18 Re: Postgres 12.1 : UPPER() in WHERE clause restarts server