postgreSQL How to start server and stop server?

How to stop postgreSQL?

./pg_ctl -D ../data stop

How to force stop postgreSQL?
./pg_ctl -D ../data stop -m f --->force stop

How to start postgreSQL?
./pg_ctl -D ../data start

How to restart postgreSQL?
./pg_ctl -D ../data restart

Note: In above samples pg_ctl is a executable which can be found under bin directory. -D stands for directory and ../data is data directory.


Security :
pg_hdb.cfg configuration file will have all clients IP address non listed clients cannot access.

pg_hba.conf can be find under data directory not under bin directory.another config file postgres.cfg where will do postgreSQL configurations.

How to load configuration file without restart with query?
Answer: select pg_reload_conf();

How to rotate db logs?
Answer: select pg_rotate_logfile();

How to view log file location?
Answer: select pg_ls_dir('pg_log');

How to view system tables?
Answer: \d$

also see below

what is postgreSQL

Why postgresSQL

History of PostgreSQL

postgreSQL - PSQL MATA Commands

postgreSQL what is schema?

postgreSQL Connecting to a Database

postgreSQL Create and access Database

How to create user in postgreSQL?

postgreSQL Grant/Revoke Privileges

postgreSQL Tablespaces and datafiles

postgreSQL How to start server and stop server?

postgreSQL perfomance

postgreSQL How to create cluster?

postgreSQL Queries

postgreSQL routine maintenance and proactive-maintanace.

postgresql-logging