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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster