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
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.
>>
>>
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":
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