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

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Kynn Jones" <kynnjo(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuous errors in pg_dump ... | pg_restore pipeline
Date: 2008-02-20 19:12:09
Message-ID: 5ded07e00802201112v426610f7n2ee0798b98ada27c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/20/08, Kynn Jones <kynnjo(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;

(don't remember the exact syntax, but it'll be in the docs for CREATE
DATABASE). I think the 'createdb' program also has an option for
choosing the template.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brian 2008-02-20 19:58:32 Re: Suggestions for schema design?
Previous Message cluster 2008-02-20 19:02:41 Suggestions for schema design?