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

2016-11-13 Thread aws backup
6 1:01 PM, aws backup wrote: >> thank you so much. >> With your help I could solve all my problems. >> DaVinci has a bug somewhere with the database configuration. >> I installed everything new and set all auth method to trust instead of md5 >> which was default from Da

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

2016-11-13 Thread aws backup
automatic daily shell script with a pg_dumpall. Will see. Thank you. > On 13 Nov 2016, at 23:12, Adrian Klaver wrote: > > On 11/13/2016 01:01 PM, aws backup wrote: >> Hi, >> >> thank you so much. >> With your help I could solve all my problems. >> DaVinc

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

2016-11-13 Thread aws backup
at 19:13, Adrian Klaver wrote: > > On 11/13/2016 09:04 AM, aws backup wrote: >> Hi Adrian, >> >> thank you for the explanation. >> I will look into you links. >> >> I am doing this because I want to make backups from the >> database. Ideally automatic

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

2016-11-13 Thread aws backup
Every database related question I ask the Blackmagic support stays unanswered. For example: How can I restart the SQL server? Oh sorry we can't help you with this … ? Thank you. Robert > On 13 Nov 2016, at 18:09, Adrian Klaver wrote: > > On 11/13/2016 05:51 AM, aws backup wrote

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

2016-11-13 Thread aws backup
maybe I am wrong with these assumptions. > That is optional and I sort of doubt the application using one. You think DaVinci is not using any password … ? Thank you. Robert > On 13 Nov 2016, at 17:57, Adrian Klaver wrote: > > On 11/13/2016 05:51 AM, aws backup wrote: >> H

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

2016-11-13 Thread aws backup
; On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver > mailto:adrian.kla...@aklaver.com>> 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 o

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

2016-11-13 Thread aws backup
od to trust for all users. This worked for now. Thank you. Best Regards, Robert > On 12 Nov 2016, at 23:31, 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 >

[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 "

Re: [GENERAL] libpq binary format for contrib/cube type?

2009-01-28 Thread aws
OK, I found another way to send the data using the array format and "cube($1::float8[])". Thanks! Andy. On Jan 28, 2009, at 2:47 PM, Tom Lane wrote: There isn't one --- contrib/cube doesn't provide send/receive functions at all. regards, tom lane -- Sent via pgsql

[GENERAL] libpq binary format for contrib/cube type?

2009-01-28 Thread aws
I'm using libpq with a prepared query, and I'd like to access the contrib/cube type using the binary format. The documentation describes the text format for cubes but doesn't say what the binary format is. I glanced at the source code but... its complicated. :) Any help is appreciated.