Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

The recommended juju charm for postgresql states a nice feature in its readme which is when configured as a standalone server it has the ability to become a master / slave with replication when adding more units. Automatically. The master can even be deleted and a slave recovers its function.

It sounds great but I am wondering, since I have set up a database manually (I have SSHed into the server and createdb and loaded a dump), will it still work or does it have to be with a db that has been created automatically with the charm?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Yes, it will work.

PostgreSQL replication replicates the entire PostgreSQL cluster, so all databases in the default cluster created by you, juju, and the system ones (template0, template1 and postgres), and all cluster global objects like users & roles.

Replication is not set up for any non-default clusters you create with pg_createcluster or initdb.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.