Re: Copy the database.. - Mailing list pgsql-general

From Rainer Bauer
Subject Re: Copy the database..
Date
Msg-id 1mcui3tmg20br903h4j978rd66f514o76s@4ax.com
Whole thread Raw
In response to Re: Copy the database..  (Rainer Bauer <usenet@munnin.com>)
List pgsql-general
Tom Lane wrote:

>Rainer Bauer <usenet@munnin.com> writes:
>> Wouldn't it be possible to copy the database folder and somehow instruct the
>> postmaster to include the copied data after a restart?
>
>See CREATE DATABASE's TEMPLATE option.  It's a bit crude but I think
>it'll help.

Thanks, Tom. Works like a charm.

Rainer

pgsql-general by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: Populating large DB from Perl script
Next
From: "Pit M."
Date:
Subject: Re: Problems with PostgreSQL DBI-Link / DBD-ODBC