Home > mailing lists
can't startup PG-8.0.3 - Mailing list pgsql-bugs

From	Ruslan A Dautkhanov
Subject	can't startup PG-8.0.3
Date	June 25, 2005 10:48:03
Msg-id	42BD6081.2080302@scn.ru Whole thread Raw
Responses	Re: can't startup PG-8.0.3
List	pgsql-bugs
Tree view
Hello !

I can't startup PostgreSQL 8.0.3 on my server. The OS is
# uname -a
FreeBSD 5.4-RC3 #1: Mon Apr 25 11:58:52 KRAST 2005

I have experience with PostgreSQL 7.x, and I can't figure out why this
happen. PG didn't
say anything meaningful, that can point me why he did not start.

I have a command
    su - pgsql -c '/usr/local/pgsql/bin/postmaster -d 5 -D
/usr/local/pgsql/data'
and a last output of it is
...
%DEBUG:  TZ "SystemV/PST8" scores 0: at 1074099600 2004-01-14 09:00:00
std versus 2004-01-15 00:00:00 std
%DEBUG:  TZ "SystemV/YST9" scores 0: at 1074099600 2004-01-14 08:00:00
std versus 2004-01-15 00:00:00 std
%DEBUG:  TZ "SystemV/HST10" scores 0: at 1074099600 2004-01-14 07:00:00
std versus 2004-01-15 00:00:00 std
%DEBUG:  Reject TZ "Mideast/Riyadh87": uses leap seconds
%DEBUG:  Reject TZ "Mideast/Riyadh88": uses leap seconds
%DEBUG:  Reject TZ "Mideast/Riyadh89": uses leap seconds
%DEBUG:  postmaster: PostmasterMain: initial environ dump:
%DEBUG:  -----------------------------------------
%DEBUG:         TERM=xterm
%DEBUG:         SHELL=/usr/local/bin/bash
%DEBUG:         USER=pgsql
%DEBUG:         PGLIB=/usr/local/lib
%DEBUG:         FTP_PASSIVE_MODE=YES
%DEBUG:         MAIL=/var/mail/pgsql
%DEBUG:
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/pgsql/bin
%DEBUG:         BLOCKSIZE=K
%DEBUG:         PWD=/usr/local/pgsql
%DEBUG:         SHLVL=1
%DEBUG:         HOME=/usr/local/pgsql
%DEBUG:         PGDATA=/usr/local/pgsql/data
%DEBUG:         _=/usr/local/pgsql/bin/postmaster
%DEBUG:         PGSYSCONFDIR=/usr/local/pgsql/etc
%DEBUG:  -----------------------------------------

I even tries to use ktrace(1) :
    ktrace su - pgsql -c '/usr/local/pgsql/bin/postmaster -d 5 -D
/usr/local/pgsql/data'
and a last lines of kdump is
 80040 su       CALL  close(0x3)
 80040 su       RET   close 0
 80040 su       CALL  seteuid(0)
 80040 su       RET   seteuid 0
 80040 su       CALL  setegid(0x46)
 80040 su       RET   setegid 0
 80040 su       CALL  sigaction(0x2,0xbfbfe764,0xbfbfe744)
 80040 su       RET   sigaction 0
 80040 su       CALL  sigaction(0x3,0xbfbfe764,0xbfbfe724)
 80040 su       RET   sigaction 0
 80040 su       CALL  sigaction(0xd,0xbfbfe764,0xbfbfe704)
 80040 su       RET   sigaction 0
 80040 su       CALL  sigaction(0x12,0xbfbfe764,0)
 80040 su       RET   sigaction 0
 80040 su       CALL  pipe
 80040 su       RET   pipe 3
 80040 su       CALL  fork
 80040 su       RET   fork 80041/0x138a9
 80040 su       CALL  sigaction(0x16,0xbfbfe764,0)
 80040 su       RET   sigaction 0
 80040 su       CALL  close(0x3)
 80040 su       RET   close 0
 80040 su       CALL  setpgid(0x138a9,0x138a9)
 80040 su       RET   setpgid 0
 80040 su       CALL  ioctl(0x2,TIOCSPGRP,0xbfbfe660)
 80040 su       RET   ioctl 0
 80040 su       CALL  close(0x4)
 80040 su       RET   close 0
 80040 su       CALL  sigaction(0xd,0xbfbfe704,0)
 80040 su       RET   sigaction 0
 80040 su       CALL  wait4(0x138a9,0xbfbfe6e8,0x2,0)
 80040 su       RET   wait4 80041/0x138a9
 80040 su       CALL  getpgrp
 80040 su       RET   getpgrp 6052/0x17a4
 80040 su       CALL  ioctl(0x2,TIOCSPGRP,0xbfbfe660)
 80040 su       RET   ioctl 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe4d0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe4d0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x28181000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe4f0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe4f0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x2816c000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  munmap(0x2816e000,0x9000)
 80040 su       RET   munmap 0
 80040 su       CALL  munmap(0x28177000,0xa000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe510)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe510)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x2816a000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe530)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe530)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x28168000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe550)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe550)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x28166000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe530)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe530)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x28183000,0x4000)
 80040 su       RET   munmap 0
 80040 su       CALL  munmap(0x28187000,0x18000)
 80040 su       RET   munmap 0
 80040 su       CALL  munmap(0x2819f000,0x5000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe550)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe550)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x281a4000,0x3000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x1,0x2806baa0,0xbfbfe550)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       RET   sigprocmask 0
 80040 su       CALL  munmap(0x281a7000,0x2000)
 80040 su       RET   munmap 0
 80040 su       CALL  sigprocmask(0x3,0x2806bab0,0)
 80040 su       RET   sigprocmask 0
 80040 su       CALL  exit(0)

and this didn't help...

The configure script for PG was:
./configure \
  --enable-locale \
    --enable-recode \
      --with-pgport=6543 \
        --enable-cassert \
          --with-perl \
            --enable-odbc

# ./postgres --version
postgres (PostgreSQL) 8.0.3

I also tried to use pg_ctl to startup PG instance, but it silently stops:
       could not start postmaster

Thanks a lot for any helpful info.

--
Ruslan A Dautkhanov
pgsql-bugs by date:
From: elein@varlena.com (elein)
Date: 24 June 2005, 22:52:29
Subject: Timestamp in log for prepared queries
From: Tom Lane
Date: 25 June 2005, 11:46:09
Subject: Re: can't startup PG-8.0.3
can't startup PG-8.0.3 - Mailing list pgsql-bugs

Previous

Next
