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

Re: Databse installation problem

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Databse installation problem
Date: 2009-09-28 02:23:52
Message-ID: 603c8f070909271923j7c5f46e4y82c83c73afa2d37f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
On Mon, Sep 21, 2009 at 1:53 AM, Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com> 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.

You still have the old version in your PATH variable, and before the
new version.

...Robert

In response to

pgsql-novice by date

Next:From: Nicholas SlaboszDate: 2009-09-28 06:45:56
Subject: get current function name
Previous:From: Tom LaneDate: 2009-09-27 19:17:13
Subject: Re: Regarding Sequential Scans count increase each time we press refresh .

pgsql-bugs by date

Next:From: Robert HaasDate: 2009-09-28 02:45:19
Subject: Re: PROBLEMA AL INSTALAR POSTSGRESQL
Previous:From: Robert HaasDate: 2009-09-28 02:21:56
Subject: Re: BUG #5071: abbrev() bug with IPv6

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