Le ven 14/11/2003 à 16:14, Warly a écrit : > -=-=-=- > Name : postgresql Relocations: (not relocateable) > Version : 7.3.4 Vendor: MandrakeSoft > Release : 5mdk Build Date: Fri Nov 14 16:21:02 2003
Interesting problem : I had a problem starting postgresql after having rebooting my computer and unfortunately nothing was displayed. i had to start manually in debugging mode postgresql ( /usr/bin/pg_ctl start -D /var/lib/pgsql/data/ -o "-d 5" ). What I see is that it failed one time to launch because /var/lib/pgsql/data/postmaster.pid exist and was empty. So the only way to make it start was to remove this file. IMHO, in /etc/init.d/postgresql we should ensure that this file have been removed. Normally this file is removed when postgresql is stopped or when we launched postgresql and no postmatser process is running, but it seems that there can have some case when this is not true A patch is joined adding this possibility. - output when postgresql failed to start : DEBUG: FindExec: found "/usr/bin/postgres" using argv[0] FATAL: Can't read lock file /var/lib/pgsql/data/postmaster.pid: File exists DEBUG: proc_exit(1) DEBUG: shmem_exit(1) DEBUG: exit(1) - content of /var/lib/pgsql/data/postmaster.pid when postgresql is running : 6496 /var/lib/pgsql/data 5432001 4685834 --- Pour chaque etre, il existe une sorte d'activite ou il serait utile a la societe, en meme temps qu'il y trouverait son bonheur. -- Maurice Barres
--- postgresql 2003-11-14 15:20:41.000000000 +0000 +++ postgresql.new 2003-11-19 19:01:26.000000000 +0000 @@ -153,6 +153,7 @@ else #all systems go -- remove any stale lock files rm -f /tmp/.s.PGSQL.${PGPORT} > /dev/null + rm -f /var/lib/pgsql/data/postmaster.pid > /dev/null gprintf "%s" "$PSQL_START" su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null sleep 1