Re: problem backup/restore PSQL DB

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

On 7/25/06, Paul S <plabrh1(at)gmail(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>