From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
cc: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL 10.5 : Strange pg_wal fill-up,
 solved with the shutdown checkpoint
In-reply-to: <93155f7d-21e3-7442-5d76-acdaf57f0dae@matrix.gatewaynet.com>
References: <0d25bb8c-9cc7-10bc-71ba-6a8a8c33ec49@matrix.gatewaynet.com>
 <46D70340-2172-406A-A346-B2D4C6E947E4@crazybean.net>
 <6031b670-52d1-b823-6b41-35d2fa1873c6@matrix.gatewaynet.com>
 <23169.1541516303@sss.pgh.pa.us>
 <93155f7d-21e3-7442-5d76-acdaf57f0dae@matrix.gatewaynet.com>
Comments: In-reply-to Achilleas Mantzios <achill@matrix.gatewaynet.com>
	message dated "Wed, 07 Nov 2018 12:33:56 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <27416.1541602104.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 07 Nov 2018 09:48:24 -0500
Message-ID: <27417.1541602104@sss.pgh.pa.us>
Precedence: bulk

Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> On 6/11/18 4:58 =CE=BC.=CE=BC., Tom Lane wrote:
>> I have no idea how that could happen exactly.  If it happens again,
>> it'd be really interesting to attach to the checkpointer with a
>> debugger and collect a stack trace.

> Thank you Tom. Should I also re-run configure --enable-debug && make cle=
an install ? Initially PostgreSQL was built without --enable-debug, so cur=
rently it does not show source code line numbers in =

> gdb bt .

Yeah, if you do not have debug symbols installed, the stack trace
will be of very little use.

			regards, tom lane