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

Re: Databse installation problem

From: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
To: Tim Bowden <tim(dot)bowden(at)westnet(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Databse installation problem
Date: 2009-09-21 07:29:51
Message-ID: 50a295ab0909210029h7f6c4fc1ta1e9e83a55067394@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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(at)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(dot)bowden(at)westnet(dot)com(dot)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(dot)gurjeet(at)gmail(dot)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(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.
> >
> >                 --
> >                 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



-- 
With Regards,
Bhushan

In response to

Responses

pgsql-novice by date

Next:From: Tim BowdenDate: 2009-09-21 08:01:41
Subject: Re: Databse installation problem
Previous:From: Tim BowdenDate: 2009-09-21 06:42:34
Subject: Re: Databse installation problem

pgsql-bugs by date

Next:From: Annita VenetiDate: 2009-09-21 07:43:37
Subject: Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL
Previous:From: Tim BowdenDate: 2009-09-21 06:42:34
Subject: Re: Databse installation problem

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