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

Поиск
Список
Период
Сортировка
От Jonathan Roby
Тема copy a postgres dbase to the same machine with different name?
Дата
Msg-id 004e01c6160f$e8902880$24a4b382@robyj3FGTQ61
обсуждение исходный текст
Ответы Re: copy a postgres dbase to the same machine with different name?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Harry Jackson
Дата:
Сообщение: Re: regarding triggers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: copy a postgres dbase to the same machine with different name?