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

Re: [BUGS] Databse installation problem

From: tomas(at)tuxteam(dot)de
To: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [BUGS] Databse installation problem
Date: 2009-09-21 12:02:54
Message-ID: 20090921120254.GA14542@tomas (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, Sep 21, 2009 at 11:23:09AM +0530, Bhushan Verma wrote:
> I have tried to install postgres version 8.3.7 as follows

Definitely not a PostgreSQL bug. Please don't post this to
pgsql-bugs(at)postgresql(dot)org(dot)

> rm -rf /var/lib/pgsql
> mkdir /var/lib/pgsql
> ./configure --prefix /var/lib/pgsql
> gmake
> su
> gmake install
> adduser postgres
> mkdir /var/lib/pgsql/data
> chown postgres /var/lib/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data
> /usr/local/pgsql/bin/postgres -D /var/lib/pgsql/data >pgstartup.log 2>&1 &

And? What does pgstartup.log say?

> /usr/local/pgsql/bin/createdb test
> /usr/local/pgsql/bin/psql test
> 
> then i log on database to see the version
> test=> select version();
>                                                 version
> -------------------------------------------------------------------------------------------------------
>  PostgreSQL 8.3.1 on i386-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.3.0
> 20080314 (Red Hat 4.3.0-3)
> (1 row)
> but its showing me 8.3.1 that was my previous version.
> Could anyone tell me what is the problem.

I'd guess that the distribution's postgres daemon is still there. You
might have forgotten to uninstall it first (the startup log might have a
hint towards this).

Please refer to the Red Hat documentation: it explicitly recommends to
uninstall first the distribution-provided PostgreSQL before installing
from sources.

You may install both in  parallel, but then you have to know what you
are doing.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFKt2tuBcgs9XrR2kYRArcIAJ93bPIUf6TVZwhV+qIkVrdZBs9gQQCfRqp/
i4zON15NGwM4l2Up7X4ajBg=
=VXJz
-----END PGP SIGNATURE-----

In response to

pgsql-novice by date

Next:From: Patrick Linstruth (QNET)Date: 2009-09-21 15:02:30
Subject: Logging Question (SSL)
Previous:From: Tim BowdenDate: 2009-09-21 11:17:40
Subject: Re: Databse installation problem

pgsql-bugs by date

Next:From: Cedric BergerDate: 2009-09-21 13:43:07
Subject: Drop schema cascade fails since postgresql 8.4
Previous:From: Tim BowdenDate: 2009-09-21 11:17:40
Subject: Re: Databse installation problem

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