"Jonathan Roby" <robyj@xxxxxxxxxxxxxxx> 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 you talking about cloning the whole installation to run under a separate postmaster? Or are you trying to create a new database with a different name under the same postmaster? If the latter, and you can idle the database while copying it, the TEMPLATE option to CREATE DATABASE will serve. regards, tom lane
