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

From Rainer Bauer
Subject Re: Copy the database..
Date
Msg-id h27qi3dva315vlq88vdg8dka36rijmmjq1@4ax.com
Whole thread Raw
Responses Re: Copy the database..  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Copy the database..  (Julio Cesar Sánchez González<knowhow@sistemasyconectividad.com.mx>)
List pgsql-general
Abandoned wrote:

>I tryed pg_dump but it is very slowly. Are there any faster way to
>copy database?

Actually, I was looking for something along the same line.

I often want to test some functionality in my program based on the same
dataset. However, dump/restore takes too long to be of any use.

Wouldn't it be possible to copy the database folder and somehow instruct the
postmaster to include the copied data after a restart?

Rainer

pgsql-general by date:

Previous
From: mgainty@hotmail.com
Date:
Subject: Re: young guy wanting (Postgres DBA) ammo
Next
From: Tom Lane
Date:
Subject: Re: Copy the database..