Re: Large Database Restore - Mailing list pgsql-general

From Richard Huxton
Subject Re: Large Database Restore
Date
Msg-id 464DE59E.2090107@archonet.com
Whole thread Raw
In response to Re: Large Database Restore  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Large Database Restore
List pgsql-general
Alvaro Herrera wrote:
> Lee Keel escribió:
>> 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?
>
> Actually you can do single databases, but you must also include some
> other directories besides the database directory.  You would need to
> include everything, excluding things in the "base" directory, but not
> exclude your databases directory in "base".

Will that not cause trouble if you've added users though?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Large Database Restore
Next
From: Alvaro Herrera
Date:
Subject: Re: Large Database Restore