From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump and restore |
Date: | 2000-08-10 14:45:29 |
Message-ID: | Pine.LNX.4.21.0008101636140.14268-300000@wr-linux02.rki.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Attachment | Content-Type | Size |
---|---|---|
stderr | text/plain | 1.7 KB |
stdout | text/plain | 699 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Hallstrom | 2000-08-10 14:48:53 | Re: PSQL woes |
Previous Message | Alex Guryanow | 2000-08-10 11:38:47 | problem with plpgsql function |