Re: Databse installation problem

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