Re: [GENERAL] BDR problem

2015-09-13 Thread Giovanni Maruzzelli
http://bdr-project.org/docs/next/index.html On Fri, Sep 11, 2015 at 11:21 PM, Charles Lynch < charleslynchpostgre...@gmail.com> wrote: > So for about a month now, we've been getting things prepared to use a BDR > cluster in a production, multi-region setup on aws. Our initial testing > produced s

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread John R Pierce
On 9/13/2015 1:57 PM, Dale Seaburg wrote: I have reached my wit's end. lol I installed postgresql (9.3.9) and pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I get an error "password authentication failed for user "postgres" ". Ubuntu (14.04.3). I created a postgres

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Jan de Visser
On September 13, 2015 03:57:51 PM Dale Seaburg wrote: > I have reached my wit's end. lol I installed postgresql (9.3.9) and > pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I > get an error "password authentication failed for user "postgres" ". > Ubuntu (14.04.3). > > I c

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Adrian Klaver
On 09/13/2015 01:57 PM, Dale Seaburg wrote: I have reached my wit's end. lol I installed postgresql (9.3.9) and pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I get an error "password authentication failed for user "postgres" ". Ubuntu (14.04.3). I created a postgres us

Re: [GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Adrian Klaver
On 09/13/2015 01:57 PM, Dale Seaburg wrote: I have reached my wit's end. lol I installed postgresql (9.3.9) and pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I get an error "password authentication failed for user "postgres" ". Ubuntu (14.04.3). I created a postgres us

[GENERAL] Ubuntu installed postgresql password failure

2015-09-13 Thread Dale Seaburg
I have reached my wit's end. lol I installed postgresql (9.3.9) and pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I get an error "password authentication failed for user "postgres" ". Ubuntu (14.04.3). I created a postgres user BEFORE installing postgresql/pgadmin t

Re: [GENERAL] Forced external sort?

2015-09-13 Thread Tomas Vondra
On 09/13/2015 01:53 AM, Jeff Janes wrote: On Fri, Sep 11, 2015 at 11:45 AM, mailto:r...@winmutt.com>> wrote: I've got a poorly indexed query and was attempting a quick work around in production by increasing work_mem when it was called. EXPLAIN ANALYZE is telling me this: Sort