Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Doc updates

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgman(at)candle(dot)pha(dot)pa(dot)us
Cc: pgsql-hackers(at)postgreSQL(dot)org, docs(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Doc updates
Date: 2000-04-06 01:58:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-hackers
> OK, can someone confirm which items still need to be done to update the
> documentation?
> I can't imagine they are all done, and I don't think we can release 7.0
> without them all being done.

> Add pg_ctl script to control backend startup (Tatsuo)
> Add postmaster.opts.default file to store startup flags (Tatsuo)

I have written a man page for pg_ctl (see below). However, it's still
in a plain text, not marked up yet. I'm very busy right now, and
probably could start to make it into a SGML after 4/12. Is it too late
for the release schedule of 7.0?
Tatsuo Ishii

pg_ctl - starts/stops/restarts postmaster


pg_ctl [-w][-D database_dir][-p path_to_postmaster][-o "postmaster_opts"] start
pg_ctl [-w][-D database_dir][-m [s[mart]|f[ast]|i[mmediate]]] stop
pg_ctl [-w][-D database_dir][-m [s[mart]|f[ast]|i[mmediate]][-o "postmaster_opts"] restart
pg_ctl [-D database_dir] status


pg_ctl is a utility for starting, stopping or restarting postmaster.

Starting postmaster

To start postmaster:

pg_ctl start

If -w is supplied, pg_ctl waits for the database server comes up, by
watching for creation of the pid file (PGDATA/, for up
to 60 seconds.

Parameters to invoke postmaster are taken from following sources:

Path to postmaster: found in the command search path
Database directory: PGDATA environment variable
Other parameters: PGDATA/postmaster.opts.default

postmaster.opts.default contains parameters for postmaster. With a
default installation, the "-S" option is enabled. So "pg_ctl start"

postmaster -S

Note that postmaster.opts.default is installed by initdb from
lib/postmaster.opts.default.sample under the PostgreSQL installation
directory (lib/postmaster.opts.default.sample is copied from
src/bin/pg_ctl/postmaster.opts.default.sample while installing

To override default parameters you can use -D, -p and -o options.

-D database_dir
	specifies the database directory

-p path_to_postmaster
	specifies the path to postmaster

-o "postmaster_opts"
	specifies any parameters for postmaster


# blocks until postmaster comes up
pg_ctl -w start

# specifies postmaster path
pg_ctl -p /usr/local/pgsq/bin/postmaster start

# uses port 5433 and disables fsync
pg_ctl -o "-o -F -p 5433" start

Stopping postmaster

pg_ctl stop

stops postmaster.

There are several options for the stopping mode.

	waits for postmaster to shut down

-m [s[mart]|f[ast]|i[mmediate]]
       specifies the shutdown mode. smart mode waits for all
       the clients to logout. This is the default.
       fast mode sends SIGTERM to the backends, that means
       active transactions get rolled back. immediate mode sends SIGUSR1
       to the backends and lets them abort. In this case, database recovery
       will be neccessary on the next startup.

Restarting postmaster

This is almost equivalent to stopping postmaster then starting it
again except that the parameters for postmaster used before stopping
it would be used too. This is done by saving them in
PGDATA/postmaster.opts file. -w, -D, -m, -fast, -immediate and -o
can also be used in the restarting mode and they have same meanings as
described above.


# restarts postmaster in the simplest form
pg_ctl restart

# restarts postmaster, waiting for it to shut down and to come up
pg_ctl -w restart

# uses port 5433 and disables fsync next time
pg_ctl -o "-o -F -p 5433" restart

Getting status from postmaster

To get status information from postmaster:

pg_ctl status

Following is sample outputs from pg_ctl.

pg_ctl: postmaster is running (pid: 13718)
options are:
-p 5433
-D /usr/local/src/pgsql/current/data
-B 64
-b /usr/local/src/pgsql/current/bin/postgres
-N 32
-o '-F'




In response to

  • Doc updates at 2000-04-05 17:30:39 from Bruce Momjian


pgsql-docs by date

Next:From: Thomas LockhartDate: 2000-04-06 04:03:19
Subject: Re: [HACKERS] Doc updates
Previous:From: Bruce MomjianDate: 2000-04-05 17:30:39
Subject: Doc updates

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-04-06 04:03:19
Subject: Re: [HACKERS] Doc updates
Previous:From: Hiroshi InoueDate: 2000-04-06 01:37:14
Subject: RE: postgres crash on CURSORS

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group