all_roles_backup

From: vihari raj <vihari(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: all_roles_backup
Date: 2021-10-11 16:21:00
Message-ID: CALcWupWdTWe8MzTeG7pjrPzHUQLeDb_3aWvxYzjGr47O_o5ppA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-10-11 21:40:38 Re: all_roles_backup
Previous Message hubert depesz lubaczewski 2021-10-11 07:40:15 Re: Hide function source