| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Donald Fraser" <demolish(at)cwgsy(dot)net> |
| Cc: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dumpall |
| Date: | 2003-02-20 15:21:22 |
| Message-ID: | 22213.1045754482@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Donald Fraser" <demolish(at)cwgsy(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-02-20 16:15:58 | Re: uppercase = lowercase |
| Previous Message | Al Sutton | 2003-02-20 14:03:46 | Logging for psql only |