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