Le 2012-03-23 à 09:28, Svoop <sv...@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 the database using pg_dump and reload in my second instance. Works great. Hope that helps! François -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
