indices are crashed after installation of rpm

From: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: indices are crashed after installation of rpm
Date: 2001-04-24 14:08:41
Message-ID: 01042416084104.00785@va45c13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello all,
we are running PostgreSQL 7.0.2 on Solaris 2.6,/x86 compiled by gcc 2.8.1.
For installation Postgres on 70 Solaris-2.6 server we built packages
(SVR4-style).

The first time we installed Postgres everything was ok. But after a new
installation of the package ( - same Postgres version! - just the starting
script changed) all indices where damaged (this is reproducible).

In the installation script the postmaster is stopped and started. Is it
possible the stopping and starting is crashing the indices,
because sometimes just stopping and starting the postmaster ist crashing the
indices (not reproducible)?

Has someone any idea what's wrong, do you need more informations?
greetings,
Peter

this ist the starting/stopping script S99postgres:

#!/bin/sh

umask 077

killdaemon()
{
PIDs=`ps -u postgres | sed '/PID/d;s/ \{1,\}/ /g' | cut -d" " -f2 |
sort -rn`
[ -n "$PIDs" ] && kill $PIDs
[ -f /tmp/.s.PGSQL.5432 ] && rm -f /tmp/.s.PGSQL.5432
echo "postmaster stopped"
}

startdaemon()
{
su postgres -c /export/home/postgres/start_postgres
echo "postmaster started"

su postgres -c /export/home/postgres/chk_user \
&& su postgres -c /export/home/postgres/create_user
}

case "$1" in
'start')
startdaemon
;;
'stop')
killdaemon
;;
'restart')
killdaemon
startdaemon
;;
*)
echo "Usage: $0 { start | stop | restart }"
;;
esac

exit 0

++++++++++++++++++++++++++
and start_postgres:

PATH=/opt/local/bin:$PATH:/opt/local/DWH/bin:.
LD_LIBRARY_PATH=/usr/openwin/lib:/usr/dt/lib:/opt/local/DWH/lib
export PATH LD_LIBRARY_PATH

PGLIB=/DWH/lib
PGDATA=$HOME/data
export PGLIB PGDATA

postmaster -i -D /export/home/postgres/data >> /tmp/postgres.log

--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
...............................................................................................
Peter Keller : Tel: (+49) 089-2190-2594
Vermessungsrat : Fax: (+49) 089-2190-2459
Alexandrastr. 3 : mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung

Sie finden uns:
http://www2.stadtplandienst.de/query;ORT=m;LL=11.591107x48.142584;GR=5;PRINTER_FRIENDLY=TRUE

******************************************************************
Bitte merken Sie sich vor:
Zum 200. Geburtstag der Bayerischen Vermessungsverwaltung
findet am Samstag, den 23. Juni 2001 von 10 bis 17 Uhr
ein Tag der offenen Tür am Staatlichen Vermessungsamt München
und am Bayerischen Landesvermessungsamt statt.
******************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2001-04-24 14:33:21 RE: pg_dump failure: "handler procedure for language pl pgsql not foun d"
Previous Message Joel Burton 2001-04-24 13:44:48 Performance: sql functions v. plpgsql v. plperl