Thread: Streaming replication and empty databases

Hi

We're having two servers one of which is productive, the other used for backup
and staging. Each has pg-9.1 installed and the relevant filesystem parts are
regularly rsynced.

The last missing piece is streaming replication from the production to the
staging server. On production, pg holds two databases named app_production and
app_staging. The latter is just a bare and empty database with no tables etc
defined.

With streaming replication in place, the pg on the staging server will get all
the information to sync with the pg on the production server.

However, can I use the app_staging database on the staging server independently?
It appears a possibility since no XLOG messages concerning the app_staging
database will be sent.

Plan B is a second pg instance on the staging server, but I'd like to know if
the above setup might work as well.

Thanks for your hints!

Le 2012-03-23 à 09:28, Svoop <svoop@delirium.ch> a écrit :

> However, can I use the app_staging database on the staging server independently? [...]
>
> Plan B is a second pg instance on the staging server, but I'd like to know if
> the above setup might work as well.

PostgreSQL disallows writes on slaves. Like you, I arrived at the 2nd cluster / instance running on the slave. I dump
thedatabase using pg_dump and reload in my second instance. Works great. 

Hope that helps!
François