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/
