On Sat, 20 Jan 2001, Martin A. Marques wrote:
> > You probably should have used pg_dumpall to backup the databases and
> > restore them after the rebuild. That's a more reliable way of migrating
> > your data.
>
> The problem was that the server got downgraded from Solaris 8 to Solaris 7
> and the binaries didn't work, so I recompiled. There was no way of using
> pg_dump because I couldn't get the postmaster up.
Doh! You should smack the admin who downgraded without warning you so you
could take appropriate measures! :-) Why did you downgrade in the
firstplace? Just curious...
The problem with just moving your database to the new location is that
there are location dependencies built into it when you use initdb to
initialize it, so it's not reliable. Of course, if you have no other
choice, you have no ther choice... but this may be why hidden tables are
suddenly showing up everywhere.
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
I'm a Lisp variable -- bind me!