Re: Databse installation problem - Mailing list pgsql-novice

From Bhushan Verma
Subject Re: Databse installation problem
Date
Msg-id 50a295ab0909210029h7f6c4fc1ta1e9e83a55067394@mail.gmail.com
Whole thread Raw
In response to Re: Databse installation problem  (Tim Bowden <tim.bowden@westnet.com.au>)
Responses Re: Databse installation problem
List pgsql-novice
Hi, Ok you ar right.
Now I triied as follows:
its showing psql 8.3.7 but server 8.3.1 and query returns 8.3.1

[root@netocean2 pgsql]# /var/lib/pgsql/bin/psql test
Welcome to psql 8.3.7 (server 8.3.1), the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

test=>
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)


On 9/21/09, Tim Bowden <tim.bowden@westnet.com.au> wrote:
On Mon, 2009-09-21 at 11:54 +0530, Bhushan Verma wrote:
> Hi,thanks for your mail.
> I have alredy stopped the database before new installation.
> I have tried as you said but I am getting the same version 8.3.1.
>
> As per Tim Bowden said , I have also done these steps but not able to
> get the 8.3.7 version.
>
> On 9/21/09, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
>         This does not belong to pgsql-bugs.
>
>         I have a feeling that your previous version of postgres is
>         still running. You should have stopped that daemon before
>         doing 'rm -rf'. attaching/pasting your pgstartup.log would
>         also help.
>
>         For now, kill your current postgres processes, and then try to
>         start again.
>
>         Best regards,
>
>
>         On Mon, Sep 21, 2009 at 11:23 AM, Bhushan Verma
>         <verma.bhushan@gmail.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.
>
>                 --
>                 With Regards,
>                 Bhushan


Ok, actually reading what you did this time, why are you
running /usr/local/pgsql/bin/* when your configure --prefix
is /var/lib/pgsql/?

You're stating the old install not the new install.


HTH,
Tim Bowden



--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice



--
With Regards,
Bhushan

pgsql-novice by date:

Previous
From: Tim Bowden
Date:
Subject: Re: Databse installation problem
Next
From: Tim Bowden
Date:
Subject: Re: Databse installation problem