creating clusters in postgres

Creating clusters in postgres

[@leellee7394]

thanks a lot for your postgres training its really helpful

[@esra_erimez]

I found your tutorial scintillating and thrilling.

[@ABIHASHIM]

Where is the second server, how do we can say the given is single host cluster? or there is another video for basic installation

[@krarjunkanna]

Hi Ramesh, could you share the configuration and creation of postgres cluster on docker.

[@princecharming3536]

how to find port number for each cluster??

[@vikrambm7023]

Excellent explanation Thanks I have a doubt. When we install Postgres, it already comes with a default cluster, right? So, is there a concept of "cluster names"? How do we know which cluster are we going to connect in a particular server.

[@05burky]

#psql --cluster /clusterName -l The "-l" option is optional and will list the databases in the cluster

[@zakeerp]

While installing we we will create default cluster with unique port number.. when we create in new cluster we will provide new data directory for that cluster ..created new data directory for that cluster will get all the new supporting directories and PostgreSQL conf file , we need edit port number for the postgresql conf file.. and while connecting to newly created cluster we need to use data directedand port number in pg_ctl command..

[@durgasivaprasadkomatineni3977]

@@05burky there he is not given port number,without creating port number how we can use another cluster with same port?

[@05burky]

Trying to create the cluster on Ubuntu 18, getting the following error: postgres@guru-Lenovo-IdeaPad-S410p:/usr/local/bin$ initdb -D /tmp/clu1 -U postgres The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "en_IE.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/clu1 ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... 2019-05-16 19:05:23.811 IST [6122] FATAL: could not access file "$libdir/ascii_and_mic": No such file or directory 2019-05-16 19:05:23.811 IST [6122] STATEMENT: -- SQL_ASCII --> MULE_INTERNAL CREATE OR REPLACE FUNCTION ascii_to_mic (INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE C STRICT PARALLEL SAFE; COMMENT ON FUNCTION ascii_to_mic(INTEGER, INTEGER, CSTRING, INTERNAL, INTEGER) IS 'internal conversion function for SQL_ASCII to MULE_INTERNAL'; CREATE DEFAULT CONVERSION pg_catalog.ascii_to_mic FOR 'SQL_ASCII' TO 'MULE_INTERNAL' FROM ascii_to_mic; COMMENT ON CONVERSION pg_catalog.ascii_to_mic IS 'conversion for SQL_ASCII to MULE_INTERNAL'; child process exited with exit code 1 initdb: removing data directory "/tmp/clu1"

[@kuchipudi862]

New batch epudu start chestaru sir

[@karthicks231]

While creating a cluster , you not mentioning the port number... Then how it's work

[@05burky]

Why do we need clusters if "there is no relationship between two clusters in a database"?