Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upgradation from PostgreSQL 7.3 to PostgreSQL 8.1.

Status
Not open for further replies.

tharas

Programmer
Sep 16, 2006
6
IN
Hai all,

I have an Intel Pentium IV machine with Redhat Linux 9.0 installed in it. It was also having PostgreSQL 7.3 which was
installed along with Redhat Linux 9.0 installation and it was working fine. The installation location of the PostgreSQL 7.3 was /usr/local/pgsql and data directory was at /var/lib/pgsql/data .

Then I tried to upgrade PostgreSQL 7.3 to PostgreSQL 8.1. For that I performed the following:

1. Downloaded PostgreSQL 8.1.4 from ftp://ftp2.de.postgresql.org/pub/postgresql/source/v8.1.4/postgresql-8.1.4.tar.gz

2. Stopped already running PostgreSQL server process as
kill -INT `cat /var/lib/pgsql/data/postmaster.pid`

3. Moved the current installation location and data directory to another folder as
mv /usr/local/pgsql /usr/local/pgsql.old
mv /var/lib/pgsql /var/lib/pgsql.old

4. copied the source file postgresql-8.1.4.tar.gz to /usr/local/src

5. Extracted tarball as
gunzip /usr/local/src/postgresql-8.1.4.tar.gz
tar -xvf postgresql-8.1.4.tar

6. configuration of the installation as
./configure --prefix=/usr/local/pgsql
--bindir=/usr/local/pgsql/bin
--datadir=/usr/local/pgsql/share
--sysconfdir=/usr/local/pgsql/etc
--libdir=/usr/local/pgsql/lib
--includedir=/usr/local/pgsql/include
--mandir=/usr/local/pgsql/man
--with-docdir=/usr/local/pgsql/doc
--with-perl
--with-phython
--with-tcl
--with-java

7. gmake
which displayed "All of PostgreSQL successfully made. Ready to install"

8. gmake install
which displayed "Installation complete"

9. Created a folder data under /usr/local/pgsql and set its owner as 'postgres'

10.Intialized the database as
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

11.Started postmaster process
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

12.But when i executed the command
pg_ctl --version
it shows the PostgreSQL version as 7.3


Is it a problem with the installation? Please help.

Regards,
Thara
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top