Re: Restart after poweroutage

Tom Lane wrote:
> Jon Lapham <lapham(at)jandr(dot)org> writes:
>> Tom Lane wrote:
>>> Let's see the output from
>>> sudo ipcs -a
>
>> [root(at)bilbo ~]# ipcs -a
>
> [ no postgres-owned segments... ]
>
> Well, that's dang interesting. Could you run the postmaster under
> strace and send the output?

Let me know if this is correct. I made this change to the init script:

[root(at)bilbo ~]# diff /etc/init.d/postgresql /etc/init.d/postgresql_strace
190c190
< $SU -l postgres -c "$PGENGINE/postmaster -p '$PGPORT' -D
'$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null
---
> $SU -l postgres -c "/usr/bin/strace $PGENGINE/postmaster -p
'$PGPORT' -D '$PGDATA' ${PGOPTS} &" >> "$PGLOG" 2>&1 < /dev/null

...which gives this output to the log file after running "service
postgresql start":

execve("/usr/bin/postmaster", ["/usr/bin/postmaster", "-p", "5432",
"-D", "/var/lib/pgsql/data"], [/* 25 vars */]) = 0
brk(0) = 0xaed000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaaab000
uname({sys="Linux", node="bilbo.localdomain", ...}) = 0
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or
directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=108345, ...}) = 0
mmap(NULL, 108345, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2aaaaaaac000
close(3) = 0
open("/lib64/libpam.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200$ 42"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=46872, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaac7000
mmap(0x3234200000, 2139976, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3234200000
mprotect(0x323420a000, 2097152, PROT_NONE) = 0
mmap(0x323440a000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa000) = 0x323440a000
close(3) = 0
open("/lib64/libssl.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\"a1"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=302552, ...}) = 0
mmap(0x3231600000, 2395424, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3231600000
mprotect(0x3231643000, 2097152, PROT_NONE) = 0
mmap(0x3231843000, 24576, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x43000) = 0x3231843000
close(3) = 0
open("/lib64/libcrypto.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0d%12\0"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1326456, ...}) = 0
mmap(0x3231200000, 3434392, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3231200000
mprotect(0x3231325000, 2093056, PROT_NONE) = 0
mmap(0x3231524000, 126976, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x124000) = 0x3231524000
mmap(0x3231543000, 14232, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3231543000
close(3) = 0
open("/usr/lib64/libkrb5.so.3", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0ra02\0"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=555512, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaac8000
mmap(0x3230600000, 2648352, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3230600000
mprotect(0x3230683000, 2097152, PROT_NONE) = 0
mmap(0x3230883000, 16384, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x83000) = 0x3230883000
close(3) = 0
open("/usr/lib64/libz.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320\37\300"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=85928, ...}) = 0
mmap(0x3227c00000, 2178920, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3227c00000
mprotect(0x3227c14000, 2093056, PROT_NONE) = 0
mmap(0x3227e13000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x3227e13000
close(3) = 0
open("/usr/lib64/libreadline.so.5", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300:\1)"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=247160, ...}) = 0
mmap(0x3229000000, 2345024, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3229000000
mprotect(0x3229035000, 2093056, PROT_NONE) = 0
mmap(0x3229234000, 32768, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x34000) = 0x3229234000
mmap(0x322923c000, 2112, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x322923c000
close(3) = 0
open("/lib64/libtermcap.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\20@)2\0"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=15840, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaac9000
mmap(0x3229400000, 2108944, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3229400000
mprotect(0x3229403000, 2093056, PROT_NONE) = 0
mmap(0x3229602000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3229602000
close(3) = 0
open("/lib64/libcrypt.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\n\340"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=30920, ...}) = 0
mmap(0x3237e00000, 2306464, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3237e00000
mprotect(0x3237e05000, 2093056, PROT_NONE) = 0
mmap(0x3238004000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4000) = 0x3238004000
mmap(0x3238006000, 184736, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3238006000
close(3) = 0
open("/lib64/libresolv.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\3603\240"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=92728, ...}) = 0
mmap(0x322fa00000, 2181864, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x322fa00000
mprotect(0x322fa11000, 2097152, PROT_NONE) = 0
mmap(0x322fc11000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x322fc11000
mmap(0x322fc13000, 6888, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x322fc13000
close(3) = 0
open("/lib64/libnsl.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300(at)\240"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=109824, ...}) = 0
mmap(0x322ea00000, 2189680, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x322ea00000
mprotect(0x322ea14000, 2093056, PROT_NONE) = 0
mmap(0x322ec13000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x322ec13000
mmap(0x322ec15000, 6512, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x322ec15000
close(3) = 0
open("/lib64/libdl.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\17\200"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=23520, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaaca000
mmap(0x3227800000, 2109728, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3227800000
mprotect(0x3227803000, 2093056, PROT_NONE) = 0
mmap(0x3227a02000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3227a02000
close(3) = 0
open("/lib64/libm.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260?(at)\'"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=615136, ...}) = 0
mmap(0x3227400000, 2629848, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3227400000
mprotect(0x3227482000, 2093056, PROT_NONE) = 0
mmap(0x3227681000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x81000) = 0x3227681000
close(3) = 0
open("/lib64/libc.so.6", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0(at)\333\1\'"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1678512, ...}) = 0
mmap(0x3227000000, 3461304, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3227000000
mprotect(0x3227144000, 2097152, PROT_NONE) = 0
mmap(0x3227344000, 20480, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x144000) = 0x3227344000
mmap(0x3227349000, 16568, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3227349000
close(3) = 0
open("/lib64/libcom_err.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\f\340"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=10264, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaacb000
mmap(0x322fe00000, 2103320, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x322fe00000
mprotect(0x322fe02000, 2093056, PROT_NONE) = 0
mmap(0x3230001000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x3230001000
close(3) = 0
open("/lib64/libaudit.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300#\240"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=78504, ...}) = 0
mmap(0x3232a00000, 2171456, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3232a00000
mprotect(0x3232a12000, 2093056, PROT_NONE) = 0
mmap(0x3232c11000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x3232c11000
close(3) = 0
open("/usr/lib64/libgssapi_krb5.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20_\240"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=174040, ...}) = 0
mmap(0x3230a00000, 2267056, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3230a00000
mprotect(0x3230a29000, 2093056, PROT_NONE) = 0
mmap(0x3230c28000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x28000) = 0x3230c28000
close(3) = 0
open("/usr/lib64/libk5crypto.so.3", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0 T 02\0\0"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=153008, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaacc000
mmap(0x3230200000, 2246920, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3230200000
mprotect(0x3230223000, 2097152, PROT_NONE) = 0
mmap(0x3230423000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x23000) = 0x3230423000
close(3) = 0
open("/usr/lib64/libkrb5support.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300\33\340"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=32200, ...}) = 0
mmap(0x3230e00000, 2125104, PROT_READ|PROT_EXEC,
MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3230e00000
mprotect(0x3230e07000, 2093056, PROT_NONE) = 0
mmap(0x3231006000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x3231006000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaacd000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaace000
arch_prctl(ARCH_SET_FS, 0x2aaaaaace440) = 0
mprotect(0x3238004000, 4096, PROT_READ) = 0
mprotect(0x322fc11000, 4096, PROT_READ) = 0
mprotect(0x322ec13000, 4096, PROT_READ) = 0
mprotect(0x3227a02000, 4096, PROT_READ) = 0
mprotect(0x3227681000, 4096, PROT_READ) = 0
mprotect(0x3227344000, 16384, PROT_READ) = 0
mprotect(0x3226e19000, 4096, PROT_READ) = 0
munmap(0x2aaaaaaac000, 108345) = 0
brk(0) = 0xaed000
brk(0xb0e000) = 0xb0e000
getcwd("/var/lib/pgsql", 1024) = 15
stat("/usr/bin/postmaster", {st_mode=S_IFREG|0755, st_size=3068296,
...}) = 0
geteuid() = 26
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1
ENOENT (No such file or directory)
close(3) = 0
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1
ENOENT (No such file or directory)
close(3) = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=1696, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaaac000
read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1696
read(3, "", 4096) = 0
close(3) = 0
munmap(0x2aaaaaaac000, 4096) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=108345, ...}) = 0
mmap(NULL, 108345, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2aaaaaaac000
close(3) = 0
open("/lib64/libnss_files.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000!\0\0"...,
832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=53880, ...}) = 0
mmap(NULL, 2139432, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3,
0) = 0x2aaaaaacf000
mprotect(0x2aaaaaad9000, 2093056, PROT_NONE) = 0
mmap(0x2aaaaacd8000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x2aaaaacd8000
close(3) = 0
mprotect(0x2aaaaacd8000, 4096, PROT_READ) = 0
munmap(0x2aaaaaaac000, 108345) = 0
open("/etc/passwd", O_RDONLY) = 3
fcntl(3, F_GETFD) = 0
fcntl(3, F_SETFD, FD_CLOEXEC) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=2744, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaaac000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2744
close(3) = 0
munmap(0x2aaaaaaac000, 4096) = 0
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1
ENOENT (No such file or directory)
close(3) = 0
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1
ENOENT (No such file or directory)
close(3) = 0
open("/etc/group", O_RDONLY) = 3
fcntl(3, F_GETFD) = 0
fcntl(3, F_SETFD, FD_CLOEXEC) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=1096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaaaaac000
read(3, "root:x:0:root\nbin:x:1:root,bin,d"..., 4096) = 1096
close(3) = 0
munmap(0x2aaaaaaac000, 4096) = 0
getcwd("/var/lib/pgsql", 1024) = 15
chdir("/usr/bin") = 0
lstat("postmaster", {st_mode=S_IFLNK|0777, st_size=8, ...}) = 0
readlink("postmaster", "postgres", 1024) = 8
lstat("postgres", {st_mode=S_IFREG|0755, st_size=3068296, ...}) = 0
getcwd("/usr/bin", 1024) = 9
chdir("/var/lib/pgsql") = 0
open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=55565824, ...}) = 0
mmap(NULL, 55565824, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2aaaaacda000
close(3) = 0
geteuid() = 26
getuid() = 26
geteuid() = 26
getpid() = 4151
umask(077) = 022
getcwd("/var/lib/pgsql", 1024) = 15
stat("/usr/bin/postmaster", {st_mode=S_IFREG|0755, st_size=3068296,
...}) = 0
geteuid() = 26
open("/etc/passwd", O_RDONLY) = 3
fcntl(3, F_GETFD) = 0
fcntl(3, F_SETFD, FD_CLOEXEC) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=2744, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2744
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
open("/etc/group", O_RDONLY) = 3
fcntl(3, F_GETFD) = 0
fcntl(3, F_SETFD, FD_CLOEXEC) = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=1096, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "root:x:0:root\nbin:x:1:root,bin,d"..., 4096) = 1096
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
getcwd("/var/lib/pgsql", 1024) = 15
chdir("/usr/bin") = 0
lstat("postmaster", {st_mode=S_IFLNK|0777, st_size=8, ...}) = 0
readlink("postmaster", "postgres", 1024) = 8
lstat("postgres", {st_mode=S_IFREG|0755, st_size=3068296, ...}) = 0
getcwd("/usr/bin", 1024) = 9
chdir("/var/lib/pgsql") = 0
open("/proc/meminfo", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "MemTotal: 1024332 kB\nMemFre"..., 1024) = 725
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
stat("/var/lib/pgsql/data/postgresql.conf", {st_mode=S_IFREG|0600,
st_size=13694, ...}) = 0
open("/var/lib/pgsql/data/postgresql.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0600, st_size=13694, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "# -----------------------------\n"..., 8192) = 8192
read(3, "nt_min_messages = notice\t\t# Valu"..., 8192) = 5502
read(3, "", 4096) = 0
read(3, "", 8192) = 0
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
stat("/var/lib/pgsql/data", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
geteuid() = 26
open("/var/lib/pgsql/data/PG_VERSION", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0600, st_size=4, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "8.1\n", 4096) = 4
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
open("/var/lib/pgsql/data/global/pg_control", O_RDONLY) = 3
close(3) = 0
chdir("/var/lib/pgsql/data") = 0
open("postmaster.pid", O_RDWR|O_CREAT|O_EXCL, 0600) = -1 EEXIST (File
exists)
open("postmaster.pid", O_RDONLY) = 3
read(3, "2809\n/var/lib/pgsql/data\n 54320"..., 1123) = 45
close(3) = 0
getppid() = 4150
kill(2809, SIG_0) = -1 ESRCH (No such process)
shmctl(32768, IPC_STAT, 0x7fffd6144e00) = -1 EIDRM (Identifier removed)
open("/usr/share/locale/locale.alias", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=2528, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x2aaaae1d8000
read(3, "# Locale name alias data base.\n#"..., 4096) = 2528
read(3, "", 4096) = 0
close(3) = 0
munmap(0x2aaaae1d8000, 4096) = 0
open("/usr/share/locale/en_US.UTF-8/LC_MESSAGES/postgres.mo", O_RDONLY)
= -1 ENOENT (No such file or directory)
open("/usr/share/locale/en_US.utf8/LC_MESSAGES/postgres.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale/en_US/LC_MESSAGES/postgres.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale/en.UTF-8/LC_MESSAGES/postgres.mo", O_RDONLY) =
-1 ENOENT (No such file or directory)
open("/usr/share/locale/en.utf8/LC_MESSAGES/postgres.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
open("/usr/share/locale/en/LC_MESSAGES/postgres.mo", O_RDONLY) = -1
ENOENT (No such file or directory)
write(2, "FATAL: pre-existing shared memo"..., 263FATAL: pre-existing
shared memory block (key 5432001, ID 32768) is still in use
HINT: If you're sure there are no old server processes still running,
remove the shared memory block with the command "ipcclean", "ipcrm", or
just delete the file "postmaster.pid".
) = 263
exit_group(1) = ?
Process 4151 detached

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------