Re: Large Database Restore

From: Richard Huxton <dev(at)archonet(dot)com>
To: Lee Keel <lee(dot)keel(at)uai(dot)com>
Cc: Michael Nolan <htfoot(at)gmail(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Large Database Restore
Date: 2007-05-21 08:26:06
Message-ID: 4651579E.3020108@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-05-21 08:35:39 TSearch2 memory usage
Previous Message Alban Hertroys 2007-05-21 07:53:20 Re: How to implement GOMONTH function