Re: Starting PGSQL

Oups :-)

Well I have a RedHat linux WS 4.0

I just realized that I had installed postgresql-8.0.1 just over
postgresql-7.4 (included in the OS).

So I made sure that I removed them both.

I downloaded postgresql-8.0.3.tar.bz2 from the postgresql.org website.

I followed the instructions one by one.

When I reached to

/usr/local/pgsql/bin/createdb test

It gave me the following error: bash-3.00$ /usr/local/pgsql/bin/createdb
test

createdb: could not connect to database template1: FATAL: could not
open file "/usr/local/pgsql/data/global/1262": Permission denied

and I have:

bash-3.00$ ls -l /usr/local/pgsql/data/global/1262

-rw------- 1 postgres postgres 8192 Sep 20 18:21
/usr/local/pgsql/data/global/1262

Also, the following file doesn't exist:

/etc/rc.d/init.d/postgresql

How to fix it?

thx

Marc

________________________________

From: Cristian Prieto [mailto:cristian(at)clickdiario(dot)com]
Sent: Tuesday, September 20, 2005 5:29 PM
To: Marc Khayat; pgsql-novice(at)postgresql(dot)org
Subject: RE: [NOVICE] Starting PGSQL

I guess It would be very helpful for us to hear what distro/operating
system you are using...

________________________________

From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Marc Khayat
Sent: Martes, 20 de Septiembre de 2005 01:54 a.m.
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Starting PGSQL

Hi all,

The following may be too silly even for this mailing list... but
however:

i've never used PostgreSQL before, always been using MySQL.

I installed postgresql-8.0.1, but when trying to run it, i get:

[root(at)linux local]# service postgresql start
Starting postgresql service: [FAILED]
[root(at)linux local]#
[root(at)linux local]# /etc/rc.d/init.d/postgresql start
Starting postgresql service: [FAILED]

also tried the restart argument, but didn't work.

My question is the following: how can i run the debug and find the
error, or better yet, how can i run it :) ??

Thank you,

Marc