pg_dumpall fails

From: Ivan <Ivan-Sun1(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dumpall fails
Date: 2004-10-01 14:13:35
Message-ID: 1829512687.20041001181335@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

When i do:

pg_dumpall -D --disable-dollar-quoting -U postgres -h hostname > cluster.backup

the following error occurs:

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

database "example" exist in the cluster
real host name i replaced with string hostname

WinXp SP2
PostgreSQL 8.0beta2

----------------------------------------------
Then I get from cvs latest version
(PostgreSQL 8.0.0beta3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1))

Perform initdb,
with psql do

create database "example1" with encoding = 'WIN';

and quit.

pg_dumpall -D --disable-dollar-quoting -U postgres -h localhost

fails with:
--
-- PostgreSQL database cluster dump
--

\connect "template1"

--
-- Users
--

--
-- Database creation
--

CREATE DATABASE example1 WITH TEMPLATE = template0 OWNER = postgres ENCODING = 'WIN';

--
-- Users
--

ALTER USER postgres WITH CREATEDB CREATEUSER;

\connect example1

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

and

pg_dumpall -D --disable-dollar-quoting -U postgres

outputs following:

--
-- PostgreSQL database cluster dump
--

\connect "template1"

--
-- Users
--

--
-- Database creation
--

CREATE DATABASE example1 WITH TEMPLATE = template0 OWNER = postgres ENCODING = 'WIN';

--
-- Users
--

ALTER USER postgres WITH CREATEDB CREATEUSER;

\connect example1

pg_dump.exe: [archiver (db)] connection to database "example1" failed: FATAL: user "'postgres'" doe
s not exist
pg_dumpall.EXE: pg_dump failed on database "example1", exiting

--
Best regards,
Ivan mailto:Ivan-Sun1(at)mail(dot)ru

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2004-10-01 14:51:52 Re: PQdb() fails with coredump when PQconnectDB() passed invalid parameter.
Previous Message Alexander Zhiltsov 2004-10-01 08:46:33 Bug in PostrgeSQL 8.0beta