Skip site navigation (1) Skip section navigation (2)

BUG #1769: pg_dumpall fails to run

From: "Nigel Kukard" <nkukard(at)lbsd(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1769: pg_dumpall fails to run
Date: 2005-07-14 12:41:39
Message-ID: 20050714124139.2C9BBF0B14@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1769
Logged by:          Nigel Kukard
Email address:      nkukard(at)lbsd(dot)net
PostgreSQL version: 8.0.3
Operating system:   Linux
Description:        pg_dumpall fails to run
Details: 

On a clean build of postgresql 8.0.3, I seem to encounter a problem when
using pg_dumpall.

I'm trying to run...

# pg_dumpall -U postgres> backup.pgsql

My postgres password is "test".

When pg_dumpall prompts me for the password I type it in, and press enter
only to get another password prompt.

Apon looking in /var/log/pgsql, i see the following error...
LOG:  unexpected EOF on client connection

Using psql I can get into the template1 database fine using...
psql -U postgres template1

My pg_hba.conf file looks like this...
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres    md5
local   test        test        md5
local   template1   all         md5


Any help much appreciated!

Regards
Nigel

Responses

pgsql-bugs by date

Next:From: marco_0160Date: 2005-07-14 15:48:36
Subject: [postgres] Betrifft: Datumsfeld leer lassen
Previous:From: Tom LaneDate: 2005-07-14 12:38:27
Subject: Re: BUG #1756: PQexec eats huge amounts of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group