See the pgupgrade utility in 6.4.*.
> Hi
>
> My guess would be to totally delete the data directory (~postgres/data)
> and put your old one in its place. As opposed to copying over it, which
> may leave the old (new old) stuff in the way.
>
> Terry
>
> On Tue, 9 Feb 1999, G. Anthony Reina wrote:
>
> > I recently updated my OS to RedHat 5.2 with the 2.2 Kernel. I was last
> > using Postgres 6.4.2 with my database. I re-installed Postgres 6.4.2
> > into the new operating system and tried to copy the contents of the
> > database directory over to the newly installed directory.
> >
> > I am able to select and update from the database, but when I try '/d',
> > the psql comes back with "Can't find any tables or indicies". I know
> > that it is better to restore from a previous pg_dump, but shouldn't I be
> > able to simply copy the files over to the new directory and have the
> > thing working? Is there some sort of "table of the tables" file that
> > didn't copy over correctly? Any way to get things back to normal?
> >
> > Any suggestions?
> > Thanks.
> > -Tony
> >
> >
> >
>
>
> Have a great day
> Terry Mackintosh <[EMAIL PROTECTED]> http://www.terrym.com
> sysadmin/owner I'm excited about life! How about YOU!?
>
> Proudly powered by R H Linux 4.2, Apache 1.3.x, PHP 3.x, PostgreSQL 6.x
> -----------------------------------------------------------------------
> Only if you know where you're going can you get there.
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
