From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
Cc: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Laurette Cisneros <laurette(at)nextbus(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2002-09-10 17:38:00 |
Message-ID: | 200209101738.g8AHc0j01799@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-09-10 17:42:36 | Re: [JDBC] problem with new autocommit config parameter and |
Previous Message | Barry Lind | 2002-09-10 16:36:28 | Re: [JDBC] problem with new autocommit config parameter |