pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex <alex@meerkatsoft.com>
To: Postgre Admin <pgsql-admin@postgresql.org>
Subject: PG_DUMP Question
Date: Wed, 29 Oct 2003 22:43:15 +0900
Message-ID: <3F9FC3F3.2020509@meerkatsoft.com> (raw)

Hi,

I have a test system that is setup the same as a production system and 
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.

Are there any reasons not to simply just copy the entire data directory 
over to the test system? I could not find any postings on the net 
suggesting otherwise. Is there anything to pay attention too ?

Thanks for any advise
Alex





view thread (10+ messages)  latest in thread

Message-ID: <3F9FC3F3.2020509@meerkatsoft.com>
Permalink:  ../3F9FC3F3.2020509@meerkatsoft.com/
Also on:    postgresql.org/message-id/3F9FC3F3.2020509@meerkatsoft.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alex@meerkatsoft.com
  Subject: Re: PG_DUMP Question
  In-Reply-To: <3F9FC3F3.2020509@meerkatsoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox