Re: Connections on cluster not being logged

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Connections on cluster not being logged
Date: 2018-07-24 18:10:52
Message-ID: 6182be22-72d7-c7d9-c2fd-954add10babb@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/24/2018 09:47 AM, Peter J. Holzer wrote:
> On 2018-07-24 06:46:18 -0700, Adrian Klaver wrote:
>> On 07/24/2018 06:25 AM, Sandy Becker wrote:
>>> There is only one set of logs since it's a hardware cluster.  The two
>>> nodes share the underlying database storage.  Not sure why, but when the
>>
>> The community Postgres can't do that, have two instances share the same data
>> storage, at least AFAIK. So are you using some fork of Postgres or are there
>> actually two data directories?
>
> Maybe Postgresql only runs on the active node? I.e. a classic failover
> cluster.

Yeah, the OP emailed me off-list saying just that. My suspicion, they
where looking at log for inactive node.

>
> (I'm still not sure what a "hardware cluster" is. Probably some kind of
> appliance which packages two nodes, some storage and the HA software.)
>
> hp
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-24 18:17:14 Re: Speccing a remote backup server
Previous Message Dimitri Maziuk 2018-07-24 17:22:24 Re: logical replication snapshots