Thread: all_roles_backup
Hi Team,
I'm trying to taking dump of all users but I'm facing below error.
I'm using below command for roles backup
command:
pg_dumpall -h <hostname> -p 5432 -U postgres\ --roles-only -f D:\RDS_roles\role.sql
Error:
pg_dumpall: error: could not connect to database "template1": FATAL: password authentication failed for user "postgres\"
FATAL: password authentication failed for user "postgres\"
FATAL: password authentication failed for user "postgres\"
Regards,
vihari
On Monday, October 11, 2021, vihari raj <vihari.postgresdba@gmail.com> wrote:
Hi Team,I'm trying to taking dump of all users but I'm facing below error.I'm using below command for roles backupcommand:pg_dumpall -h <hostname> -p 5432 -U postgres\ --roles-only -f D:\RDS_roles\role.sqlError:pg_dumpall: error: could not connect to database "template1": FATAL: password authentication failed for user "postgres\"
FATAL: password authentication failed for user "postgres\"
Your use of a line continuation character sequence in your shell isn’t actually at the end of a line, so it gets interpreted as part of the value “postgres”, making it invalid.
David J.