Re: [GENERAL] Question about "grant create on database" and pg_dump/pg_dumpall

2016-07-04 Thread Haribabu Kommi
On Fri, Jul 1, 2016 at 5:49 AM, David G. Johnston wrote: > > I have to agree. At worse this is a documentation bug but I do think we > have an actual oversight here - although probably not exactly this or the > linked bug report. > > Testing this out a bit on 9.5 Ubuntu 14.04 - I believe the last

Re: [GENERAL] Unable to recovery due missing wal_file

2016-07-04 Thread Martín Marqués
El 04/07/16 a las 01:06, Adrian Klaver escribió: > On 07/03/2016 06:21 PM, Patrick B wrote: >> >> >> Not sure that would have mattered for the reasons below. >> >> You might want to take a look at the below: >> >> https://www.postgresql.org/docs/9.5/static/wal.html >> >> In particul

[GENERAL] 9.6 Beta 2 Performance Regression on Recursive CTE

2016-07-04 Thread Nicholson, Brad (Toronto, ON, CA)
Hi, I'm seeing a performance regression on 9.6 Beta 2 compared to 9.5.3. The query is question is a recursive query on graph data stored as an adjacency list. While this is example is fairly contrived, it mimics the behavior I am seeing on real data with more realistic queries. The example b

Re: [GENERAL] psql connection option: statement_timeout

2016-07-04 Thread Craig Boyd
On 07/04/2016 11:01 AM, Daniel Verite wrote: Craig Boyd wrote: So to put it another way: is there a list that shows what options are available during the connection event or as part of the connection string? Yes, but it belongs to the chapter on libpq. The psql docpage merely points to

Re: [GENERAL] psql connection option: statement_timeout

2016-07-04 Thread Daniel Verite
Craig Boyd wrote: > So to put it another way: is there a list that shows what options are > available during the connection event or as part of the connection string? Yes, but it belongs to the chapter on libpq. The psql docpage merely points to it: -d dbname --dbname=dbname

Re: [GENERAL] Cluster on NAS and data center.

2016-07-04 Thread Melvin Davidson
On Mon, Jul 4, 2016 at 10:01 AM, Adrian Klaver wrote: > On 07/04/2016 02:35 AM, Krzysztof Kaczkowski wrote: > >> Hello everyone, >> >> Right now we have PostgreSQL on Windows Server (main data center) and >> cluster is placed on NAS. We have emergency data center on UNIX >> architecture. We want

Re: [GENERAL] Cluster on NAS and data center.

2016-07-04 Thread Adrian Klaver
On 07/04/2016 02:35 AM, Krzysztof Kaczkowski wrote: Hello everyone, Right now we have PostgreSQL on Windows Server (main data center) and cluster is placed on NAS. We have emergency data center on UNIX architecture. We want that emergency data center could continue work on PostgreSQL cluster tha

[GENERAL] Cluster on NAS and data center.

2016-07-04 Thread Krzysztof Kaczkowski
Hello everyone, Right now we have PostgreSQL on Windows Server (main data center) and cluster is placed on NAS. We have emergency data center on UNIX architecture. We want that emergency data center could continue work on PostgreSQL cluster that has been used by Windows PostgreSQL. We know that s