[ciapug] PostgreSQL question

[Carl Olsen]

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

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Carl Olsen
Sent: Friday, June 10, 2005 3:13 PM
To: carl-olsen at mchsi.com; ciapug at cialug.org
Subject: RE: [ciapug] PostgreSQL question

I suppose I should start by reading the online manual.  I'll give that a
try.

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Carl Olsen
Sent: Friday, June 10, 2005 11:37 AM
To: carl-olsen at mchsi.com; ciapug at cialug.org
Subject: [ciapug] PostgreSQL question

I updated my SUSE 9.2 installation to 9.3 last night and all of my software
is now a different version.  I have PHP5 instead of PHP4, which hasn't
affected any of my web sites (they all run just fine with PHP5).  Somewhere
along the line, I saw a message saying my database was still using
PostgreSQL 7.4, and I now have PostgreSQL 8 installed.  I think it said
something about deleting the database and recreating it to get it upgraded.
I made an SQL dump, so it would be fairly easy to drop the database and
recreate it.  Is it really that simple?  The old one is still functioning,
so I'd like to know what I'm doing before I try to delete it.

Anybody have any experience with upgrading PostgreSQL?

Carl
http://www.carl-olsen.com/


-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of Carl Olsen
Sent: Thursday, June 09, 2005 6:38 PM
To: ciapug at cialug.org
Subject: RE: [ciapug] Happy 10th B-day

I thought Al Gore invented it.  I've been using it for about 1 year now.  Oh
well, happy B-Day!

-----Original Message-----
From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On Behalf
Of David Champion
Sent: Thursday, June 09, 2005 11:03 AM
To: ciapug at cialug.org
Subject: [ciapug] Happy 10th B-day

It was PHP's 10th birthday yesterday...

http://developers.slashdot.org/article.pl?sid=05/06/09/127249&tid=169

Most of us haven't been using PHP for that long. I remember messing 
around with it when it was still called "php-fi"... and it was a huge 
pain to get it installed and working. :)

I didn't really start using it until after PHP3 was released.

-dc

_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug


_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug


_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug


_______________________________________________
ciapug mailing list
ciapug at cialug.org
http://cialug.org/mailman/listinfo/ciapug