[GENERAL] Changed SSL Certificates

2011-04-08 Thread Carlos Mennens
I had self signed SSL certificates on my database server but since then removed them and received updated certificates from the security team. I removed (backedup) the old server.crt server.key and now have db1_ssl.crt db1_ssl.key in the identical location as the old SSL certificates. I then

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Diego Schulz
On Fri, Apr 8, 2011 at 1:42 PM, Carlos Mennens carlos.menn...@gmail.comwrote: I had self signed SSL certificates on my database server but since then removed them and received updated certificates from the security team. I removed (backedup) the old server.crt server.key and now have

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Carlos Mennens
On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz dsch...@gmail.com wrote: Hi, When linking to the certificate and key you should specify the full path. ln -s /etc/ssl/certs/db1_ssl.crt      /full/path/to/db1_ssl.crt ln -s /etc/ssl/private/db1_ssl.key   /full/path/to/db1_ssl.key Thanks for the

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Diego Schulz
On Fri, Apr 8, 2011 at 2:21 PM, Carlos Mennens carlos.menn...@gmail.comwrote: On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz dsch...@gmail.com wrote: Hi, When linking to the certificate and key you should specify the full path. ln -s /etc/ssl/certs/db1_ssl.crt /full/path/to/db1_ssl.crt

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Adrian Klaver
On 04/08/2011 09:42 AM, Carlos Mennens wrote: I had self signed SSL certificates on my database server but since then removed them and received updated certificates from the security team. I removed (backedup) the old server.crt server.key and now have db1_ssl.crt db1_ssl.key in the identical

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Vick Khera
On Fri, Apr 8, 2011 at 12:42 PM, Carlos Mennens carlos.menn...@gmail.comwrote: ln -s /etc/ssl/certs/db1_ssl.crt db1_ssl.crt ln -s /etc/ssl/private/db1_ssl.key db1_ssl.key I then restarted PostgreSQL and got the following error: 2011-04-08 09:54:34 EDT FATAL: could not load server

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Tom Lane
Carlos Mennens carlos.menn...@gmail.com writes: I had self signed SSL certificates on my database server but since then removed them and received updated certificates from the security team. I removed (backedup) the old server.crt server.key and now have db1_ssl.crt db1_ssl.key in the

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Carlos Mennens
On Fri, Apr 8, 2011 at 2:01 PM, Adrian Klaver adrian.kla...@gmail.com wrote: Per here: http://www.postgresql.org/docs/8.4/static/ssl-tcp.html File    Contents        Effect server.crt      server certificate      requested by client server.key      server private key      proves server