On Sat, Apr 30, 2005 at 11:16:59 +0300, Mauri Sahlberg <[EMAIL PROTECTED]> wrote: > Hi, > > This might be a stupid question as it is not covered in the 7.4.7 and > probably obvious to all others. Where do the system catalogs live? How > to back them up? Should I back them up? > > The admin manual states that to restore a pg_dumped database you should > have those users created that will have permission related to objects > created by pg_restore but gives no clear instructions how to back the > users up and how to restore them before restoring the database.
You want to use pg_dumpall. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match