On Tue, 2002-09-10 at 00:50, Philip Warner wrote:
> ALTERNATIVELY, define the language in template1, then just edit dump1.lis
> to remove the line for the language definition, and run pg_restore -L
> dump1.lis.
That doesn't work for a dump and reload, because 7.3's pg_dumpall writes
a script to create the databases from template0 rather than template1.
The 7.3 documentation for pg_dump says:
Notes If your installation has any local additions to the template1 database, be careful to restore the
outputof pg_dump into a truly empty database; otherwise you are likely to get errors due to duplicate definitions
ofthe added objects. To make an empty database without any local additions, copy from template0 not template1, for
example: CREATE DATABASE foo WITH TEMPLATE = template0;
but this seems to be out of date. pg_dumpall actually uses template0
itself.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
======================================== "Draw near to God and he will draw near to you. Cleanse your hands,
yousinners; and purify your hearts, you double minded." James 4:8