Re: all_roles_backup

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: all_roles_backup
Дата
Msg-id CAKFQuwaog089Y16hOdDBfDAvqAysCOOT7biLj_Mk3oGuSU6_YQ@mail.gmail.com
обсуждение исходный текст
Ответ на all_roles_backup  (vihari raj <vihari.postgresdba@gmail.com>)
Список pgsql-admin
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 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\"

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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: vihari raj
Дата:
Сообщение: all_roles_backup
Следующее
От: Dustin Jantz
Дата:
Сообщение: Recover Disk Space From Terminated VACUUM FULL ANALYZE