Install PostgreSQL on Debian OS and configuration - mohnanskygabriel/faersDb GitHub Wiki

INSTALL based on manual (https://wiki.debian.org/PostgreSql#Installation):

• # apt-get install postgresql postgresql-client
• # apt-get install /*package*/

Recommended packages:

• postgresql-doc - PostgreSQL documentation.
• pgadmin3 - PostgreSQL administration GUI.

Create a regular system user account using adduser (skip this step to use an existing account): # adduser fears #from regular shell

After that installation create a database faersdb with db user faers (or any other existing user)

• # su - postgres
• # createuser faers #from regular shell
• # createdb -O faers faersdb

START STOP RELOAD postgresql command # /etc/init.d/postgresql stop/start/restart

Configure files after installation: /etc/postgresql/9.4/main (after change restart postgresql to activate changes)

To allow connection from other computers: Configure the pg_hba.conf file to add the line: host all all IP ADDRESS/PREFIX trust You have to change IP ADDRESS/PREFIX with address of the db for example 192.168.0.17/24 (24 is mask 255.255.255.0 for another mask you must calculate :/)

Edit the postgresql.conf listen_addresses='*' by default it's localhost, put * to listen to all addresses, or just your client IP to tighten up the security

download client for windows https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.3/windows/pgadmin4-1.3-x86.exe if you want and connect