Hello,
Im really struck with trouble when I first tried to copy a database
to another host. I followed the dos and did:
host1 ~> pg_dump <database> > dump
host2 ~> cat dump | psql <database>
Now I tried to check wether all went right and did
host2 ~> pg_dump <database> > dump2
So dump and dump2 shouldn't differ (at least not in importantly) I think.
But there is a great difference between the database. About half of the
table is missing. To make sure I tried
host1 ~> cat dump | psql <database2>
host1 ~> pg_dump <database2> > dump2
to verify if this problem also remains if I'm sitting on the same
database server. And so it was :-((.
How could that happen????
I append the output while the psql-insertion to this mail. May be it
gives some hints for those not as new to PostgreSQL as I.
I'm using PostgreSQL 7.0.2 on a Debian GNU/Linux system.
Kind regards
Andreas.
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'arbeitsgruppetype_pkey'
for table 'arbeitsgruppetype'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'webseite_pkey' for table
'webseite'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'arbeitsgruppe_pkey' for
table 'arbeitsgruppe'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'webproject_pkey' for
table 'webproject'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'menu_pkey' for table
'menu'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'menuitem_pkey' for table
'menuitem'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'standort_pkey' for table
'standort'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
'mitarbeiterposition_pkey' for table 'mitarbeiterposition'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'tlkpkontakttype_pkey'
for table 'tlkpkontakttype'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'tlkpkontaktrange_pkey'
for table 'tlkpkontaktrange'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'publikation_pkey' for
table 'publikation'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'statusdef_pkey' for
table 'statusdef'
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'mitarbeiter_pkey' for
table 'mitarbeiter'
ERROR: copy: line 1, Bad timestamp external representation '07.01.2000 08:19:00.00
/etc/localtime'
PQendcopy: resetting connection
ERROR: copy: line 1, Bad timestamp external representation '06.01.2000 23:00:00.00
/etc/localtime'
PQendcopy: resetting connection
ERROR: copy: line 1, Bad timestamp external representation '06.01.2000 23:00:00.00
/etc/localtime'
PQendcopy: resetting connection
You are now connected as new user tillea.
CREATE
CHANGE
CHANGE
CREATE
CHANGE
CHANGE
CREATE
CHANGE
CHANGE
CREATE
CHANGE
CHANGE
CREATE
CHANGE
CHANGE
CREATE
CHANGE
CHANGE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
