Error on pg_dumpall (PG8.0 B2)

From: "Alexander Ternopolski" <aternopolski(at)aval(dot)ua>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Error on pg_dumpall (PG8.0 B2)
Date: 2004-09-28 10:06:55
Message-ID: 000801c4a542$e28e55e0$3b192e0a@tern
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL 8.0 Beta 2
OS: Windows 2000/XP
------------------------
Run: pg_dumpall -U dba
Output:
...

ALTER USER dba WITH PASSWORD '111'
CREATEDB CREA
TEUSER;

\connect monk

pg_dump.exe: [archiver (db)] connection to database "monk" failed:
FATAL: user "'dba'" does not exist
pg_dumpall.exe: pg_dump failed on database "monk", exiting
----------------------------------------------------------------------
Run: pg_dumpall -U dba -p 5434
Output:
...
ALTER USER dba WITH PASSWORD '111'
CREATEDB CREATEUSER;

\connect monk

pg_dump.exe: [archiver (db)] connection to database "monk" failed: could
not
connect to server: Can't assign requested address (0x00002741/10049)
Is the server running on host "???" and accepting
TCP/IP connections on port '5432'?
pg_dumpall.exe: pg_dump failed on database "monk", exiting
----------------------------------------------------------------------
Run: pg_dumpall.exe -U dba -p 5432 -h 127.0.0.1
Output:
...
ALTER USER dba WITH PASSWORD '111'
CREATEDB CREATEUSER;

\connect monk

pg_dump.exe: [archiver (db)] connection to database "monk" failed: could not translate host name "'127.0.0.1'" to address: Unknown host
pg_dumpall.exe: pg_dump failed on database "monk", exiting

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas LeBlanc 2004-09-28 16:48:19 ODBC Driver and ADO...
Previous Message Mahesh Saravanan 2004-09-28 07:17:27