Re: Databse installation problem - Mailing list pgsql-novice

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

--
Lets call it Postgres

EnterpriseDB      http://www.enterprisedb.com

gurjeet[.singh]@EnterpriseDB.com

singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet

Mail sent from my BlackLaptop device