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
