Re: Postgres read jsonb content from stdin

On Sat, Dec 26, 2020 at 3:19 AM Markur Sens wrote: > I'm trying to build a few data pipelines with Unix tools but can't figure > out how to insert in a slurp mode (e.g. not COPY line by line) content > inside a variable. > > The question is, how can I achieve the same result, without having to h

Re: Problem with ssl and psql in Postgresql 13

Here's a more complete patchset. 0001 is the same libpq fixes I posted before. 0002 fixes a collection of random server-side issues, including: * The GSS encryption code figured it could just ereport(ERROR) or ereport(FATAL) for unrecoverable errors. This seems entirely unsafe, because elog.c w

Re: alter system command

On 12/27/20 12:00 AM, Ahmet Demir wrote: Hi, Please check postgresql.auto.conf file. https://www.postgresql.org/docs/13/sql-altersystem.html For a more generic option do: select * from pg_settings where name = 'archive_command'; http

Re: Include 3 previous tokens in syntax error message

Andrus writes: > Postgres returns unreadable syntax error messageges like > Syntax error at or near ')' > How to fix this so that 3 last tokens are returned in message like > Syntax error at or near ' i > )' Our take on this is that it's the client code's responsibility to present a useful error

Include 3 previous tokens in syntax error message

Hi! Postgres returns unreadable syntax error messageges like Syntax error at or near ')' If there are many ) characters in query, it is not possible to find the palce where error occurs. STATEMENT_POSITION is difficult to use since drivers perform parameter replacements which makes this dif

Re: alter system command

Hi, Please check postgresql.auto.conf file. https://www.postgresql.org/docs/13/sql-altersystem.html Ahmet On Sun, 27 Dec 2020 at 10:53, Atul Kumar wrote: > hi, > > I have set archive_command like below: > > alter system set archive_command ='pgbackrest --stanza=main archive-push > %'; > > then