Search Postgresql Archives

Streaming replication and empty databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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! 


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux