Re: pg_dumpall - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dumpall
Date
Msg-id 22213.1045754482@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
"Donald Fraser" <demolish@cwgsy.net> writes:
> My question now would be, is there an easy way to place your own objects
> into pg_catalog for template0?

Changing template0 is exactly what you are NOT supposed to do, as it
breaks what pg_dump is trying to accomplish.

However, you could probably just edit the dump file to replace the
references to template0 with template1.  When you reload the dump,
you will get lots of errors as the customized objects coming in from
the dump collide with the ones copied from template1 --- but that's
what you want.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Al Sutton"
Date:
Subject: Logging for psql only
Next
From: Robert Treat
Date:
Subject: Re: uppercase = lowercase