Re: Streaming replication and empty databases

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