pg_dump for single database backup in Postgres

Follow

Fontana FLuke

• July 10, 2019 19:50

I do not see a way to backup a single datasbase via pg_dump or something similar. Is there a way to do so?

1

• Official comment

  

  Krzysztof Ksiazek

  • September 28, 2020 10:02

  Hi,

  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 Permalink
• 

  Paul Namuag

  • July 10, 2019 19:59

  Hi Fontana,

   

  You're right. The backup we use in ClusterControl are for all database backup including its objects. Otherwise, you'll try to use pg_dump running it manually to cover only one database when creating a backup.

  0

  Comment actions Permalink
• 

  Peter Severin Rasmussen

  • September 28, 2020 08:22

  Is there no way to do this via the controller?

  Of course it is possible with a home-made backup-script in cron, but how does the script know which host is master and slave at any given point?

  0

  Comment actions Permalink

Please sign in to leave a comment.