On 13 Feb, 14:54, "filippo" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/