Waiting for postmaster to be completely started

Started by Wade D. Oberprillerabout 25 years ago2 messagesgeneral
Jump to latest
#1Wade D. Oberpriller
oberpwd@anubis.network.com

Hello,

I have a script with the following code:

$(PGSQL)/bin/pg_ctl -D $(PGSQL)/data start ;\
$(PGSQL)/bin/createlang -L $(PGSQL)/lib plpgsql template1

Sometimes I get an error from createlang, and it appears that postmaster
has not completely been started and is not ready to accept connections. Does
the pg_ctl script wait until postmaster has been started and is ready to
accept connections? If not what is a good way of determining this?

I am trying to automate the building of the database, and I need a reliable
way to do this.

Wade Oberpriller
oberpwd@network.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Wade D. Oberpriller (#1)
Re: Waiting for postmaster to be completely started

oberpwd@anubis.network.com (Wade D. Oberpriller) writes:

Does
the pg_ctl script wait until postmaster has been started and is ready to
accept connections?

Not without the -w option, as a moment's inspection of either the docs
or the script itself would've told you ...

regards, tom lane