ps -ae | grep post
  748 ?        00:00:00 postmaster
  750 ?        00:00:00 postmaster

kill -1 748

Todd Joyce
Network Services
Radford University - The Smart Choice
[log in to unmask]
(540) 831-7777
 
Keep your boots and ChapStick and ice hotels.
Give me shorts and sandals and a thirty-blocker.

Temperance Brennan - Monday Mourning
-----Original Message-----
From: Perfigo SecureSmart and CleanMachines Discussion List
[mailto:[log in to unmask]] On Behalf Of Lanstein, Alex C
Sent: Wednesday, February 22, 2006 12:33 PM
To: [log in to unmask]
Subject: postgres changes

Well, I've found the API to be inadequate for what I'm trying to do
(make a page where our help desk can see what users are blocked).  So,
I'm going to query the database directly.  I know I need to make the
permission changes in pg_hba.conf, and to do that I have to edit the
make-pg_hba_conf.pl script.  I

I did that, but I know I have to restart the perfigo service.  Tom, from
this list, said he just did a /etc/init.d perfigo restart and his
changes took effect, but when I did that something didn't start up
properly and it was throwing license errors like mad.  I didn't have a
chance to look into it, since I had just taken down the dorm's abilities
to login temporarily, so I had to restart it quickly.  My changes took
effect once I rebooted, but I'd like to know just how to restart the
postgres service (the 'perfigo way'... /sbin/service postgres restart
borked it too) without rebooting.  I set a fairly unrestrictive set of
mapping rules to the db and I'd like to lock it down a little more with
the ident stuff postgres does as well.

Any thoughts?

Thanks in advance,

Alex Lanstein