Re: [BUGS] Databse installation problem

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