Re: problem backup/restore PSQL DB
От | Shoaib Mir |
---|---|
Тема | Re: problem backup/restore PSQL DB |
Дата | |
Msg-id | bf54be870607250145w18af0d2ay8be879e123287d69@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: problem backup/restore PSQL DB (Paul S <plabrh1@gmail.com>) |
Ответы |
Re: problem backup/restore PSQL DB
|
Список | pgsql-admin |
You can also try using 'pg_dumpall' (http://www.postgresql.org/docs/8.1/static/app-pg-dumpall.html) that will take the dump of all the users, groups and databases.
Thanks,
Shoaib Mir
EnterpriseDB
Thanks,
Shoaib Mir
EnterpriseDB
On 7/25/06, Paul S <plabrh1@gmail.com> wrote:
It looks like it's a user configuration issue. I have hit user setup issues
while restoring DB's before and generally I find it useful to create the
Users and/or Groups manually on the new server first before restoring the
DB's whenever I hit problems like that. Try syncing the users manually,
(assuming that there are only a few and that it could be done manually with
some level of ease) and then try restoring again.
-Paul
--
View this message in context: http://www.nabble.com/problem-backup-restore-PSQL-DB-tf1995768.html#a5478199
Sent from the PostgreSQL - admin forum at Nabble.com.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
В списке pgsql-admin по дате отправления: