Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 11.5 not logging all sqls - Mailing list pgsql-general

From shashidhar Reddy
Subject Re: Postgres 11.5 not logging all sqls
Date
Msg-id CAH=zU4vjBt034rspM5R1RETVzuxe1uQ_Dr-w-R37+nrajfsAjA@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 11.5 not logging all sqls  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
Hi Laurenz,

Iog is also showing few lines that is incomplete statement.

On Mon, 25 Sept, 2023, 5:05 pm Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Mon, 2023-09-25 at 16:54 +0530, shashidhar Reddy wrote:
> We are using postgres 11.5 on Ubuntu we have enabled logging and set
> log_statements to all but when I checked the statements in the logs I
> can see only first few lines of the query

I don't know about pgAdmin, but the log will certainly have the complete
statement.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Postgres 11.5 not logging all sqls
Next
From: Erik Wienhold
Date:
Subject: Re: Postgres 11.5 not logging all sqls