Hello, world!
I'm trying to figure out how to use fail-over with 2 PgSQL 9.1 servers;
I already succeeded in exchanging roles (ie. making standby master and
vice versa), but only when both master and slave are up and running. I
tried to simulate a master crash by killing its virtual machine, but,
On Tue, Apr 2, 2013 at 10:29 AM, David Guyot (English) <
david.gu...@europecamions-interactive.com> wrote:
> restore_command = 'rsync -av 192.168.0.80:/var/lib/postgresql/WAL/%f %p'
>
You're telling the recovery process to get the files off the (now dead)
master here...
--
Douglas J Hunley (do
Mister,
Thank you for your answer. I had in mind that this line was for the
initial start of the standby; should I just comment it before promoting
the standby, or is this line useless for the day-to-day standby service?
Thank you in advance.
Regards.
Le 02/04/2013 16:47, Douglas J Hunley a écr
On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david.gu...@europecamions-interactive.com> wrote:
> Thank you for your answer. I had in mind that this line was for the
> initial start of the standby; should I just comment it before promoting the
> standby, or is this line useless for the day-to-day
On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david.gu...@europecamions-interactive.com> wrote:
> Mister,
>
> Thank you for your answer. I had in mind that this line was for the
> initial start of the standby; should I just comment it before promoting the
> standby, or is this line useless for t
Hello,
I'm running the latest postgres version (9.2.3), and today for the first
time I encountered this:
12774 2013-04-02 18:13:10 CEST LOG: server process (PID 28463) was
terminated by signal 9: Killed
12774 2013-04-02 18:13:10 CEST DETAIL: Failed process was running:
BEGIN;declare "SQL_CUR0xf
Bert writes:
> I'm running the latest postgres version (9.2.3), and today for the first
> time I encountered this:
> 12774 2013-04-02 18:13:10 CEST LOG: server process (PID 28463) was
> terminated by signal 9: Killed
AFAIK there are only two possible sources of signal 9: a manual kill,
or the L
Hi Tom,
thanks for the tip! it was indeed the oom killer.
Is it wise to disable the oom killer? Or will the server really go down
withough postgres doing something about it?
currently I already lowered the shared_memory value a bit..
cheers,
Bert
On Tue, Apr 2, 2013 at 8:06 PM, Tom Lane wrot