From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems With -9.0.1 |
Date: | 2010-12-21 03:39:24 |
Message-ID: | alpine.LNX.2.00.1012201935390.6251@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 20 Dec 2010, Adrian Klaver wrote:
> Well that would be a problem. Still, using pg_ctl would be an improvement.
> From the docs
> (http://www.postgresql.org/docs/9.0/interactive/app-pg-ctl.html) "pg_ctl
> is a utility for initializing a PostgreSQL database cluster, starting,
> stopping, or restarting the PostgreSQL backend server (postgres), or
> displaying the status of a running server. Although the server can be
> started manually, pg_ctl encapsulates tasks such as redirecting log output
> and properly detaching from the terminal and process group. It also
> provides convenient options for controlled shutdown."
The script stops the running postgres. Since the only time I should need
to re-start it is after a re-boot (a distribution upgrade with a new
kernel), starting manually is not a big deal:
postgres(at)salmo:/home/rshepard$ postgres -D /usr/local/pgsql/data &
[1] 17318
postgres(at)salmo:/home/rshepard$ LOG: database system was shut down at
2010-12-20 19:04:58 PST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
[rshepard(at)salmo ~]$ ps ax | grep postgres
17318 pts/1 S 0:00 postgres -D /usr/local/pgsql/data
17320 ? Ss 0:00 postgres: writer process
17321 ? Ss 0:00 postgres: wal writer process
17322 ? Ss 0:00 postgres: autovacuum launcher process
17323 ? Ss 0:00 postgres: stats collector process
17405 pts/1 S+ 0:00 grep postgres
All processes running.
Thanks, Adrian,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Carbery | 2010-12-21 03:40:13 | Understanding PG9.0 streaming replication feature |
Previous Message | Adrian Klaver | 2010-12-21 03:30:59 | Re: Problems With -9.0.1 |