Greetings,
* Gokan Atmaca (linux.gokan@gmail.com) 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