Greetings, * Gokan Atmaca (linux.gokan@xxxxxxxxx) wrote: > > Look for --db-include > > This option restores a single database but corrupts the others. Is it > necessary to take a backup with "pg_dump" before doing this? "Corrupts" is only kind of correct- it explicitly doesn't restore the other databases (since you asked for just one to be restored) and makes it such that you're not able to log into them. Performing an export with pg_dump is one approach to getting a point in time view of all of the data in a given database, but you won't be able to perform PITR-style restore with pg_dump's. Thanks, Stephen
Attachment:
signature.asc
Description: PGP signature
