Re: Setting up streaming replication problems

Am 22.01.2018 um 07:39 schrieb Thiemo Kellner: Hi all I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have two clusters main (master) and main2 (hot standby). I tried

Setting up streaming replication problems

Hi all I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have two clusters main (master) and main2 (hot standby). I tried with Rigg's book and the PostgreSQL documentation

Re: array_agg and/or =ANY doesn't appear to be functioning as I expect

Hannes, Thanks for your observations.. Will take a look at the data. Regards, Rhys On Jan 20, 2018 11:00 PM, "Hannes Erven" wrote: Hi Rhys, Am 2018-01-21 um 02:42 schrieb Rhys A.D. Stewart: > Greetings All, > I'm having an issue which is very perplexing. The having

Re: Best non-networked front end for postgresql

On Sun, Jan 21, 2018 at 11:57:39AM -0700, Sherman Willden wrote: > Basic question 1: Which non-networked front-end would work best for me? > > Basic question 2: I am seriously considering HTML fields to capture and > process the information. So to connect with postgresql what do I need to > know?

Re: How to measure query time - with warm up and cached data

2018-01-21 13:53 GMT-08:00 Peter J. Holzer : > On 2018-01-21 12:45:54 -0800, Neto pr wrote: > > I need to know the actual execution time of a query, but considering > that the > > data is already cached. I also need to make sure that cached data from > other > > queries is

Re: How to measure query time - with warm up and cached data

On 2018-01-21 12:45:54 -0800, Neto pr wrote: > I need to know the actual execution time of a query, but considering that the > data is already cached. I also need to make sure that cached data from other > queries is cleared. > I believe that in order to know the real time of a query it will be

Re: Best non-networked front end for postgresql

On 01/21/2018 10:57 AM, Sherman Willden wrote: Name: Sherman Single laptop: Compaq 6710b Operating System: Ubuntu 17.10 Postgresql: 9.6 Used for: Just me and my home database Seeking advice: Best non-networked front-end Considerations: I am retired and want to create my own database and

Re: Best non-networked front end for postgresql

On 21/01/18 19:05, Vincenzo Romano wrote: > 2018-01-21 19:57 GMT+01:00 Sherman Willden : >> Name: Sherman >> >> Single laptop: Compaq 6710b >> >> Operating System: Ubuntu 17.10 >> >> Postgresql: 9.6 >> >> Used for: Just me and my home database >> >> Seeking advice: Best

How to measure query time - with warm up and cached data

Hi all, I need to know the actual execution time of a query, but considering that the data is already cached. I also need to make sure that cached data from other queries is cleared. I believe that in order to know the real time of a query it will be necessary to "warm up" the data to be inserted

Re: Best non-networked front end for postgresql

2018-01-21 19:57 GMT+01:00 Sherman Willden : > Name: Sherman > > Single laptop: Compaq 6710b > > Operating System: Ubuntu 17.10 > > Postgresql: 9.6 > > Used for: Just me and my home database > > Seeking advice: Best non-networked front-end > > Considerations: I am retired

Best non-networked front end for postgresql

Name: Sherman Single laptop: Compaq 6710b Operating System: Ubuntu 17.10 Postgresql: 9.6 Used for: Just me and my home database Seeking advice: Best non-networked front-end Considerations: I am retired and want to create my own database and database captures. I have experience with PERL

Re: Notify client when a table was full

2018-01-21 19:31 GMT+01:00 Francisco Olarte : > On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier > wrote: >> On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: > ... >>> How do you define "full"? The only possible and meaningful

Re: Notify client when a table was full

On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier wrote: > On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: ... >> How do you define "full"? > There could be two definitions here: > 1) A table contains more data than a customly-defined amount of data >

License question regarding distribution of binaries

Hi, My name is Rafał and I would like prepare lib to setup and run Pg within integration tests. To do it I would like to prepare on Windows nuget package containing necessary Pg's binaries. I would like to keep it in separate folder with enclosed Pg's license. It would be distributed in 1

Re: Notify client when a table was full

On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: > On 19/01/18 15:34, hmidi slim wrote: >> Hi, >> I'm looking for a function in postgresql which notify the client if a >> table was full or not.So I found the function Notify >>