Re: backup database by cloning itself

Поиск
Список
Период
Сортировка
От filippo
Тема Re: backup database by cloning itself
Дата
Msg-id 1171437244.981916.80280@v33g2000cwv.googlegroups.com
обсуждение исходный текст
Ответ на backup database by cloning itself  ("filippo" <filippo2991@virgilio.it>)
Ответы Re: backup database by cloning itself  ("Ted" <r.ted.byers@rogers.com>)
Re: backup database by cloning itself  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
On 13 Feb, 14:54, "filippo" <filippo2...@virgilio.it> wrote:

> My target is to have the backup operation not affecting the users, so
> I want to be able to copy a database even if the database is used by
> someone.

I could use pg_dump/pg_restore. pg_dump doesn't have to have exclusive
access to database to perform the operation. My only problem is that
pg_dump create a backup on a file, the best to me whould be to have a
perfect clone (users/ data etc) of original database ready to be used
just after the cloning. Is it possible?

Thanks,

Filippo


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: [ANNOUNCE] Advisory on possibly insecure security definer functions
Следующее
От: Demian Lessa
Дата:
Сообщение: Re: Constraint enforcement