Streaming replication and empty databases

From: Svoop <svoop(at)delirium(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Streaming replication and empty databases
Date: 2012-03-23 13:28:26
Message-ID: loom.20120323T142746-935@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-03-23 13:31:42 Re: Parsing PG log usings CSV format
Previous Message Bartosz Dmytrak 2012-03-23 13:27:15 Re: postgresql_fdw_handler