Re: Vacuous errors in pg_dump ... | pg_restore pipeline

From: SunWuKung <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuous errors in pg_dump ... | pg_restore pipeline
Date: 2008-02-20 21:00:12
Message-ID: 8d18d3b3-8e4e-4c2c-8591-d5e6b52dee90@s12g2000prg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 20, 8:12 pm, d(dot)(dot)(dot)(at)mcnaught(dot)org ("Douglas McNaught") wrote:
> On 2/20/08, Kynn Jones <kyn(dot)(dot)(dot)(at)gmail(dot)com> wrote:
>
> > Alternatively, is there a better way to streamline the duplication of a
> > database?
>
> How about:
>
> CREATE DATABASE newdb TEMPLATE olddb;
>

Do these methods also recreate the schema path of the database copied?
B.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mars_osrp 2008-02-20 23:53:14 Error in PlPython procedure
Previous Message Michelle Konzack 2008-02-20 20:55:04 /var/lib/postgres on Hitachi E5K160 60 GByte (Raid-1 + Hotfix)