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 commandsu - 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
smime.p7s
Description: S/MIME Cryptographic Signature
