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])

Reply via email to