Skip site navigation (1) Skip section navigation (2)

Upgrade from 8.0.0 to 8.0.2

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Upgrade from 8.0.0 to 8.0.2
Date: 2005-04-21 19:00:28
Message-ID: 20050421185419.M1992@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi All,

In case it will help someone here is what I did to upgrade from PostgreSQL
v8.0.0 to PosgreSQL v8.0.2.  For me the real driver behind this upgrade was to
add plperl during the compile.  I didn't HAVE to upgrade but since I had to
compile anyway it seemed like an intelligent thing to do.

Kind Regards,
Keith

Download PostgreSQL v8.0.2
	postgresql-8.0.2.tar.gz
	postgresql-8.0.2.tar.gz.md5
Verify the download
	# md5sum postgresql-8.0.0rc5.tar.gz
	# more  postgresql-8.0.0rc5.tar.gz.md5
Stop the postmaster
	# service rhdb status
	postmaster (pid 1865 1864 1862) is running...
	# service rhdb stop
	Stopping PostgreSQL - Red Hat Edition service:             [  OK  ]
	# service rhdb status
	postmaster is stopped
Copy the startup scripts to a safe location
	# cd /downloads
	# cp -p /etc/sysconfig/pgsql/rhdb etc_sysconfig_pgsql_rhdb
	# cp -p /etc/init.d/rhdb etc_init.d_rhdb
Copy the configuration files to a safe location
	# cd /downloads
	# cp -p /databases/pg_hba.conf databases_pg_hba.conf
	# cp -p /databases/pg_ident.conf databases_pg_ident.conf
	# cp -p /databases/postgresql.conf databases_postgresql.conf
Copy the current database directory out of the way
	# cp -rp databases databases-8.0.0
Move the current installation directory out of the way
	# mv pgsql/ pgsql-8.0.0
Unpack the files
	# gzip -dc postgresql-8.0.2.tar.gz | tar -xvf -
Configure the installation
	# cd postgresql-8.0.2
	# ./configure -–with-perl
Build the installation
	# gmake
Regression test
	# su postgres
	postgres$ gmake check
	postgres$ exit
Install the software
	# gmake install
Clean up the build directory
	# gmake clean
Set up shared libraries
	# ldconfig /usr/local/pgsql/lib
Start the postmaster
	# service rhdb status
	postmaster is stopped
	# service rhdb start
	Starting PostgreSQL - Red Hat Edition service:             [  OK  ]
	# service rhdb status
	postmaster (pid 6553 6552 6551 6547) is running...

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-04-21 19:38:01
Subject: plperl user function
Previous:From: Bruno Wolff IIIDate: 2005-04-21 16:59:32
Subject: Re: Performance of multiple queries?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group