Postgres Pro
Downloads
Home   >   mailing lists

all_roles_backup - Mailing list pgsql-admin

From vihari raj
Subject all_roles_backup
Date
Msg-id CALcWupWdTWe8MzTeG7pjrPzHUQLeDb_3aWvxYzjGr47O_o5ppA@mail.gmail.com
Whole thread Raw
Responses Re: all_roles_backup  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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\"

Regards,
vihari

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Hide function source
Next
From: "David G. Johnston"
Date:
Subject: Re: all_roles_backup