Re: Large Database Restore - Mailing list pgsql-general

From Richard Huxton
Subject Re: Large Database Restore
Date
Msg-id 4651579E.3020108@archonet.com
Whole thread Raw
In response to Re: Large Database Restore  (Lee Keel <lee.keel@uai.com>)
List pgsql-general
Lee Keel wrote:
> So then the best way to do this kind of backup\restore is to use pg_dump?
> Is there any plan in the future to be able to do some sort of file-level
> backup like SqlServer?

Oh you *can* do a file-level backup, but only of the entire cluster. If
you have information shared between databases (users, transaction IDs
etc) then I don't see any way for single-database file-copying to work.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: How to implement GOMONTH function
Next
From: Hannes Dorbath
Date:
Subject: TSearch2 memory usage