Carlos H. Reimer wrote:
> Sorry, I would like to say pg_dumpall and not pg_dump.
>
> --no-privileges is an option but I need to restore the privileges. There are
> a lot of them in the system, many many objects and privileges.
pg_dumpall *does* dump all the permissions properly.
What options / switches exactly are you using with pg_dumpall?
--
Postgresql & php tutorials
http://www.designmagick.com/