[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