Hi again, Here is the strace (with my comments in -----shes):
[EMAIL PROTECTED] postgres]$ strace /opt/postgres-7.4.1/bin/postmaster -D /data/postgres/ -i execve("/opt/postgres-7.4.1/bin/postmaster", ["/opt/postgres-7.4.1/bin/postmaster", "-D", "/data/postgres/", "-i"], [/* 27 vars */]) = 0 uname({sys="Linux", node="hubertus", ...}) = 0 brk(0) = 0x8270984 open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/local/pgsql/lib/mmx/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/local/pgsql/lib/mmx", 0xbfffdf80) = -1 ENOENT (No such file or directory) open("/usr/local/pgsql/lib/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/usr/local/pgsql/lib", 0xbfffdf80) = -1 ENOENT (No such file or directory) open("/opt/postgres-7.4.1/lib/mmx/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/opt/postgres-7.4.1/lib/mmx", 0xbfffdf80) = -1 ENOENT (No such file or directory) open("/opt/postgres-7.4.1/lib/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) stat64("/opt/postgres-7.4.1/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 open("mmx/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=116236, ...}) = 0 old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000 close(3) = 0 open("/usr/lib/libz.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\31\0"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=59778, ...}) = 0 old_mmap(NULL, 54984, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40031000 mprotect(0x4003d000, 5832, PROT_NONE) = 0 old_mmap(0x4003d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xb000) = 0x4003d000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libreadline.so.4", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libreadline.so.4", O_RDONLY) = -1 ENOENT (No such file or directory) open("libreadline.so.4", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/lib/libreadline.so.4", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\243"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=184567, ...}) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4003f000 old_mmap(NULL, 153200, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40040000 mprotect(0x40061000, 18032, PROT_NONE) = 0 old_mmap(0x40061000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x21000) = 0x40061000 old_mmap(0x40065000, 1648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40065000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libtermcap.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libtermcap.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libtermcap.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libtermcap.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\260\r\0"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=11832, ...}) = 0 old_mmap(NULL, 14932, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40066000 mprotect(0x40069000, 2644, PROT_NONE) = 0 old_mmap(0x40069000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x2000) = 0x40069000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libcrypt.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340\t\0"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=23575, ...}) = 0 old_mmap(NULL, 182876, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x4006a000 mprotect(0x4006f000, 162396, PROT_NONE) = 0 old_mmap(0x4006f000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x4000) = 0x4006f000 old_mmap(0x40070000, 158300, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40070000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libresolv.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libresolv.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libresolv.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libresolv.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\'\0"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=68925, ...}) = 0 old_mmap(NULL, 69408, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40097000 mprotect(0x400a5000, 12064, PROT_NONE) = 0 old_mmap(0x400a5000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xe000) = 0x400a5000 old_mmap(0x400a6000, 7968, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x400a6000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libnsl.so.1", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`:\0\000"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=89424, ...}) = 0 old_mmap(NULL, 84636, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x400a8000 mprotect(0x400ba000, 10908, PROT_NONE) = 0 old_mmap(0x400ba000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x12000) = 0x400ba000 old_mmap(0x400bb000, 6812, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x400bb000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/libdl.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\31"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=12102, ...}) = 0 old_mmap(NULL, 11640, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x400bd000 mprotect(0x400bf000, 3448, PROT_NONE) = 0 old_mmap(0x400bf000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x1000) = 0x400bf000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/i686/libm.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`7\0\000"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=173359, ...}) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x400c0000 old_mmap(NULL, 138292, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x400c1000 mprotect(0x400e2000, 3124, PROT_NONE) = 0 old_mmap(0x400e2000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x20000) = 0x400e2000 close(3) = 0 open("/opt/postgres-7.4.1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) open("/lib/i686/libc.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`u\1B4\0"..., 1024) = 1024 fstat64(3, {st_mode=S_IFREG|0755, st_size=1401027, ...}) = 0 old_mmap(0x42000000, 1264928, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x42000000 mprotect(0x4212c000, 36128, PROT_NONE) = 0 old_mmap(0x4212c000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x12c000) = 0x4212c000 old_mmap(0x42131000, 15648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x42131000 close(3) = 0 munmap(0x40014000, 116236) = 0 brk(0) = 0x8270984 brk(0x82709b4) = 0x82709b4 brk(0x8271000) = 0x8271000 brk(0x8272000) = 0x8272000 open("/usr/share/locale/locale.alias", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=2601, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000 read(3, "# Locale name alias data base.\n#"..., 4096) = 2601 read(3, "", 4096) = 0 close(3) = 0 munmap(0x40014000, 4096) = 0 open("/usr/lib/locale/en_US.iso885915/LC_COLLATE", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=22592, ...}) = 0 mmap2(NULL, 22592, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000 close(3) = 0 open("/usr/lib/gconv/gconv-modules.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=20666, ...}) = 0 mmap2(NULL, 20666, PROT_READ, MAP_SHARED, 3, 0) = 0x4001a000 close(3) = 0 open("/usr/lib/locale/en_US.iso885915/LC_CTYPE", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=173680, ...}) = 0 mmap2(NULL, 173680, PROT_READ, MAP_PRIVATE, 3, 0) = 0x400e3000 brk(0x8273000) = 0x8273000 close(3) = 0 open("/usr/lib/locale/en_US.iso885915/LC_MESSAGES", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 close(3) = 0 open("/usr/lib/locale/en_US.iso885915/LC_MESSAGES/SYS_LC_MESSAGES", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=58, ...}) = 0 mmap2(NULL, 58, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40020000 close(3) = 0 geteuid32() = 26 getuid32() = 26 geteuid32() = 26 umask(077) = 022 getpid() = 7463 brk(0x8276000) = 0x8276000 brk(0x8279000) = 0x8279000 open("/etc/localtime", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=766, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40021000 read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\6\0\0\0\6\0"..., 4096) = 766 close(3) = 0 munmap(0x40021000, 4096) = 0 stat64("/data/postgres/", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0 open("/data/postgres//PG_VERSION", O_RDONLY|O_LARGEFILE) = 3 fstat64(3, {st_mode=S_IFREG|0600, st_size=4, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40021000 read(3, "7.4\n", 4096) = 4 close(3) = 0 munmap(0x40021000, 4096) = 0 open("/data/postgres//global/pg_control", O_RDONLY|O_LARGEFILE) = 3 close(3) = 0 open("/data/postgres/postgresql.conf", O_RDONLY|O_LARGEFILE) = 3 brk(0x827e000) = 0x827e000 fstat64(3, {st_mode=S_IFREG|0600, st_size=7828, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40021000 read(3, "# -----------------------------\n"..., 8192) = 7828 read(3, "", 4096) = 0 read(3, "", 8192) = 0 close(3) = 0 munmap(0x40021000, 4096) = 0 open("/usr/lib/locale/en_US.iso885915/LC_MONETARY", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=292, ...}) = 0 mmap2(NULL, 292, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40021000 close(3) = 0 open("/usr/lib/locale/en_US.iso885915/LC_NUMERIC", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=60, ...}) = 0 mmap2(NULL, 60, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40022000 close(3) = 0 open("/usr/lib/locale/en_US.iso885915/LC_TIME", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=2457, ...}) = 0 mmap2(NULL, 2457, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40023000 close(3) = 0 stat64("/opt/postgres-7.4.1/bin/postgres", {st_mode=S_IFREG|0755, st_size=2310646, ...}) = 0 geteuid32() = 26 getpid() = 7463 open("/data/postgres/postmaster.pid", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 3 write(3, "7463\n/data/postgres\n", 20) = 20 close(3) = 0 open("/data/postgres/base", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 3 fstat64(3, {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0 fcntl64(3, F_SETFD, FD_CLOEXEC) = 0 brk(0x8280000) = 0x8280000 getdents64(0x3, 0x827d488, 0x1000, 0x827d488) = 136 open("/data/postgres/base/1/pgsql_tmp", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = -1 ENOENT (No such file or directory) open("/data/postgres/base/17141/pgsql_tmp", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = -1 ENOENT (No such file or directory) open("/data/postgres/base/17142/pgsql_tmp", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = -1 ENOENT (No such file or directory) getdents64(0x3, 0x827d488, 0x1000, 0x827d488) = 0 close(3) = 0 socket(PF_INET6, SOCK_STREAM, 0) = -1 EAFNOSUPPORT (Address family not supported by protocol) open("/usr/share/locale/en_US.iso885915/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/share/locale/en_US/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/share/locale/en.iso885915/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/share/locale/en/LC_MESSAGES/libc.mo", O_RDONLY) = -1 ENOENT (No such file or directory) write(2, "LOG: could not create IPv6 sock"..., 77LOG: could not create IPv6 socket: Address family not supported by protocol ) = 77 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3 setsockopt(3, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0 bind(3, {sin_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("0.0.0.0")}}, 16) = 0 listen(3, 200) = 0 getpid() = 7463 open("/tmp/.s.PGSQL.5432.lock", O_RDWR|O_CREAT|O_EXCL|O_LARGEFILE, 0600) = 4 write(4, "7463\n/data/postgres\n", 20) = 20 close(4) = 0 unlink("/tmp/.s.PGSQL.5432") = -1 ENOENT (No such file or directory) socket(PF_UNIX, SOCK_STREAM, 0) = 4 bind(4, {sin_family=AF_UNIX, path="/tmp/.s.PGSQL.5432"}, 110) = 0 chmod("/tmp/.s.PGSQL.5432", 0777) = 0 listen(4, 200) = 0 shmget(5432001, 10436608, IPC_CREAT|IPC_EXCL|0x180|0600) = 6520841 shmat(6520841, 0, 0) = 0x4010e000 open("/data/postgres/postmaster.pid", O_RDWR|O_LARGEFILE) = 5 read(5, "7463\n/data/postgres\n", 8092) = 20 _llseek(5, 0, [0], SEEK_SET) = 0 write(5, "7463\n/data/postgres\n 5432001 "..., 40) = 40 close(5) = 0 getpid() = 7463 open("/data/postgres/global/pg_control", O_RDWR|O_LARGEFILE) = 5 read(5, "Q\1vB\334\320\244\266H\0\0\0\303}\360\v\1\0\0\0\237\271"..., 360) = 360 close(5) = 0 semget(5432001, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43253761 semctl(43253761, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43253761, 0xbfffe7d0, 1) = 0 semctl(43253761, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43253761, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432002, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43286530 semctl(43286530, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43286530, 0xbfffe7d0, 1) = 0 semctl(43286530, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43286530, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432003, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43319299 semctl(43319299, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43319299, 0xbfffe7d0, 1) = 0 semctl(43319299, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43319299, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432004, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43352068 semctl(43352068, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43352068, 0xbfffe7d0, 1) = 0 semctl(43352068, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43352068, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432005, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43384837 semctl(43384837, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43384837, 0xbfffe7d0, 1) = 0 semctl(43384837, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43384837, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432006, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43417606 semctl(43417606, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43417606, 0xbfffe7d0, 1) = 0 semctl(43417606, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 5, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 6, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 7, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 8, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 9, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 10, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 11, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 12, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 13, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 14, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43417606, 15, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semget(5432007, 17, IPC_CREAT|IPC_EXCL|0x180|0600) = 43450375 semctl(43450375, 16, 0x110 /* SEM_??? */, 0xbfffe7b8) = 0 semop(43450375, 0xbfffe7d0, 1) = 0 semctl(43450375, 0, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43450375, 1, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43450375, 2, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43450375, 3, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 semctl(43450375, 4, 0x110 /* SEM_??? */, 0xbfffe7e8) = 0 stat64("/opt/postgres-7.4.1/bin/postmaster", {st_mode=S_IFREG|0755, st_size=2310646, ...}) = 0 geteuid32() = 26 open("/data/postgres/postmaster.opts", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0666) = 5 fstat64(5, {st_mode=S_IFREG|0600, st_size=0, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40024000 write(5, "/opt/postgres-7.4.1/bin/postmast"..., 63) = 63 close(5) = 0 munmap(0x40024000, 4096) = 0 rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8) = 0 rt_sigaction(SIGHUP, {0x812b664, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGINT, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGQUIT, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGTERM, {0x812b700, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGALRM, {SIG_IGN}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGUSR1, {0x812c864, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGUSR2, {0x812c9b8, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGCHLD, {0x812ba24, [], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGTTIN, {SIG_IGN}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGTTOU, {SIG_IGN}, {SIG_DFL}, 8) = 0 rt_sigaction(SIGXFSZ, {SIG_IGN}, {SIG_DFL}, 8) = 0 time(NULL) = 1075755436 getpid() = 7463 unlink("/data/postgres/global/pgstat.stat") = 0 gettimeofday({1075755436, 467187}, NULL) = 0 getpid() = 7463 open("/etc/resolv.conf", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=20, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40024000 read(5, "nameserver 10.0.1.1\n", 4096) = 20 read(5, "", 4096) = 0 close(5) = 0 munmap(0x40024000, 4096) = 0 uname({sys="Linux", node="hubertus", ...}) = 0 socket(PF_UNIX, SOCK_STREAM, 0) = 5 connect(5, {sin_family=AF_UNIX, path="/var/run/.nscd_socket"}, 110) = -1 ENOENT (No such file or directory) close(5) = 0 open("/etc/nsswitch.conf", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=1667, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40024000 read(5, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1667 read(5, "", 4096) = 0 close(5) = 0 munmap(0x40024000, 4096) = 0 open("/opt/postgres-7.4.1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=116236, ...}) = 0 old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) = 0x40b02000 close(5) = 0 open("/lib/libnss_files.so.2", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0\35\0"..., 1024) = 1024 fstat64(5, {st_mode=S_IFREG|0755, st_size=45415, ...}) = 0 old_mmap(NULL, 37848, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) = 0x40024000 mprotect(0x4002d000, 984, PROT_NONE) = 0 old_mmap(0x4002d000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5, 0x9000) = 0x4002d000 close(5) = 0 munmap(0x40b02000, 116236) = 0 open("/etc/host.conf", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=17, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(5, "order hosts,bind\n", 4096) = 17 read(5, "", 4096) = 0 close(5) = 0 munmap(0x4002e000, 4096) = 0 open("/etc/hosts", O_RDONLY) = 5 fcntl64(5, F_GETFD) = 0 fcntl64(5, F_SETFD, FD_CLOEXEC) = 0 fstat64(5, {st_mode=S_IFREG|0644, st_size=685, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(5, "# Do not remove the following li"..., 4096) = 685 read(5, "", 4096) = 0 close(5) = 0 munmap(0x4002e000, 4096) = 0 open("/opt/postgres-7.4.1/lib/libnss_nis.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libnss_nis.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libnss_nis.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=116236, ...}) = 0 old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) = 0x40b02000 close(5) = 0 open("/lib/libnss_nis.so.2", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\300\33"..., 1024) = 1024 fstat64(5, {st_mode=S_IFREG|0755, st_size=44746, ...}) = 0 old_mmap(NULL, 40864, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) = 0x40b1f000 mprotect(0x40b28000, 4000, PROT_NONE) = 0 old_mmap(0x40b28000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5, 0x8000) = 0x40b28000 close(5) = 0 brk(0x8281000) = 0x8281000 munmap(0x40b02000, 116236) = 0 uname({sys="Linux", node="hubertus", ...}) = 0 open("/var/yp/binding/navicon.2", O_RDONLY) = -1 ENOENT (No such file or directory) gettimeofday({1075755436, 537449}, NULL) = 0 socket(PF_INET, SOCK_DGRAM, IPPROTO_UDP) = 5 getpid() = 7463 bind(5, {sin_family=AF_INET, sin_port=htons(855), sin_addr=inet_addr("0.0.0.0")}}, 16) = -1 EACCES (Permission denied) ioctl(5, 0x5421, [1]) = 0 setsockopt(5, SOL_IP, IP_RECVERR, [1], 4) = 0 sendto(5, "=\316\273^\0\0\0\0\0\0\0\2\0\1\206\240\0\0\0\2\0\0\0\3"..., 56, 0, {sin_family=AF_INET, sin_port=htons(111), sin_addr=inet_addr("127.0.0.1")}}, 16) = 56 poll([{fd=5, events=POLLIN, revents=POLLIN}], 1, 5000) = 1 recvfrom(5, "=\316\273^\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 400, 0, {sin_family=AF_INET, sin_port=htons(111), sin_addr=inet_addr("127.0.0.1")}}, [16]) = 28 close(5) = 0 open("/opt/postgres-7.4.1/lib/libnss_dns.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("mmx/libnss_dns.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("libnss_dns.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=116236, ...}) = 0 old_mmap(NULL, 116236, PROT_READ, MAP_PRIVATE, 5, 0) = 0x40b02000 close(5) = 0 open("/lib/libnss_dns.so.2", O_RDONLY) = 5 read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\r\0"..., 1024) = 1024 fstat64(5, {st_mode=S_IFREG|0755, st_size=16051, ...}) = 0 old_mmap(NULL, 15912, PROT_READ|PROT_EXEC, MAP_PRIVATE, 5, 0) = 0x40b29000 mprotect(0x40b2c000, 3624, PROT_NONE) = 0 old_mmap(0x40b2c000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 5, 0x2000) = 0x40b2c000 close(5) = 0 munmap(0x40b02000, 116236) = 0 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 5 connect(5, {sin_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("10.0.1.1")}}, 28) = 0 send(5, "\204y\1\0\0\1\0\0\0\0\0\0\tlocalhost\0\0\34\0\1", 27, 0) = 27 gettimeofday({1075755436, 541777}, NULL) = 0 poll([{fd=5, events=POLLIN, revents=POLLIN}], 1, 5000) = 1 recvfrom(5, "\204y\201\200\0\1\0\0\0\1\0\1\tlocalhost\0\0\34\0\1\tl"..., 1024, 0, {sin_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("10.0.1.1")}}, [16]) = 66 close(5) = 0 gettimeofday({1075755436, 542281}, NULL) = 0 getpid() = 7463 open("/etc/resolv.conf", O_RDONLY) = 5 fstat64(5, {st_mode=S_IFREG|0644, st_size=20, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(5, "nameserver 10.0.1.1\n", 4096) = 20 read(5, "", 4096) = 0 close(5) = 0 munmap(0x4002e000, 4096) = 0 uname({sys="Linux", node="hubertus", ...}) = 0 socket(PF_UNIX, SOCK_STREAM, 0) = 5 connect(5, {sin_family=AF_UNIX, path="/var/run/.nscd_socket"}, 110) = -1 ENOENT (No such file or directory) close(5) = 0 open("/etc/hosts", O_RDONLY) = 5 fcntl64(5, F_GETFD) = 0 fcntl64(5, F_SETFD, FD_CLOEXEC) = 0 fstat64(5, {st_mode=S_IFREG|0644, st_size=685, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(5, "# Do not remove the following li"..., 4096) = 685 close(5) = 0 munmap(0x4002e000, 4096) = 0 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 5 bind(5, {sin_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}}, 16) = 0 getsockname(5, {sin_family=AF_INET, sin_port=htons(33043), sin_addr=inet_addr("127.0.0.1")}}, [16]) = 0 connect(5, {sin_family=AF_INET, sin_port=htons(33043), sin_addr=inet_addr("127.0.0.1")}}, 16) = 0 fcntl64(5, F_SETFL, O_RDONLY|O_NONBLOCK) = 0 pipe([6, 7]) = 0 time(NULL) = 1075755436 fork() = 7465 open("/data/postgres/pg_hba.conf", O_RDONLY|O_LARGEFILE) = 8 fstat64(8, {st_mode=S_IFREG|0600, st_size=3288, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(8, "# PostgreSQL Client Authenticati"..., 4096) = 3288 read(8, "", 4096) = 0 close(8) = 0 munmap(0x4002e000, 4096) = 0 open("/data/postgres/pg_ident.conf", O_RDONLY|O_LARGEFILE) = 8 fstat64(8, {st_mode=S_IFREG|0600, st_size=1441, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4002e000 read(8, "# PostgreSQL Ident Authenticatio"..., 4096) = 1441 read(8, "", 4096) = 0 close(8) = 0 munmap(0x4002e000, 4096) = 0 open("/data/postgres/global/pg_pwd", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/data/postgres/global/pg_group", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) fork() = 7467 LOG: database system was shut down at 2004-02-02 21:57:03 CET LOG: checkpoint record is at 0/9D34D8 LOG: redo record is at 0/9D34D8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 541; next OID: 17145 gettimeofday({1075755436, 618626}, {4294967236, 0}) = 0 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 select(5, [3 4], NULL, NULL, {60, 0}LOG: database system is ready ) = ? ERESTARTNOHAND (To be restarted) --- SIGCHLD (Child exited) --- rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8) = 0 wait4(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], WNOHANG, NULL) = 7467 time(NULL) = 1075755436 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 sigreturn() = ? (mask now []) rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8) = 0 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 select(5, [3 4], NULL, NULL, {60, 0} ----- server startup complete; about to connect psql ----------------------- ) = 1 (in [3], left {35, 180000}) rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS], NULL, 8) = 0 gettimeofday({1075755461, 448481}, {4294967236, 0}) = 0 accept(3, {sin_family=AF_INET, sin_port=htons(33470), sin_addr=inet_addr("127.0.0.1")}}, [16]) = 8 getsockname(8, {sin_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("127.0.0.1")}}, [16]) = 0 setsockopt(8, SOL_TCP, TCP_NODELAY, [1], 4) = 0 setsockopt(8, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0 fork() = 7470 close(8) = 0 time(NULL) = 1075755461 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 select(5, [3 4], NULL, NULL, {275, 0} ----- psql connected; about to CREATE FUNCTION ----------------------------- ERROR: could not access file "$libdir/ascii_and_mic": No such file or directory ----- CREATE FUNCTION attempted -------------------------------------------- Best regards, Thomas. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Monday, February 02, 2004 7:44 PM To: Thomas Borg Salling Cc: 'PostgreSQL Bugs List' Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or directory "Thomas Borg Salling" <[EMAIL PROTECTED]> writes: > I replaced "$libdir" with "/opt/postgres-7.4.1/lib" throughout > /opt/postgres-7.4.1/share/conversion_create.sql -- then initdb succeeded! Well, that proves the shared library wasn't broken, but it leaves us no wiser about what the problem really was. I'd like to keep after it. I tried configuring with a trailing "/" on a Red Hat 8.0 box here, and it seemed to work just fine. You did not specify what Red Hat release you were using, but I suspect that idea is a dead end. You could investigate further without having to reinitdb, just try the CREATE FUNCTION command in psql: CREATE OR REPLACE FUNCTION dummy (INTEGER, INTEGER, CSTRING, CSTRING,INTEGER) RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE 'c' STRICT; I expect this will fail as before. Could you strace the attached backend process while it's trying to do this command? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly