Complete document about PostgreSql

[hienlh]

Description To have document about PostgreSql

Acceptance Criteria

• Introduction
• Installation
• Usage

[hienlh]

I - Installation

http://www.postgresqltutorial.com/install-postgresql/

https://o7planning.org/vi/10713/huong-dan-cai-dat-va-cau-hinh-database-postgresql

II - Start postgres server manual

• Start server
  pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" start
  
• Stop server
  pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" stop
  
• Restart server
  pg_ctl -D "C:\Program Files\PostgreSQL\9.6\data" restart

Reference: https://tableplus.io/blog/2018/10/how-to-start-stop-restart-postgresql-server.html

III - Setup SSL for Postgres

1. Install OpenSSL

https://tecadmin.net/install-openssl-on-windows/

2. Creating Certificates

• Run this command to create certificate
  openssl req -new -x509 -days 365 -nodes -text -out server.crt \ -keyout server.key -subj "/CN=localhost"
• Move file server.crt and server.key just created to folder data of postgres (C:\Program Files\PostgreSQL\11\data)
• Edit postgesql.conf (C:\Program Files\PostgreSQL\11\data): Remove comment in session about SSL and set ssl = on
  

  ssl = on
  ssl_ca_file = ''
  ssl_cert_file = 'server.crt'
  ssl_crl_file = ''
  ssl_key_file = 'server.key'
  ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
  ssl_prefer_server_ciphers = on
  ssl_ecdh_curve = 'prime256v1'
  ssl_dh_params_file = ''
  ssl_passphrase_command = ''
  ssl_passphrase_command_supports_reload = off