error reiniciar postmaster

From: tgutierrez(at)unipamplona(dot)edu(dot)co
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: error reiniciar postmaster
Date: 2004-10-06 00:37:25
Message-ID: 39917.64.76.58.174.1097023045.squirrel@correo.unipamplona.edu.co
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Saludos amigos,

en el sistema operativo suse 9.0
tengo instalado la version de postgresql:
postgresql-7.3.4-53

---------------------------------------------------------------
--------------------------------------------------------------
al ejecutarlo sh postgresql start
me aparece el siguiente error:

:/etc/init.d # sh postgresql start
Starting PostgreSQLpg_ctl: postmaster does not start
failed

-----------------------------------------------------------
la carpeta /var/lib/pgsql/data tiene como propietario y grupo postgres
los archivos ubicados en la carpeta tambien:
/var/lib/pgsql/data # ls -l
total 25
drwxrwxrwx 6 postgres postgres 304 2004-10-05 17:58 .
drwxrwxrwx 4 postgres postgres 240 2004-10-05 17:21 ..
drwxrwxrwx 5 postgres postgres 120 2004-10-02 15:50 base
drwxrwxrwx 2 postgres postgres 496 2004-10-05 15:11 global
drwxrwxrwx 2 postgres postgres 72 2004-10-02 12:42 pg_clog
-rwxrwxrwx 1 postgres postgres 2544 2004-10-02 12:55 pg_hba.conf
-rwxrwxrwx 1 postgres postgres 1441 2004-10-02 12:42 pg_ident.conf
-rwxrwxrwx 1 postgres postgres 4 2004-10-02 12:42 PG_VERSION
drwxrwxrwx 2 postgres postgres 112 2004-10-02 15:57 pg_xlog
-rwxrwxrwx 1 postgres postgres 5213 2004-10-05 17:56 postgresql.conf
-rwxrwxrwx 1 postgres postgres 25 2004-10-05 14:45 postmaster.opts
----------------------------------------------------------

en el archivo: postgresql ubicado en /etc/init.d
aparece:
---------------------------------------------------------------------------
/etc/init.d # vi postgresql
fi
echo -n "Starting PostgreSQL"
## remove old socket, if it exists and no daemon is running.
checkproc $H || {
rm -f /tmp/.s.PGSQL.5432
rm -f /var/lib/pgsql/data/postmaster.pid
}

## Start daemon with startproc(8). If this fails
## the echo return value is set appropriate.
#/sbin/startproc -e -t 1 -u postgres -l $LOGFILE $H $OPTIONS
-D$DATADIR
pg_ctl start -s -w -p $H -l $LOGFILE -D $DATADIR -o "\"$OPTIONS\""
rc_status -v
;;

stop)
echo -n "Shutting down PostgreSQL"
## Stop daemon with killproc(8) and if this fails
## set the echo return value.

pg_ctl stop -s -D $DATADIR -m fast
rc_status -v
;;

try-restart)
## Stop the service and if this succeeds (i.e. the
## service was running before), start it again.
## Note: try-restart is not (yet) part of LSB (as of 0.7.5)
$0 status && $0 restart
;;

restart)
## Stop the service and regardless of whether it was
## running or not, start it again.
$0 stop
$0 start
rc_status
;;

force-reload | reload)
echo -n "Reloading configuration for PostgreSQL"
killproc -HUP $H
rc_status -v
;;

status)
echo -n "Checking for PostgreSQL: "
## Check status with checkproc(8), if process is running
## checkproc will return with exit status 0.

# Status has a slightly different for the status command:
# 0 - service running
# 1 - service dead, but /var/run/ pid file exists
# 2 - service dead, but /var/lock/ lock file exists
# 3 - service not running

# NOTE: checkproc returns LSB compliant status values.
checkproc $H
rc_status -v
;;

probe)
rc_failed 3
rc_status -v
;;

*)
echo "Usage: $0
{start|stop|status|try-restart|restart|force-reload|reload|probe}"
exit 1
;;
esac

# Inform the caller not only verbosely and set an exit status.
rc_exit
--------------------

gracias
Tania Gutierrez

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jose Luis Cocha (RAAA) 2004-10-06 04:14:49 COMO RECUPERAR DATOS DESDE ESTRUCTURA DE DIRECTORIOS POSTGRES
Previous Message Gustavo Garay 2004-10-05 20:21:06 Re: psql: server closed the connection unexpectedly