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