Re: Databse installation problem

From: Tim Bowden <tim(dot)bowden(at)westnet(dot)com(dot)au>
To: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Databse installation problem
Date: 2009-09-21 06:13:04
Message-ID: 1253513584.4434.23.camel@mordor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

On Mon, 2009-09-21 at 11:23 +0530, Bhushan Verma wrote:
>
> I have tried to install postgres version 8.3.7 as follows
>
> 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 &
> /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.
>
> --
> With Regards,
> Bhushan

Have you tried running ldconfig to refresh the lib cache?

fwiw I always put /var/lib/pgsql/lib (or equivalent) in /etc/ld.so.conf
(or /etc/ld.so.conf.d/local.conf for debian based system)

HTH,
Tim Bowden

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bhushan Verma 2009-09-21 06:24:17 Re: Databse installation problem
Previous Message Gurjeet Singh 2009-09-21 06:08:03 Re: Databse installation problem

Browse pgsql-novice by date

  From Date Subject
Next Message Bhushan Verma 2009-09-21 06:24:17 Re: Databse installation problem
Previous Message Gurjeet Singh 2009-09-21 06:08:03 Re: Databse installation problem