pg_dumpall failed

From: Le Gourou qui fait le support <flo(at)mnc(dot)ch>
To: pgsql-ports(at)postgresql(dot)org
Subject: pg_dumpall failed
Date: 2001-06-14 18:31:49
Message-ID: 3B290315.C0EFB5C3@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Hi,

I'm currently using PostgreSQL v7.0.3 and I have tried to upgrade to
v7.1.2.

The installation (./configure, gmake, gmake install) of v7.0.3 doesn't
provide any error message,
but I'm not able to use the pg_dumpall binary, even with -p option it
says it's not able to connect to postmaster (see message bellow).

Command line: pg_dumpall -p6947 > /home/postgres/data/postgres.out

Error message:

psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
psql: connectDBStart() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?

I have checked and the daemon is running accepting connections on
TCP/IP. I'm also able to use pg_dump (I use it to backup the database
every night).

It's a makor problem for me because I'm not able to "migrate" the DB to
the new version.

I provide you bellow the configure option I have used:

Configure line: ./configure --prefix=$PGDIR --with-pgport=6947
--without-CXX (where $PGDIR=/usr/local/pgsql)

Thanks for your help

Florian Gossin

Browse pgsql-ports by date

  From Date Subject
Next Message Ulrich Neumann 2001-06-14 21:19:37 definition of PortalBuffer
Previous Message guard 2001-06-14 14:32:35 install on cygwin error