Re: Streaming replication and empty databases

From: François Beausoleil <francois(at)teksol(dot)info>
To: Svoop <svoop(at)delirium(dot)ch>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming replication and empty databases
Date: 2012-03-25 13:13:52
Message-ID: 17FC405D-207F-4EEF-A9AC-988B0C5D5E47@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Le 2012-03-23 à 09:28, Svoop <svoop(at)delirium(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-03-25 14:53:33 Re: can these queries be combined into one?
Previous Message Jasen Betts 2012-03-25 09:05:54 Re: Is record handle available to a check constraint stored procedure call?