Student Reviews
( 5 Of 5 )
1 review
Video of 7- PostgreSQL Instance management and configuration (دردشة بالعربي) in PostgreSQL course by Omer Khalil channel, video No. 12 free certified online
1- Create new Instance using initdb utility.
a. Initdb -D newDataDir
2- Stop/Start the Instance.
3- Configuration:
a. Show the Instance current configurations:
i. Postgresql.conf, postgresql.auto.conf
ii. Pg_settings, pg_file_settings
iii. Restart or reload?
b. Configurations scope:
i. Cluster level, ALTER SYSTEM SET varNameval; & postgresql.conf
ii. Database level, ALTER DATABASE dbName SET varNameval;
iii. User level, ALTER USER usrName SET varNameval;
iv. Session level, SET varNameval;