One of my other problems is that I dont know what version of postgres I was
running. As far as I knew I was running 6.3, but upon looking at teh
PG_VERSION file of my old data directory, I see that it says 6.4. So I dont
know what version to install. Is there a way to tell from the data
directory exactly what version I was running?
----- Original Message -----
From: Jay W. Summet <[EMAIL PROTECTED]>
To: Darren Greer <[EMAIL PROTECTED]>
Sent: Tuesday, August 10, 1999 8:48 AM
Subject: Re: [ADMIN] Urgent - Help Needed (Restoriing Data)
> -----BEGIN PGP SIGNED MESSAGE-----
>
> I had this same problem a while back.
> Had a backup of the data directory, but did not have a backup of anythig
else.
> With the help of some people on the list I was able to find an archive
with the
> vrsion of postgres I was using (6.2) and re-install, overwriting the data
> directory with my backups and I could get back in.
>
> Since then I have written a program that dumps our data to a text file
nightly.
> (The included pgdump program would crash for some reason.)
>
> Jay Summet
>
> On Tue, 10 Aug 1999, you wrote:
> > Somehow, our version of postgres got upgraded during some system
> > maintenance. To make a long story short we had to completely re-install
> > Posgres (6.3-15). Now I have originaly data directory backed up, but
have
> > found no way to import the data. I tried simply replacing the new data
> > directory with the old, with no luck.
> >
> > I have seen pasts posts in the archives that were similar, and have
tried
> > their suggestions, with no luck. I am in desperate need at this point,
and
> > would be very gracious if anyone could help. Is there anyway that I can
> > export the data from the individual table files in the base/data/db
> > directory?
> >
> > Again, any help is appreciated.
> >
> > Darren
> - --
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: 2.6.3ia
> Charset: noconv
>
> iQCVAwUBN7AuLLWkkhmZq4xxAQFUkgP+PXTuU/YZYUyWtxHlF0yMtirzwlDO0tEY
> sAtD8AfiNRBARZ3qc/PHc/ENbJhwhcehHLLhRpmbQPQT6qaj1EV7P5Oi5b5pYCiu
> YLZxMhJ0+p48htO1aOCgOnduHB7zbVZCpeSMt/J9VUAVKrU61mqlh6X0j2jX3icq
> YoKNyuzpWRg=
> =yvBN
> -----END PGP SIGNATURE-----
