Re: backup database by cloning itself - Mailing list pgsql-general

From filippo
Subject Re: backup database by cloning itself
Date
Msg-id 1171437244.981916.80280@v33g2000cwv.googlegroups.com
Whole thread Raw
In response to backup database by cloning itself  ("filippo" <filippo2991@virgilio.it>)
Responses 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>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: [ANNOUNCE] Advisory on possibly insecure security definer functions
Next
From: Demian Lessa
Date:
Subject: Re: Constraint enforcement