Re: php connection failure - Mailing list pgsql-general

From ourdiaspora
Subject Re: php connection failure
Date
Msg-id efaVW60KjHeV5USljtebrkihdNZ1BCtehZT3RvQAn8fJUfMJ1FYAi39WJnJ_XlaWHU-a_WkxNAiULan3AuoguddUdpgBsXMIaHt0th-GrRI=@protonmail.com
Whole thread Raw
In response to Re: php connection failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: php connection failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

On Sunday, August 8th, 2021 at 2:15 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> ourdiaspora ourdiaspora@protonmail.com writes:
>
> > psql -d cpacweb -U cpaca
> >
> > psql: FATAL: Peer authentication failed for user "cpaca"
>
>  It's a gold
>
> plated certainty that the default packet filter configuration
>
> wouldn't allow traffic to port 5432 from off-machine.

A quick ddg search revealed:

sudo ss -tulpn
Netid  State      Recv-Q Send-Q Local Address:Port               Peer Address:Port
tcp    LISTEN     0      128     ::1:5432                 :::*                   users:(("postgres",pid=21794,fd=3))

Is the correct conclusion from this output, that the port 5432 is open?




pgsql-general by date:

Previous
From: ourdiaspora
Date:
Subject: Re: php connection failure
Next
From: Matthias Apitz
Date:
Subject: Re: (13.1) pg_basebackups ./. pg_verifybackup