Module4_Database_Clusters

Question 1

what are the 3 default databases?

Answer 1

Template0
Template1
postgres

Question 2

pg_ctl -D PGDATA_DIR -l startlog start

Answer 2

start a cluser + logfile

Question 3

how to reload (not restart) a cluster?

Answer 3

pg_ctl -D data_directory reload
or
pg_reload_conf()

Question 4

what happens when you stop cluster with the options -mf, mi and ms

Answer 4

• mf : Fast mode quit directly with proper shutdown (default)
• mi : Immediate mode, quit without complete shutdown, will need recovery
• ms : smart mode , quit after all clients have disconnected

Question 5

what does the pg_controldata /data_dir ?

Answer 5

gives infomation about the cluster

Question 6

How to remove an instance.

Answer 6

stop the cluster and delete the data directory