I am confused. This wording seems fine to me.
--------------------------------------------------------------------------- Oliver Elphick wrote: > 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]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html