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 08:01:41
Message-ID: 1253520101.4434.57.camel@mordor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

On Mon, 2009-09-21 at 12:59 +0530, Bhushan Verma wrote:
> 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

You seem to be using psql from 8.3.7 but running the 8.3.1 server still.
How *exactly* are you stopping the old server and starting the new one,
and are there any messages in /var/lib/pgsql/data/serverlog?

Tim Bowden

BTW, please don't top post. It ruins the flow of the conversation and
makes it very difficult to follow.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bhushan Verma 2009-09-21 08:22:38 Re: Databse installation problem
Previous Message Annita Veneti 2009-09-21 07:43:37 Re: BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

Browse pgsql-novice by date

  From Date Subject
Next Message Bhushan Verma 2009-09-21 08:22:38 Re: Databse installation problem
Previous Message Bhushan Verma 2009-09-21 07:29:51 Re: Databse installation problem