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.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