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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
