how to stop postmaster

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

Responses

Browse pgsql-novice by date

  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