[GENERAL] postmaster does not come up
this is in continuation of the problem i was facing
some time back.
if i try to start postmaster ...it times out.
what can be the possible cause of it . I also have seen a core file being
generated.
in case such a thing happens ... what shuld i be doing?
how can i recover my database in such a situation?
i ll again copy paste the script i am using for starting up and shutting
down postmaster
#! /bin/sh# dbxd Script for starting up the
PostgreSQL#
server in the daemon mode##
# postgreSQL version is:PGVERSION=8.0
# Name of the scriptNAME=dbxd# Command issued
start/stop/restartaction=""# Get SDC configiration# .
$SDCHOME/.SdCrc# Set defaults for port and database
directoryPOSTGRES_LOG="$SDCHOME/nuevo/logfiles/postgreslog"if [ ! -f
$POSTGRES_LOG ]; then touch $POSTGRES_LOG chown
sdc:200 $POSTGRES_LOG chmod 777 $POSTGRES_LOGfiif [
"`uname`" = "Linux" ]; then #DEVMACHINE=`file /export/dbsroot |
grep -c directory`
POSTMASTER=/usr/bin/postmaster PGCTL="/usr/bin/pg_ctl -w
" INITDB=/usr/bin/initdb
PGDATA=$SdC_IMAGE_POOL/dbx PGPORT=5432else
echo "Cannot launch POSTGRES , unknown OS" echo " [ FAILED
]" exit 1fiif [ "`uname`" = "Linux" ];
then INITD=/etc/rc.d/init.d .
$INITD/functions # Get config. .
/etc/sysconfig/networkfi# Check that networking is up.# Pretty much
need it for postmaster.if [ "`uname`" = "Linux" ]; then [
"${NETWORKING}" = "no" ] && exit 0fi
start(){
# Check for the PGDATA
structure if [ -f
$PGDATA/PG_VERSION ] && [ -d $PGDATA/base
]
then # Check version of existing
PGDATA
INSTPG_VERSION=`cat
$PGDATA/PG_VERSION`
if [ $INSTPG_VERSION != '8.0' -a $INSTPG_VERSION != '8.1'
]
then
echo "An old version of the database format was
found.\n"
exit
1
fi
else # No existing PGDATA - call
initdb
echo "Initializing database:
"
#chmod 755
/var/lib/pgsql
if [ ! -d $PGDATA
]
then
mkdir -p
$PGDATA
fi
chown $SDCUSER:$SDCUSER
$PGDATA
chmod go-rwx
$PGDATA
# Make sure the locale from the initdb is preserved for later
startups...
[ -f /etc/sysconfig/i18n ] && cp /etc/sysconfig/i18n
$PGDATA/../initdb.i18n
# Just in case no locale was set, use en_US on
Linux
if [ "`uname`" = "Linux" ];
then
[ ! -f /etc/sysconfig/i18n ] && echo "LANG=en_US" >
$PGDATA/../initdb.i18n
fi
# Initialize the
database
if [ "`uname`" = "Linux" ];
then
/bin/sh -c "$INITDB --pgdata=$PGDATA > /dev/null 2>&1" <
/dev/null
fi
# Modify original postgres settings so that local connection are
trusted
mv $PGDATA/pg_hba.conf
$PGDATA/pg_hba.conf.orig
cat $PGDATA/pg_hba.conf.orig | sed "s/^local.*/local
all all trust/" >
$PGDATA/pg_hba.conf
chown $SDCUSER:$SDCUSER
$PGDATA/pg_hba.conf
chmod 600
$PGDATA/pg_hba.conf
rm $PGDATA/pg_hba.conf.orig
fi # Check for postmaster already
running... # note that pg_ctl only
looks at the data structures in
PGDATA # you really do need the
pidof() if [ "`uname`" = "Linux"
]; then
pid=`pidof -s postmaster`
else pid=`ps
-eaf | grep postmaster | grep -v grep | tail -1 | awk '{print
$2}'`
fi if [ $pid ] && $PGCTL
status -D $PGDATA > /dev/null
2>&1
then
echo "Postmaster already running."
else
if [ "`uname`" = "Linux" ];
then
rm -f /tmp/.s.PGSQL.${PGPORT} >
/dev/null
rm -f /tmp/.s.PGSQL.${PGPORT}.lock >
/dev/null
rm -f $PGDATA/postmaster.pid >
/dev/null
/bin/sh -c "$PGCTL -l $POSTGRES_LOG -D $PGDATA -p $POSTMASTER -o '-p ${PGPORT}'
start > /dev/null 2>&1"<
/dev/null
fi
sleep
1
if [ "`uname`" = "Linux" ];
then
pid=`pidof -s
postmaster`
else
pid=`ps -eaf | grep postmaster | grep -v grep | tail -1 | awk '{print
$2}'`
fi
if [ $pid
]
then
#echo "success
$PSQL_START"
echo_success
else
#echo "failure
$PSQL_START"
echo_failure
fi
fi}
stop(){ echo "Stopping
${NAME} service: " if [ "`uname`"
= "Linux" ];
then /bin/sh -c
"$PGCTL stop -D $PGDATA -s -m fast" > /dev/null
2>&1
fi
ret=$? if [ $ret -eq 0
]
then
[GENERAL] postmaster does not come up
hi all.. sometime back i had asked a question is ther no way to recove the database in case postmaster fails to come up?? i dont remember what was there in the log file ... i had seen it sometime back ...for which i dont have the logs i dint check if by restarting the system the problem would go away?.. do u need to take pg_dump then at regular intervals ? thanks, regards Surabhi
Re: [GENERAL] postmaster does not come up
On 11/25/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote: if i try to start postmaster ...it times out. what can be the possible cause of it . I also have seen a core file being generated.i ll again copy paste the script i am using for starting up and shutting down postmasterPOSTGRES_LOG="$SDCHOME/nuevo/logfiles/postgreslog" what does the log say? depesz
Re: [GENERAL] postmaster does not come up
it just times out and nothing was there in the logs ... i just specified the log file name while starting postmsater but it had nothing From: hubert depesz lubaczewski [mailto:[EMAIL PROTECTED]Sent: Fri 11/25/2005 1:22 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] postmaster does not come up *** Your mail has been scanned by InterScan VirusWall. ***-*** On 11/25/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote: if i try to start postmaster ...it times out. what can be the possible cause of it . I also have seen a core file being generated. i ll again copy paste the script i am using for starting up and shutting down postmaster POSTGRES_LOG="$SDCHOME/nuevo/logfiles/postgreslog"what does the log say?depesz
Re: [GENERAL] postmaster does not come up
This is a little vague...There is a way to recover the data. Make postmaster come back up. Unless you're talking about postmaster not coming up due to corrupted data files, or a hardware failure.You do need to use pg_dump at regular intervals. It is common practice to back up data, after all. Now, instead of being vague, let's see if you can't give us a bit more information about why your postmaster is failing to start. Have you tried starting it manually? For example, running postmaster directly from the command line. Like so: postmaster -D /usr/local/pgsql/dataReplace "/usr/local/pgsql/data" with the path to your own. If postmaster fails to come up, what errors/warnings did it report? On 12/5/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote: hi all.. sometime back i had asked a question is ther no way to recove the database in case postmaster fails to come up?? i dont remember what was there in the log file ... i had seen it sometime back ...for which i dont have the logs i dint check if by restarting the system the problem would go away?.. do u need to take pg_dump then at regular intervals ? thanks, regards Surabhi
