On 29/01/2009 16:31, Gerhard Wiesinger wrote: > I recently read some Mail on the mailinglist where some parts of > PostgreSQL were not dumped with pg_dumpall and additionally some pg_dump > was necessary (it was something like internals, catalog, etc.) It's the other way around - pg_dump dumps just the specified database, but not cluster-wide stuff like login roles; you need to do a pg_dumpall to get those as well. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general