From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | how to stop postmaster |
Date: | 2004-10-08 18:49:12 |
Message-ID: | 20041008184912.M83350@narrowpathinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi All,
I've just gotten PostgreSQL installed. The problem is now that I have started
the postmaster (incorrectly it appears) how do I stop it? I have read the
tips long enough to know that I shouldn't kill it! Here is what I did.
$ postmaster -D /raid02/databases/
LOG: database system was shut down at 2004-10-08 14:28:45 EDT
LOG: checkpoint record is at 0/8018BC
LOG: redo record is at 0/8018BC; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
$
$ pg_ctl stop -m smart
pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid
Is postmaster running?
$ ps -ef | grep postmaster
postgres 24379 24089 0 14:29 pts/5 00:00:00 postmaster -D
/raid02/databases/postgres 24481 24089 0 14:36 pts/5 00:00:00 grep postmaster
$ pg_ctl status
pg_ctl: postmaster or postgres is not running
$
I would also like to know how to start the postmaster properly on a permanent
basis. For instance at boot time.
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-10-08 20:14:12 | Re: how to stop postmaster |
Previous Message | Michael Fuhr | 2004-10-08 14:02:06 | Re: Help with trigger |