On Mon, Sep 5, 2022 at 7:40 PM Jeffrey Walton wrote:
>
> Or maybe better, what part of the manual discusses auth failures so I
> can read about them?
>
The chapter named "Client Authentication ".
https://www.postgresql.org/docs/current/client-authentication.html
It even has a subchapter named
> On Sep 5, 2022, at 19:40, Jeffrey Walton wrote:
> And finally, try the new password:
>
>PGPASSWORD=hi...HS psql -U postgres
>psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed:
>FATAL: Peer authentication failed for user "postgres"
If it's
Hi Everyone,
I'm struggling to set the admin/postgres user password and use it on
Fedora 36. This is a fresh install on a new VM. The admin's name is
postgres. We created the user, and used the passwd utility to set the
Linux password 'hi...HS'. The ellipses are over 28 characters, so it
is a
On Tue, Aug 30, 2022 at 1:38 PM Matheus Martin <
matheus.mar...@voidbridge.com> wrote:
> Our Postgres recently started reporting considerably different execution
> times for the same query. When executed from our JDBC application the
> Postgres logs report an average execution time of 1500 ms
`auto_explain.log_min_duration` is set to 500 ms.
On Mon, 5 Sept 2022 at 12:35, Peter J. Holzer wrote:
> On 2022-09-02 10:58:58 +0100, Matheus Martin wrote:
> > Yes, we do see some plans logged by the auto_explain. We couldn't find a
> > `auto_explain.log_min_duration_statements` setting
>
>
Hi Kyotaro,
This helped, thanks.
Regards,
Meera
-Original Message-
From: Kyotaro Horiguchi
Sent: Monday, September 5, 2022 7:31 AM
To: Meera Nair
Cc: guilla...@lelarge.info; pgsql-general@lists.postgresql.org; Punit Pranesh
Koujalgi
Subject: Re: Unable to archive logs in standby
On Mon, Sep 05, 2022 at 04:55:28PM +0800, Yi Sun wrote:
> How to check if the checkpoint is finished in sql script please? We know
> that the log file will show it, but we want to check it in sql then can
> easily be used by ansible, thanks
Well, if the command "checkpoint" finished, and
Hello all,
We want to restart postgresql 3 nodes(2 replica nodes) by ansible as below
steps:
1. Restart 2 replica nodes one by one
2. Run checkpoint in the leader node
3. Once checkpoint finished, restart the leader node
How to check if the checkpoint is finished in sql script please? We know
Hello,
Sorry for delay... I had to go on leave..
Checked, it's our mistake here. The issue is not what I described, but in the
replicated database where the constraint was not updated. Correcting the
constraint there solved this issue.
Sorry for not checking properly before coming here.