[Babase] Papio upgrade woes

Karl O. Pinc kop at meme.com
Fri Mar 24 20:45:39 EST 2006


Hi,

Maybe you forgot to finish, but /var/lib/psql/ seems
to be reset to default.  I figured all the stuff in
there was mine.  I did upgrade the posgresql rpms
from the back-to-centos-standard ones that were
installed, but I checked the pre/post scripts
and I AFAIK they don't mess with the db contents.
Right now, there's no db content.

No worries, just work....

At this point it looks like we're going to have to do
a db reload anyhow so I'm thinking of just upgrading
to Postgresql 8.1.  The one thing I would like back
is the postgresql.conf file.  It wouldn't hurt
to have pg_hba.conf back too just for comparison
purposes.  (But I want to leave it compatible with
your system for backup, we may have had it
incompatible at some point and forgotten to change
it back.)


Here's some problems with /var/lib/psql/ to consider
regards your upgrade procedures:

I'm running a different pg release, and different
releases require different internal db structures.

I've tweaked the db store initialization, to avoid
multibyte UTF charsets, timezones,  etc.,
and the default install does not do this.

I've got tweaks in postgresql.conf.

I've got default languages turned on in the
default database (template1).



I assume I can restore the dumps in
/srv/database/postgres/
(as in, they won't go away tonight
when the db dumps again, will they?)


On another note, /etc/sysctl.conf couldn't
be linked to /usr/local/etc/ because of
mount time boot sequence issues.  There's
a bit of tweak in there that needs to be
restored also.  I can do this.  (rescued
a copy from /srv/albertslab.etc/)
I'd forgotten about the boot sequence issues.


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list