Re: php connection failure

From: ourdiaspora <ourdiaspora(at)protonmail(dot)com>
To:
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: php connection failure
Date: 2021-08-10 09:05:13
Message-ID: efaVW60KjHeV5USljtebrkihdNZ1BCtehZT3RvQAn8fJUfMJ1FYAi39WJnJ_XlaWHU-a_WkxNAiULan3AuoguddUdpgBsXMIaHt0th-GrRI=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

> ourdiaspora ourdiaspora(at)protonmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2021-08-10 09:38:57 Re: (13.1) pg_basebackups ./. pg_verifybackup
Previous Message ourdiaspora 2021-08-10 08:59:11 Re: php connection failure