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 output of pg_dump into a truly empty database; otherwise you are likely to get errors due to duplicate definitions of the 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 [EMAIL PROTECTED] 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, you sinners; and purify your hearts, you double minded." James 4:8 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])