postgreSQL How to create cluster?

PostgreSQL Cluster is nothing but another instance of Database.

Syntax:

initDB -D <direcoty>

Example:

step 1: create directory for table.

    mkdir mynewtable-space

step 2: initDB -D /mynewtable-space

Note: now mynewtable-space folder will have all executable(like pg_ctl) and newly created config files for now cluster. here we can change port for new cluster and other configuration.

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