Re: [GENERAL] Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists

2016-11-12 Thread otar shavadze
Tried OPERATOR(pg_catalog.@>) as Tom mentioned, but still, don't get fast performance when value does not existed in any array. Also "played" with many different ways, gin, gist indexes (gin with and without *gin__int_ops*) but, always, there was some situation, where search in array was

Re: [GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-12 Thread Scott Marlowe
On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver wrote: > On 11/12/2016 01:20 PM, aws backup wrote: >> >> Hi, >> >> I try to make pg_dumpall backups from a PostgreSQL 9.5 server which is >> part of the DaVinci Resolve 12.5.3 App on a Mac OS X 10.11.6 system. >> >>

Re: [GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-12 Thread Adrian Klaver
On 11/12/2016 01:20 PM, aws backup wrote: Hi, I try to make pg_dumpall backups from a PostgreSQL 9.5 server which is part of the DaVinci Resolve 12.5.3 App on a Mac OS X 10.11.6 system. Unfortunately I get following failure message: pg_dumpall: could not connect to database "template1":

[GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-12 Thread aws backup
Hi, I try to make pg_dumpall backups from a PostgreSQL 9.5 server which is part of the DaVinci Resolve 12.5.3 App on a Mac OS X 10.11.6 system. Unfortunately I get following failure message: pg_dumpall: could not connect to database "template1": FATAL: password authentication failed for user