[GENERAL] copy a postgres dbase to the same machine with different name?

2006-01-10 Thread Jonathan Roby
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

Re: [GENERAL] copy a postgres dbase to the same machine with different name?

2006-01-10 Thread Tom Lane
Jonathan Roby [EMAIL PROTECTED] writes: 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. Are