Can't import databases with pg_dump. Why?

From: "Antonio G(dot) - Geotronix" <nightnavigator(at)libero(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't import databases with pg_dump. Why?
Date: 2002-11-02 13:33:19
Message-ID: 20021102133319.GB606@geolandia.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I'm trying to import some databases I had on redhat 7.2 (think it had
postgressql-7.1.x series but not sure) to my new Debian woody
installation (postgresql 7.2.1-2woody2). I created a database called
'famiglia' under the postgres user. Then, always by postgres user i did:

gaia:/etc/postgresql$ pg_dump famiglia < /mnt/redhat/home/postgres_postgres \
/famiglia.dump

and this is what I got as a result:

--
-- Selected TOC Entries:
--
\connect - postgres

--
-- TOC Entry ID 2 (OID 16556)
--
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
--

CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE 'C';

--
-- TOC Entry ID 3 (OID 16557)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
--

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
"plpgsql_call_handler" LANCOMPILER '';

gaia:/etc/postgresql$

Obviuosly there are no relations in the database because the import
failed somewhere and I can't figure out where. I'm not getting any deubg
info from /var/log/postgresql.log even though I've set:

debug_level = 1
debug_print_query = on
log_connections = on
log_pid = on
log_timestamp = on
syslog = 2
# if syslog is 0, turn silent_mode off!
silent_mode = off
syslog_facility = LOCAL0
trace_notify = off
max_connections = 64
# shared_buffers must be at least twice max_connections, and not less
# than 16
shared_buffers = 128
# TCP/IP access is allowed by default, but the default access given in
# pg_hba.conf will permit it only from localhost, not other machines.
tcpip_socket = 1

in /etc/postgresql/postgresql.conf and:

local all ident
sameuser
host all 127.0.0.1 255.0.0.0 ident
sameuser
host all 0.0.0.0 0.0.0.0 reject
host all 192.168.0.3 255.255.255.0 trust

in /etc/postgresql/pg_hba.conf. The only info I get form the log file
are 2 lines:

FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0]
FindExec: found "/usr/lib/postgresql/bin/postmaster" using argv[0]

when I give '/etc/init.d/postgresql restart'.

Any suggestions on what's happening? and how I can solve this. It would
be a tedious work to create all databases from scratch and import all
tables in the new databases.....

Thanyou and bye.

Antonio G.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antonio G. - Geotronix 2002-11-02 13:55:10 [OT] I'm not recieving my ML mail.
Previous Message Hubert depesz Lubaczewski 2002-11-02 09:56:08 Re: problems with building recent cvs snaphots