Re: PG_DUMP fails to load back in - Mailing list pgsql-novice

From Rob Brown-Bayliss
Subject Re: PG_DUMP fails to load back in
Date
Msg-id 991813531.7570.1.camel@ZOOstation.cc
Whole thread Raw
In response to Re: PG_DUMP fails to load back in  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On 02 Jun 2001 10:06:41 -0400, Tom Lane wrote:
> Rob Brown-Bayliss <rob@ZOOstation.cc> writes:
> > Most tables have part of there primary key set via a function that looks
> > up data from a local table.  But, pgdump is putting the functions at the
> > end of the list so it's not there when the table is created.
>
> Try 7.1.

Well I downloaded the redhat 7.1 rpms from the postgres ftp site for
postgresql 7.1.1 but the failed to install as the rpms wanted to remove
libpq.so.2 which they also need.  I forced the issue and then coppied
the libpq stuff from another machine and tried to upgrade as per the
instructions - which failed, and then found the the postmaster can not
be shut down either.

So I am currently downgrading to 7.0.3 and awaiting enlightenment...

Are the rpm's from postgres broken?


--

  Rob Brown-Bayliss
 ---======o======---
  www.ZOOstation.cc

pgsql-novice by date:

Previous
From: Eric Walstad
Date:
Subject: Re: Upgraded to Red Hat 7.1, now my DB is toast?
Next
From: "Rob Arnold"
Date:
Subject: Re: Upgraded to Red Hat 7.1, now my DB is toast?