Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread Adrian Klaver
On 9/25/23 19:30, shashidhar Reddy wrote: Thank you Adrian! I will apply the patch and see. Just to be clear 11.21 represents the changes from 16 different minor releases. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread shashidhar Reddy
Thank you Adrian! I will apply the patch and see. On Tue, 26 Sept, 2023, 12:53 am Adrian Klaver, wrote: > On 9/25/23 11:55, shashidhar Reddy wrote: > > Thank you Erik, > > > > Not all queries are truncated at same size,different queries different > > sizes but all 11.5 servers are behaving in sa

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread shashidhar Reddy
Thank you Erik, Not all queries are truncated at same size,different queries different sizes but all 11.5 servers are behaving in same manner. On Mon, 25 Sept, 2023, 5:33 pm Erik Wienhold, wrote: > On 2023-09-25 16:54 +0530, shashidhar Reddy wrote: > > We are using postgres 11.5 on Ubuntu we h

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread Adrian Klaver
On 9/25/23 11:55, shashidhar Reddy wrote: Thank you Erik, Not all queries are truncated at same size,different queries different sizes but all 11.5 servers are behaving in same manner. FYI, the last minor release for version is 11.21. You are missing 16 bug/security fixes. I would update to

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread Erik Wienhold
On 2023-09-25 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 and also when I check in pgadmin for > current queries I coul

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread shashidhar Reddy
Hi Laurenz, Iog is also showing few lines that is incomplete statement. On Mon, 25 Sept, 2023, 5:05 pm Laurenz Albe, 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

Re: Postgres 11.5 not logging all sqls

2023-09-25 Thread Laurenz Albe
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 certain