Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[SOLVED] how to configure ssl in postgresql-server 8.4?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
adrin
n00b
n00b


Joined: 27 May 2006
Posts: 41

PostPosted: Sat Mar 27, 2010 9:06 pm    Post subject: [SOLVED] how to configure ssl in postgresql-server 8.4? Reply with quote

Hello
I have a problem with setting up a working SSL fot postgresql server 8.4. I've followed the official manual regarding self-signed certs, copied server.key, server.crt and server.req files to /var/lib/postgresql/8.4/data but when I try to launch the server i receive a cryptic error:

Quote:

* Starting PostgreSQL ... [ !! ] for server to start...............................................^C
* The pid-file doesn't exist but pg_ctl reported a running server.
* Please check whether there is another server running on the same port or read the log-file.


When i turn off ssl in postgresql.conf everything runs fine... What is wrong with my setup?
I cannot find any logfiles (postgresql.conf states that 'syslog' is my logging method still no logfiles can be found at /var/log/p*)
_________________
*a*


Last edited by adrin on Sun Mar 28, 2010 8:00 am; edited 1 time in total
Back to top
View user's profile Send private message
adrin
n00b
n00b


Joined: 27 May 2006
Posts: 41

PostPosted: Sun Mar 28, 2010 7:59 am    Post subject: Reply with quote

SOLVED:
I forgot to set ownership of appropriate files
Quote:
chown postgres:postgres server.*
chown postgres:postgres /var/log/postgres

_________________
*a*
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum