| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Lee Keel <lee(dot)keel(at)uai(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, 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-18 16:38:21 |
| Message-ID: | 20070518163821.GI6695@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-05-18 17:42:54 | Re: Large Database Restore |
| Previous Message | Lee Keel | 2007-05-18 16:30:48 | Re: Large Database Restore |