Re: pg_dump and restore

I think I see the problem, there were errors reported on the
restore. Something about a bad timestamp representation (or something
like that). You might want to look through the dump to see what
is in the dump, and if you have time try to replicate it with
new data so you can send that (assuming the dump is large/proprietary of
course).

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Thu, 10 Aug 2000, Andreas Tille wrote:

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