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 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, 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 majordomo@postgresql.org)
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
