[ciapug] PostgreSQL question

[Carl Olsen]

I set the runlevel to 3 and 5, and now it's starting up at boot, I'm getting
some kind of error when I try to use pgadmin, so I may do an SQL dump of the
tables and re-create them.  My code is not getting any errors when I read
the data from a web page, so it must be something obscure in the
administrative tool.

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Carl Olsen
Sent: Sunday, June 12, 2005 1:44 PM
To: ciapug at cialug.org
Subject: RE: [ciapug] PostgreSQL question

If anyone is interested, I got my databases converted from PostgreSQL 7 to
PostgreSQL 8.

The online manual says to backup the databases before doing anything else.
Fortunately, you can still back them up after doing the upgrade (since I
didn't back them up first).  After doing the upgrade, the version of
PostgreSQL is 8, but you still have the data folders from version 7 (which
is why you still have the ability to back up the databases).  After I backed
them up, I removed PostgreSQL from the machine, deleted the data folders,
and reinstalled.  Everything from there is just the same as configuring a
full install.  After the server is running, you run:

   psql template1 < backup

to get the databases back.  I'm still fooling around with configuration, but
I have TCP/IP working again.  I'm still having to start PostgreSQL manually,
so I just need to remember how to get it to start at boot (it's not very
difficult, I just can't remember how to do it without looking at a book).  I
think it's as simple as setting the run time parameters to 3 and 5, or
something like that.  Anyway, it's not too difficult.  I'm sure I made it
harder than it needs to be.

Carl