Ask Your Question

how to install postgres on a node with ssl enable ,ssl selfsign cert install

asked 2015-01-18 19:49:32 -0600

singaravelan gravatar image

I used puppet module for postgresql installation on a node, but i want to install postgresql with ssl enable and ssl signed cert on it. Is that possible >

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2015-01-20 19:26:15 -0600

GregLarkin gravatar image

You can enable SSL in PostgreSQL using the config_entry resource as described here. The code would look like this:

postgresql::server::config_entry { 'ssl':
  value => 'on',

You can also manage an SSL certificate on your PostgreSQL server using the camptocamp-openssl module (a Puppet-approved module).

edit flag offensive delete link more


Thanks greg for your response. i have to enable this option through PE console, is there any option ? because i dont see an option for this . Can you advice . thanks

singaravelan gravatar imagesingaravelan ( 2015-01-27 13:35:55 -0600 )edit

Hi Greg, i am using the ssl module you have suggested, there i am getting this error msg. unable to load Private Key 140091171284808:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:evp_enc.c:596: 140091171284808:error:0906A065:PEM routines:PEM_do_header:bad decrypt:pem_lib.c

singaravelan gravatar imagesingaravelan ( 2015-01-29 10:01:05 -0600 )edit

answered 2015-01-29 10:44:29 -0600

singaravelan gravatar image

Error in passing file name and parameter syntax error in template file. Issue fixed and able to generate ssl certs and config change in postgresql.

Thanks Greg for all your help !!!

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2015-01-18 19:49:32 -0600

Seen: 218 times

Last updated: Jan 29 '15