Request a Demo
Home   >   mailing lists

Re: BUG #18779: Segmentation fault while trying to connect via psql - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #18779: Segmentation fault while trying to connect via psql
Date
Msg-id CAMkU=1ygOAzswdNP-Zf3w8VDFxbxBpDfQGD5mvo1ayo2sagULQ@mail.gmail.com
Whole thread Raw
In response to BUG #18779: Segmentation fault while trying to connect via psql  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Fri, Jan 17, 2025 at 6:51 AM 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type
Next
From: PG Bug reporting form
Date:
Subject: BUG #18780: Bindings types are lost for complex queries