Re: Starting PGSQL - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Starting PGSQL
Date
Msg-id b356039305092012581de5656b@mail.gmail.com
Whole thread Raw
In response to Re: Starting PGSQL  ("Marc Khayat" <marc@globalcarrier.net>)
List pgsql-novice
> 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
That means that you followed the steps one by one, just
skipping the chown postgres /usr/local/pgsql/data, quite
possibly no execute on one of the directories ... hard to
tell without more detailed info, though.


> 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
Since there's varied places for init-script, and not every
Unix/Linux variant uses SysV inits PostgreSQL doesn't
provide that startup script.  The easiest would be to copy
it out of one of your RPMS and modify the paths in it
to match the real thing.


> How to fix it?
Cheers,
Andrej

P.S.: HTML mail is big, ugly and hard to read

pgsql-novice by date:

Previous
From: "Marc Khayat"
Date:
Subject: Re: Starting PGSQL
Next
From: Sigrid Meneses
Date:
Subject: QUERY A PSQL DB USING CRONTAB