Re: Large Database Restore - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Large Database Restore
Date
Msg-id 20070518163821.GI6695@alvh.no-ip.org
Whole thread Raw
In response to Re: Large Database Restore  (Lee Keel <lee.keel@uai.com>)
Responses Re: Large Database Restore
List pgsql-general
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".

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Lee Keel
Date:
Subject: Re: Large Database Restore
Next
From: Richard Huxton
Date:
Subject: Re: Large Database Restore