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

slpd restart restarted postgres

From: dx k9 <bitsandbytes88(at)hotmail(dot)com>
To: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: slpd restart restarted postgres
Date: 2009-04-21 13:31:13
Message-ID: COL120-W306156711C9C37839D18A4D1770@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I wanted to report a new way to shut down a postgres instance.   I was troubleshooting a PAM-warning message in syslog and decided to restart slpd /etc/init.d/slpd,  since I made a small change in ldap.conf,  the OpenSLP daemon for the Service Location Protocol.  It caused both instances of postgres ( i have 2 running a one system one 8.24 and one 8.36)  to stop with a fast shutdown by admin(see below).  The first time it happened right after I re-started slpd and the second time there was a 2 hour delay, then it shut down both instances.  Has anyone ever seen that happen before or know why that could have caused postgres to shut down.  I was troubleshooting a PAM-warn message with SLES 9 2.6.5-7.308-smp, sp4 and thought it would be worth a shot.  It  did stop those PAM-warnings for a while, since the instance was down.  :)

~DjK

< % %2009-04-17 10:22:32 
EDT>LOG:  received fast shutdown request
< % %2009-04-17 10:22:32 
EDT>LOG:  aborting any active transactions
<t_server %system 
%2009-04-17 10:22:32 EDT>FATAL:  terminating connection due to administrator 
command
<t_server %system 
%2009-04-17 10:22:32 EDT>FATAL:  terminating connection due to administrator 
command
<bb %ce %2009-04-17 
10:22:32 EDT>FATAL:  terminating connection due to administrator 
command




17 10:03:04 pa PAM-warn[20051]: function=[pam_sm_acct_mgmt] 
service=[postgresql] terminal=[<unknown>] user=[postgres] 
ruser=[<unknown>] rhost=[<unknown>] 
Apr 17 10:03:39 pa 
PAM-warn[20387]: function=[pam_sm_authenticate] service=[postgresql] 
terminal=[<unknown>] user=[postgres] ruser=[<unknown>] 
rhost=[<unknown>] 
Apr 17 10:03:39 pa PAM-warn[20387]: 
function=[pam_sm_acct_mgmt] service=[postgresql] terminal=[<unknown>] 
user=[postgres] ruser=[<unknown>] rhost=[<unknown>] 


pam_radius-1.3.16-65.1

pam-0.77-221.11

pam-modules-9-18.19

pam_ldap-169-28.7

spamassassin-3.1.9-0.3

pam-32bit-9-200710171330

pam_ldap-32bit-9-200610241503

pam_smb-2.0.0rc5-38.3

yast2-pam-2.9.15-0.1

pam-devel-0.77-221.11

pam_krb5-1.3-201.12

perl-spamassassin-3.1.9-0.3

pam-modules-32bit-9-200711021346


_________________________________________________________________
Rediscover HotmailĀ®: Get quick friend updates right in your inbox. 
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Updates2_042009

pgsql-admin by date

Next:From: May, RandyDate: 2009-04-21 15:13:48
Subject: License Issue
Previous:From: Alvaro HerreraDate: 2009-04-20 19:03:37
Subject: Re: postgres 8.2.9 transaction id wraparound failure

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