Skip to main content

Initialise Primary Database

Apde streaming replicas mate PostgreSQL server ne configure karie aeni pehla aapde ae jovu hoie k aapde su achieve karvu 6e.

Aa lab no goal 6e k aapde ek primary database server create karie je replica standby server ma asynchronously replicate kare.

  1. Sauthi pehla make sure k tamari pase koi ek linux instance running 6e and aema postgresql installed 6e.
psql --version

ae kaink aa rite output aaptu hovu joie.

psql (PostgreSQL) 16.10 (Ubuntu 16.10-0ubuntu0.24.04.1)
  1. check karo k bija required commands proper accessible 6e.
which initdb

ae kaink aa rite output aaptu hovu joie.

/usr/lib/postgresql/16/bin/initdb

jo aavu nathi maltu to ae case ma aapde cluster create nahi kari sakie. aa case ma tame je method thi postgresql install karyu 6e aena vise research kari ne check karo k badhi binary kay jagya par store thai hase. mara case me ubuntu na apt thi install kari hati to mare ae store hati /usr/lib/postgresql/16/bin. aa path ne .bashrc file ma PATH variable ma export karavi do.

  1. Aapde ek database cluster create karsu. aa mate aapde ek directory create karisu k jema database na related badha data store thata hase. ahi system tables create thase ane ek default database pan create thase postgres karine.

Basically, ek database cluster ae databases nu collection 6e k je ek single server instance ni andar manage thatu hoi 6e.

initdb -D /tmp/primary_db/

a command thi upar jem kahelu 6e aem aa directory create thase and aeni anadar system tables create thase ane sathe ek default database pan create thase jenu name hase postgres

so aapdu primary_db cluster ready 6e.