Oups J
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
From: Cristian Prieto [mailto:cristian@clickdiario.com]
Sent: Tuesday, September 20, 2005 5:29 PM
To: Marc Khayat; pgsql-novice@postgresql.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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Marc Khayat
Sent: Martes, 20 de Septiembre de 2005 01:54 a.m.
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Starting PGSQL
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@linux local]# service postgresql start
Starting postgresql service: [FAILED]
[root@linux local]#
[root@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 :) ??