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.
