Postgres Pro
Downloads
Home   >   mailing lists

copy a postgres dbase to the same machine with different name? - Mailing list pgsql-general

From Jonathan Roby
Subject copy a postgres dbase to the same machine with different name?
Date
Msg-id 004e01c6160f$e8902880$24a4b382@robyj3FGTQ61
Whole thread Raw
Responses Re: copy a postgres dbase to the same machine with different name?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi everyone,
 
For a project here at work I look after a web app that communicates with a postgresql database. We need to clone/copy the existing database to run app upgrades on the clone database and then use the upgraded database in place of the original.
 
I've read the pg_dump/pg_restore man pages, tried to google for a technique, but haven't found anything that adequate explains it & i'd rather not screw up a live database <grin>
 
Thanks for any help,
Jon.
 

pgsql-general by date:

Previous
From: Harry Jackson
Date:
Subject: Re: regarding triggers
Next
From: Tom Lane
Date:
Subject: Re: copy a postgres dbase to the same machine with different name?