pg_dump and restore

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

In response to

Responses

Browse pgsql-general by date

  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