From: Даниил Элишаков <dan-eli@mail.ru>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18779: Segmentation fault while trying to connect via psql
Date: Wed, 22 Jan 2025 11:28:53 +0300
Message-ID: <1737534533.668379460@f748.i.mail.ru> (raw)
In-Reply-To: <CAMkU=1ygOAzswdNP-Zf3w8VDFxbxBpDfQGD5mvo1ayo2sagULQ@mail.gmail.com>
References: <18779-d1a17a5a7680f5ca@postgresql.org>
<CAMkU=1ygOAzswdNP-Zf3w8VDFxbxBpDfQGD5mvo1ayo2sagULQ@mail.gmail.com>
Here is a gif with bug scenario. Gif starts while already being switched to root user. The phrase ‘’Ошибка сегментирования’’ stands for Segmentation fault. Sorry for mixing up the issue and it’s possible causes in the previous letter. Hope this gif will make it clear
Regards,
Daniil
>Воскресенье, 19 января 2025, 5:32 +03:00 от Jeff Janes <jeff.janes@gmail.com>:
>
>On Fri, Jan 17, 2025 at 6:51AM PG Bug reporting form < noreply@postgresql.org > wrote:
>>The following bug has been logged on the website:
>>
>>Bug reference: 18779
>>Logged by: Daniel Elishakov
>>Email address: dan-eli@mail.ru
>>PostgreSQL version: 16.6
>>Operating system: Debian GNU/Linux 12 (bookworm)
>>Description:
>>
>>This bug takes place in Debian-based operating systems. To replicate this
>>bug please do following:
>>1) Install and initialize PostgreSQL dbms
>
>I think we need more details. There are multiple ways to do both of those things.
>
>>2) Switch user to root (sudo -i)
>>3) Switch user to postgres
>
>What if you just use one command, sudo -i -u postgres?
>
>>4) run command psql -U postgres -h localhost (may run multiple times to see
>>the bug)
>>
>>Looks like this bug occurs because root user has ENV variable KRB5CCNAME,
>>while postgres does not.
>
>What did you do to make this happen? A default debian installation does have KRB5CCNAME set for root.
>
>Cheers,
>
>Jeff
С уважением,
Даниил Элишаков
dan-eli@mail.ru
Attachments:bug_seg_fault.gif (image/gif, 483.5K) downloadview image
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-bugs@postgresql.org
Cc: dan-eli@mail.ru, jeff.janes@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Re: BUG #18779: Segmentation fault while trying to connect via psql
In-Reply-To: <1737534533.668379460@f748.i.mail.ru>
* 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