pg_dump for single database backup in Postgres
I do not see a way to backup a single datasbase via pg_dump or something similar. Is there a way to do so?
At this moment this is not yet supported by the ClusterControl. The simplest check you can use would be to test:
"SELECT pg_is_in_recovery()" for slave and "SHOW transaction_read_only" for master. Master should not be read_only, obviously.Comment actions
Please sign in to leave a comment.