On 17 Jun 2005 at 13:52, Jacob Atzen wrote: > The second problem is a matter of database ownership. Apparently > pg_dumpall will dump the owners of the database along with the data. > This is causing trouble when I try to restore the dump on a server where
There is an option to pg_dumpall, -O, which makes it dump stuff without owners. See the following: http://www.postgresql.org/docs/8.0/static/app-pg-dumpall.html --Ray O'Donnell ------------------------------------------------------------- Raymond O'Donnell http://www.galwaycathedral.org/recitals [EMAIL PROTECTED] Galway Cathedral Recitals ------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
