Re:

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(dot)Elphick(at)lfix(dot)co(dot)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(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073