Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Carlos Mennens
On Fri, Apr 8, 2011 at 2:01 PM, Adrian Klaver 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 certificate sent by > own

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Tom Lane
Carlos Mennens 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 identical location as the

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Vick Khera
On Fri, Apr 8, 2011 at 12:42 PM, Carlos Mennens wrote: > 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 certificate file > "server.c

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 Diego Schulz
On Fri, Apr 8, 2011 at 2:21 PM, Carlos Mennens wrote: > On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz 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.

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Carlos Mennens
On Fri, Apr 8, 2011 at 1:15 PM, Diego Schulz 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 quick reply Diego

Re: [GENERAL] Changed SSL Certificates

2011-04-08 Thread Diego Schulz
On Fri, Apr 8, 2011 at 1:42 PM, 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 i