From: | raf <raf(at)raf(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problems with win32 enterprisedb 8.3.6 ssl=on |
Date: | 2009-02-23 07:55:26 |
Message-ID: | 20090223075526.GA19130@raf.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
i've been getting nonsensical error messages all day with
postgres 8.3 on winxpsp3. i tried upgrading to 8.3.6
(enterprisedb) and fresh installs.
i get either of the following errors:
PANIC: could not open control file
"global/pg_control": Permission denied
postgres cannot access the server configuration
file "C:/app/postgres/data/postgresql.conf":
No such file or directory
even though both files are present and accessible to
the postgres user. at some point i tried giving the postgres
user full control over these files and the directories
they were in but it made no difference. i didn't expect it
to since the permissions looked correct to begin with.
if i have ssl=off in my postgresql.conf file i can start the
server with "net start pg-plus-8.3" but:
if i try to start it with "pg_ctl start -D C:/app/postgres/data"
i get the postgresql.conf error message.
if i have ssl=on in my postgresql.conf file (and
server.{crt,key,req} files in the data directory) then "net
start pg-plus-8.3") doesn't work but it gives no reason (and
no log messages) and "pg_ctl start -D C:/app/postgres/data"
gives the global/pg_control error message.
no. i'm flipping ssl on and off now it's staying with the
global/pg_control error. i looked this error up in the
mailing list archives and only found 1 mention of it 2
years ago with no real resolution.
does anyone have an idea about what's happening. it seems i
can only run postgres on windows with ssl=off and i want to
force the use of ssl.
i'd also like the pg_ctl start/stop commands to work again
because they give actual error messages unlike the net
start/stop commands. are they supposed to work with
enterprisedb? i've seen them working on another windows
enterprisedb installation that i set up a while ago.
cheers,
raf
From | Date | Subject | |
---|---|---|---|
Next Message | Jordan Tomkinson | 2009-02-23 08:17:20 | Re: High cpu usage after many inserts |
Previous Message | Jordan Tomkinson | 2009-02-23 07:42:30 | Re: High cpu usage after many inserts |