pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Noah Misch <noah@leadboat.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Unexpected "shared memory block is still in use"
Date: Thu, 5 Sep 2019 14:28:08 +0200
Message-ID: <6cefc482-b163-1c3d-48fd-344d99cb137f@2ndquadrant.com> (raw )
In-Reply-To: <2079.1567609165@sss.pgh.pa.us >
References: <22224.1557340366@sss.pgh.pa.us >
<20190509055414.GB1066859@rfd.leadboat.com >
<2663.1557409654@sss.pgh.pa.us >
<2226.1557439179@sss.pgh.pa.us >
<17642.1557442078@sss.pgh.pa.us >
<20190510072213.GA1098093@rfd.leadboat.com >
<25485.1557500141@sss.pgh.pa.us >
<16908.1557521200@sss.pgh.pa.us >
<20190511190715.GA1124997@rfd.leadboat.com >
<29530.1565738526@sss.pgh.pa.us >
<8cd56b77-dfd9-cfbe-cad2-663939b5f510@2ndquadrant.com >
<11212.1565965138@sss.pgh.pa.us >
<c3451ec9-28f1-7655-3227-08997a768e39@2ndquadrant.com >
<2079.1567609165@sss.pgh.pa.us >
On 2019-09-04 16:59, Tom Lane wrote:
>> A related point, perhaps we should change the key printed into
>> postmaster.pid to be in hexadecimal format ("0x08x") so that it matches
>> what ipcs prints.
> Hmm, that depends on whose ipcs you use :-(. A quick survey
> of my machines says it's
>
> key shmid
>
> Linux: hex decimal
> FreeBSD: decimal decimal
> NetBSD: decimal decimal
> OpenBSD: decimal decimal
> macOS: hex decimal
> HPUX: hex (not printed)
>
> There's certainly room to argue that hex+decimal is most popular,
> but I'm not sure that that outweighs possible compatibility issues
> from changing postmaster.pid contents. (Admittedly, it's not real
> clear that anything would be paying attention to the shmem key,
> so maybe there's no compatibility issue.)
Let's just leave it decimal then. At least then it's easier to compare
it to ls -i output.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
view thread (18+ messages)
Message-ID: <6cefc482-b163-1c3d-48fd-344d99cb137f@2ndquadrant.com>
Permalink: ../6cefc482-b163-1c3d-48fd-344d99cb137f@2ndquadrant.com/
Also on: postgresql.org/message-id/6cefc482-b163-1c3d-48fd-344d99cb137f@2ndquadrant.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, tgl@sss.pgh.pa.us, noah@leadboat.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Unexpected "shared memory block is still in use"
In-Reply-To: <6cefc482-b163-1c3d-48fd-344d99cb137f@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox