Re: minimal wal_level on subscriber

2020-01-19 Thread Arnaud L.
Le 17/01/2020 à 19:07, Laurenz Albe a écrit : 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 shut

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

2020-01-19 Thread Ramesh Penuballi
Hi Ron, I have checked on my Jenkins server.bashrc and. bashprofiles filed of root and Jenkins users but didn't find anything about postgresql path. It might be the reason that Jenkins and Postgresql services are running in two separate Linux instances. >From the Linux server where JENKINS in

Re: Are PostgreSQL functions that return sets or tables evaluated lazily or eagerly?

2020-01-19 Thread Gerald Britton
Love to see "return next" work like python yield! Anyone working on that? On Sun, Jan 5, 2020, 5:46 PM Tom Lane wrote: > Gerald Britton writes: > > Back to where I started in my top post: I became interested in this due > to > > the doc note on returning a cursor and that it can be an efficien

testing post through gmane.io

2020-01-19 Thread George Neuner
gmane.org is now gmane.io hope this works

Re: A question about rules

2020-01-19 Thread Adrian Klaver
On 1/19/20 2:32 AM, stan wrote: Please post to list also. Ccing list. On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote: On 1/18/20 8:53 AM, stan wrote: So, I just discovered the rules system. As I understand it, it can be used to rewrite queries before they are passed to the query