[Pgpool-general] Problem with init script of PostgreSQL!!!

Lazaro Ruben Garcia Martinez lgarciam at estudiantes.uci.cu
Tue Jul 27 15:21:56 UTC 2010


Thank you very much for your attention Devrim 
This is the output when I run bash -x /etc/init.d/postgresql status , If you find the reason for this status, please write me. 

Regards 

+ PGVERSION=8.3.3 
++ echo 8.3.3 
++ sed 's/^\([0-9]*\.[0-9]*\).*$/\1/' 
+ PGMAJORVERSION=8.3 
+ . /etc/rc.d/init.d/functions 
++ TEXTDOMAIN=initscripts 
++ umask 022 
++ PATH=/sbin:/usr/sbin:/bin:/usr/bin 
++ export PATH 
++ '[' -z '' ']' 
++ COLUMNS=80 
++ '[' -z '' ']' 
+++ /sbin/consoletype 
++ CONSOLETYPE=pty 
++ '[' -f /etc/sysconfig/i18n -a -z '' ']' 
++ . /etc/profile.d/lang.sh 
+++ sourced=0 
+++ for langfile in /etc/sysconfig/i18n '$HOME/.i18n' 
+++ '[' -f /etc/sysconfig/i18n ']' 
+++ . /etc/sysconfig/i18n 
++++ LANG=es_ES.UTF-8 
++++ SYSFONT=latarcyrheb-sun16 
+++ sourced=1 
+++ for langfile in /etc/sysconfig/i18n '$HOME/.i18n' 
+++ '[' -f /root/.i18n ']' 
+++ '[' -n '' ']' 
+++ '[' 1 = 1 ']' 
+++ '[' -n es_ES.UTF-8 ']' 
+++ export LANG 
+++ '[' -n '' ']' 
+++ unset LC_ADDRESS 
+++ '[' -n '' ']' 
+++ unset LC_CTYPE 
+++ '[' -n '' ']' 
+++ unset LC_COLLATE 
+++ '[' -n '' ']' 
+++ unset LC_IDENTIFICATION 
+++ '[' -n '' ']' 
+++ unset LC_MEASUREMENT 
+++ '[' -n '' ']' 
+++ unset LC_MESSAGES 
+++ '[' -n '' ']' 
+++ unset LC_MONETARY 
+++ '[' -n '' ']' 
+++ unset LC_NAME 
+++ '[' -n '' ']' 
+++ unset LC_NUMERIC 
+++ '[' -n '' ']' 
+++ unset LC_PAPER 
+++ '[' -n '' ']' 
+++ unset LC_TELEPHONE 
+++ '[' -n '' ']' 
+++ unset LC_TIME 
+++ '[' -n '' ']' 
+++ unset LC_ALL 
+++ '[' -n '' ']' 
+++ unset LANGUAGE 
+++ '[' -n '' ']' 
+++ unset LINGUAS 
+++ '[' -n '' ']' 
+++ unset _XKB_CHARSET 
+++ consoletype=pty 
+++ '[' -z pty ']' 
+++ '[' -n '' ']' 
+++ '[' -n '' ']' 
+++ '[' -n es_ES.UTF-8 ']' 
+++ case $LANG in 
+++ '[' xterm = linux ']' 
+++ unset SYSFONTACM SYSFONT 
+++ unset sourced 
+++ unset langfile 
++ '[' -z '' ']' 
++ '[' -f /etc/sysconfig/init ']' 
++ . /etc/sysconfig/init 
+++ BOOTUP=color 
+++ GRAPHICAL=yes 
+++ RES_COL=60 
+++ MOVE_TO_COL='echo -en \033[60G' 
+++ SETCOLOR_SUCCESS='echo -en \033[0;32m' 
+++ SETCOLOR_FAILURE='echo -en \033[0;31m' 
+++ SETCOLOR_WARNING='echo -en \033[0;33m' 
+++ SETCOLOR_NORMAL='echo -en \033[0;39m' 
+++ LOGLEVEL=3 
+++ PROMPT=yes 
+++ AUTOSWAP=no 
++ '[' pty = serial ']' 
++ '[' color '!=' verbose ']' 
++ INITLOG_ARGS=-q 
++ __sed_discard_ignored_files='/\(~\|\.bak\|\.orig\|\.rpmnew\|\.rpmorig\|\.rpmsave\)$/d' 
++ typeset -f 
++ grep declare 
+ TYPESET= 
+ . /etc/sysconfig/network 
++ NETWORKING=yes 
++ NETWORKING_IPV6=no 
++ HOSTNAME=localhost.localdomain 
++ basename /etc/init.d/postgresql 
+ NAME=postgresql 
+ '[' p = S -o p = K ']' 
+ '[' -x /sbin/runuser ']' 
+ SU=runuser 
+ PGENGINE=/usr/bin 
+ PGPORT=5432 
+ PGDATA=/var/lib/pgsql 
+ '[' -f /var/lib/pgsql/PG_VERSION ']' 
+ PGDATA=/var/lib/pgsql/data 
+ PGLOG=/var/lib/pgsql/pgstartup.log 
+ '[' -f /etc/sysconfig/pgsql/postgresql ']' 
+ export PGDATA 
+ export PGPORT 
+ '[' yes = no ']' 
+ '[' -f /usr/bin/postmaster ']' 
+ script_result=0 
+ case "$1" in 
+ status postmaster 
+ local base pid pid_file= 
+ '[' 1 = 0 ']' 
+ '[' postmaster = -p ']' 
+ base=postmaster 
+ __pids_var_run postmaster '' 
+ local base=postmaster 
+ local pid_file=/var/run/postmaster.pid 
+ pid= 
+ '[' -f /var/run/postmaster.pid ']' 
+ return 3 
+ RC=3 
+ '[' -z '' -a -z '' ']' 
++ __pids_pidof postmaster 
++ pidof -c -o 3493 -o 2671 -o %PPID -x postmaster 
++ pidof -c -o 3493 -o 2671 -o %PPID -x postmaster 
+ pid= 
+ '[' -n '' ']' 
+ case "$RC" in 
+ '[' -f /var/lock/subsys/postmaster ']' 
+ echo 'postmaster está parado' 
postmaster está parado 
+ return 3 
+ script_result=3 
+ exit 3 

----- "Devrim GÜNDÜZ" <devrim at gunduz.org> escribió: 
> On Tue, 2010-07-27 at 01:16 -0400, Lazaro Ruben Garcia Martinez wrote: 
> > When I carry out an Online Recovery all is fine, but when I 
> > execute /etc/init.d/postgresql status, this message is shown: 
> > postmaster is down, however I can connect to the server, but I don't 
> > know why, if the server is accepting connection, why this status is?. 
> 
> Could you please run 
> 
> bash -x /etc/init.d/postgresql status 
> 
> and send it to me so that we can do further analysis? You can send it 
> off-list, if you want. 
> 
> -- 
> Devrim GÜNDÜZ 
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer 
> PostgreSQL RPM Repository: http://yum.pgrpms.org 
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr 
> http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz 
> 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100727/0c3a580a/attachment.html>


More information about the Pgpool-general mailing list