Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208

Thank you, and sorry for overlooking your comment. At Thu, 14 Nov 2019 12:28:13 -0500, Tom Lane wrote in > Kyotaro Horiguchi writes: > > At Wed, 2 Oct 2019 19:24:02 -0400, Stephen Frost wrote > > in > >> * Tom Lane (t...@sss.pgh.pa.us) wrote: > >>> Yeah, those messages are all pretty ancient

postgresql commands(psql,createdb,dropdb) are not working from shell script

Dear Team, I am using postgresql 9.2.12 version and I am facing an issue while running the executing the commands createdb,dropdb,psql commands in the shell script which is running from Jenkins to restore prod data into stage environment. Jenkins job is failing with the below output.I have verif

Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

Hi To the respected PostgreSQL international team Please let me know that automatic table partitioning is possible in pgsql 12 or not without using trigger function Regards Durgamahesh Manne

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Does the Jenkins' $PATH variable have the Postgres binaries' location? On 1/17/20 2:47 AM, ramesh penumalli wrote: Dear Team, I am using postgresql 9.2.12 version and I am facing  an issue while running the executing the commands createdb,dropdb,psql commands in the shell script which is runn

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Dear Ron, Thanks for looking into this query. Could you please let me know how can I check the same. We are able take our production backup from the Jenkins server, and the issue is with our uat database server only. Could you please let me know how to check the path on Jenkins server as I am

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

The Jenkins server needs to be able to find the Unix executables dropdb, createdb and psql. I don't know *anything* about Jenkins, or even whether or not Jenkins runs on the same box as Postgres, but there's *some* shell script *somewhere* that points $PATH to the proper Postgres binaries. O

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Thanks once again for sharing the info. Let me check and get back to you. Thanks and Regards Ramesh Penuballi On Fri, 17 Jan, 2020, 18:43 Ron, wrote: > The Jenkins server needs to be able to find the Unix executables dropdb, > createdb and psql. > > I don't know *anything* about Jenkins, or eve

Regarding automatic table partitioning without using trigger function in pgsql 12 is possible or not

Hi To the respected PostgreSQL international team Please let me know that automatic table partitioning without using trigger function is possible in pgsql 12 or not ? Regards Durgamahesh Manne

Re: Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

Greetings, * Durgamahesh Manne (maheshpostgr...@gmail.com) wrote: > Please let me know that automatic table partitioning is possible in pgsql > 12 or not without using trigger function The approach I'd recommend for automatically getting new table partitions created, at least today, is to use pg_

Re: Regarding automatic table partitioning in PostgreSQL 12 version is possible or not

On Fri, Jan 17, 2020 at 7:43 PM Stephen Frost wrote: > Greetings, > > * Durgamahesh Manne (maheshpostgr...@gmail.com) wrote: > > Please let me know that automatic table partitioning is possible in pgsql > > 12 or not without using trigger function > > The approach I'd recommend for automatically

Re: minimal wal_level on subscriber

On Fri, 2020-01-17 at 08:43 +0100, Arnaud L. wrote: > > > is it OK to set wal_level to minimal on the subscriber side of the > > > logical replication ? > > > > Yes, if you don't want physical backups. > > You mean online physical backups ? > I could still shutdown the subscriber and take an off

RPC via WebSockets.

Hello! Who needs to talk to Postgres right from a WEB-browser via WebSockets? For example, conveniently call storable functions/procedures? Yes, i know about PostgREST. But I want to focus on RPC via WebSockets without all these REST or "give me contents of that table by this URL" stuff... I'm t

Re: jsonb_set() strictness considered harmful to data

On Wed, Jan 08, 2020 at 05:24:05PM +1030, Andrew Dunstan wrote: On Wed, Jan 8, 2020 at 7:08 AM Pavel Stehule wrote: Hi po 6. 1. 2020 v 22:34 odesílatel Andrew Dunstan napsal: Updated version including docco and better error message. cheers andrew I think so my objections are solved.

Re: jsonb_set() strictness considered harmful to data

Hello, January 17, 2020 5:21 PM, "Tomas Vondra" wrote: > On Wed, Jan 08, 2020 at 05:24:05PM +1030, Andrew Dunstan wrote: > >> On Wed, Jan 8, 2020 at 7:08 AM Pavel Stehule wrote: >>> Hi >>> >>> po 6. 1. 2020 v 22:34 odesílatel Andrew Dunstan >>> napsal: >> >> Updated version including docco

Re: jsonb_set() strictness considered harmful to data

> On Jan 17, 2020, at 4:28 PM, Ariadne Conill wrote: > > Hello, > > January 17, 2020 5:21 PM, "Tomas Vondra" > wrote: > > Thank you very much for coming together and finding a solution to this bug! > > Ariadne Let’s leave it at “issue” :)

Re: RPC via WebSockets.

This is a very common task, definitely. As for WebSockets, there is an addition to PostgREST, postgrest-websockets https://github.com/diogob/postgres-websockets#readme PostgREST is not only for "give me contents", you can write functions (in any PL) and call them using POST /rpc/functionname. Th

Re: RPC via WebSockets.

On Sat, 18 Jan 2020, 05:54 Nikolay Samokhvalov, wrote: > This is a very common task, definitely. > > As for WebSockets, there is an addition to PostgREST, postgrest-websockets > https://github.com/diogob/postgres-websockets#readme > Yep, but as it's addition, it's not first class citizen and requ