This is a cryptographically signed message in MIME format.

--------------ms080008080602000002070707
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------ms080008080602000002070707
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCS qGSIb3DQEHAQAAoIII3TCC
AskwggIyoAMCAQICAw3f1zANBgkqhkiG9w0BAQQFADBiMQswCQ YDVQQGEwJaQTElMCMGA1UE
ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1 UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwMTI0MTExNT M3WhcNMDYwMTI0MTExNTM3
WjBAMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMR 0wGwYJKoZIhvcNAQkBFg5y
dXNsYW5kQHNjbi5ydTCCASIwDQYJKoZIhvcNAQEBBQADggEPAD CCAQoCggEBANKkj4vesWOT
lZ9gcs1+9U/7z4cXuy4qrp2wyYqpS3IH5iQxvok9C2xy3MguMrRHCmzfTKtfV oOfBzWYY1xc
QTWFS6/0EPEy5NXBIN/yeyJO7CcImgjLIeMVeRjDG1QFQcEyZqpHcBVclb8tfchD+ZAaW q+7
dJBQjYD6yOi4qXjNF+pZeB/88TSTKwnorn0PqFW7zbt25wbkkt432WC6l5n8wZR7K06tNDd4
Pr1rZHkc5TaxcXsLcmsbmXzdjEE4GmkzCFUFeicLP+JR8DcW/c3t4Eqs43VCItY0xUO3kKpL
RuE01mwyq9YBctNtOkXLSNwPMtAUZbFPFWVTlPIyVtsCAwEAAa MrMCkwGQYDVR0RBBIwEIEO
cnVzbGFuZEBzY24ucnUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQBina7aAnbg
SMXfFuMa0kHDOKIQaJDKNWxSPVpsAqdAYqqjX8lDGzv8E4ihXE Bx2f9G5uM2YGFTnfsDulFu
Fxndxjy5deuT85ShH8DiDXXVjieHI4bHI+Dtb7S38BxV4EqbmH BjNZ0DrhmH/GBsgiBG3bii
BRMx+ajlD1FbXc6FjDCCAskwggIyoAMCAQICAw3f1zANBgkqhk iG9w0BAQQFADBiMQswCQYD
VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKF B0eSkgTHRkLjEsMCoGA1UE
AxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0 EwHhcNMDUwMTI0MTExNTM3
WhcNMDYwMTI0MTExNTM3WjBAMR8wHQYDVQQDExZUaGF3dGUgRn JlZW1haWwgTWVtYmVyMR0w
GwYJKoZIhvcNAQkBFg5ydXNsYW5kQHNjbi5ydTCCASIwDQYJKo ZIhvcNAQEBBQADggEPADCC
AQoCggEBANKkj4vesWOTlZ9gcs1+9U/7z4cXuy4qrp2wyYqpS3IH5iQxvok9C2xy3MguMrRH
CmzfTKtfVoOfBzWYY1xcQTWFS6/0EPEy5NXBIN/yeyJO7CcImgjLIeMVeRjDG1QFQcEyZqpH
cBVclb8tfchD+ZAaWq+7dJBQjYD6yOi4qXjNF+pZeB/88TSTKwnorn0PqFW7zbt25wbkkt43
2WC6l5n8wZR7K06tNDd4Pr1rZHkc5TaxcXsLcmsbmXzdjEE4Gm kzCFUFeicLP+JR8DcW/c3t
4Eqs43VCItY0xUO3kKpLRuE01mwyq9YBctNtOkXLSNwPMtAUZb FPFWVTlPIyVtsCAwEAAaMr
MCkwGQYDVR0RBBIwEIEOcnVzbGFuZEBzY24ucnUwDAYDVR0TAQ H/BAIwADANBgkqhkiG9w0B
AQQFAAOBgQBina7aAnbgSMXfFuMa0kHDOKIQaJDKNWxSPVpsAq dAYqqjX8lDGzv8E4ihXEBx
2f9G5uM2YGFTnfsDulFuFxndxjy5deuT85ShH8DiDXXVjieHI4 bHI+Dtb7S38BxV4EqbmHBj
NZ0DrhmH/GBsgiBG3biiBRMx+ajlD1FbXc6FjDCCAz8wggKooAMCAQICAQ0 wDQYJKoZIhvcN
AQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZX JuIENhcGUxEjAQBgNVBAcT
CUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbm cxKDAmBgNVBAsTH0NlcnRp
ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1 RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZn JlZW1haWxAdGhhd3RlLmNv
bTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCz AJBgNVBAYTAlpBMSUwIwYD
VQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKg YDVQQDEyNUaGF3dGUgUGVy
c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w 0BAQEFAAOBjQAwgYkCgYEA
xKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkV
cI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+ux g+B79AgAJk16emu59l0cUq
VIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMG
A1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS 9UaGF3dGVQZXJzb25hbEZy
ZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB 4wHDEaMBgGA1UEAxMRUHJp
dmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUI PqCy7MDaNmrGcPf6+svsIX
oUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydx
VyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8x
ggM7MIIDNwIBATBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKEx xUaGF3dGUgQ29uc3VsdGlu
ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYW wgRnJlZW1haWwgSXNzdWlu
ZyBDQQIDDd/XMAkGBSsOAwIaBQCgggGnMBgGCSqGSIb3DQEJAzELBgkqhkiG9 w0BBwEwHAYJ
KoZIhvcNAQkFMQ8XDTA1MDYyNTEzNDc0NVowIwYJKoZIhvcNAQ kEMRYEFMVJq4rMz6uHtOQY
AiyNEWTuc9ROMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAw cwDgYIKoZIhvcNAwICAgCA
MA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAg EoMHgGCSsGAQQBgjcQBDFr
MGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb2 5zdWx0aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbC BJc3N1aW5nIENBAgMN39cw
egYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYTAlpBMSUwIw YDVQQKExxUaGF3dGUgQ29u
c3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUG Vyc29uYWwgRnJlZW1haWwg
SXNzdWluZyBDQQIDDd/XMA0GCSqGSIb3DQEBAQUABIIBAFVrLUoeDNDr8aSHhkETT8nLD G3M
+PPEy5YzrLqnA7by9EkWV5aU35tMm36rMV54OOsK/2aZXSvcsRJBLMae8ocyEvZNZ7cgpgjM
vqLeFajj+vW8A2utWcFxzUD4hwkh/AuP987aM2ptUAimecgJimCDSbsRduI86ZNp1ZD7DZaO
YJdiOwYN7hNaKhU1oON2wkIazw0UT85zPBIe5GWctLOsDEyKMn ukIEnLtoslflW4gZ+xdtuf
8XaRkrRNN38rqoby5UnVOn1SALEc7iokwLSN6oQM+xFtCM8qOQ 3r4juOA1/4vB96rle0Cspq
uPRyBWeuVOZjuGOSmMHQrvr7SYkAAAAAAAA=
--------------ms080008080602000002070707--

Ruslan A Dautkhanov <rusland (AT) scn (DOT) ru> writes:
That's fairly unusual --- I can't think of any places where the
postmaster will exit without printing *some* complaint.

Shouldn't there be an & or something in there? Seems like that will
leave the su command blocked waiting for the postmaster to exit,
which of course it should not.

That won't tell you anything --- the trace will only trace what "su" does.
Better to su to pgsql and ktrace the postmaster directly.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Ruslan A Dautkhanov <rusland (AT) scn (DOT) ru> writes:
No; indeed, if they were the same *then* I would worry.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly