can't startup PG-8.0.3

From: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: can't startup PG-8.0.3
Date: 2005-06-25 13:47:45
Message-ID: 42BD6081.2080302@scn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-06-25 14:46:05 Re: can't startup PG-8.0.3
Previous Message Tom Lane 2005-06-25 04:20:38 Re: [BUGS] BUG #1467: fe_connect doesn't handle EINTR right