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
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