I'll keep it simple: Postgres hates me, see below. Thanks.
# rpm -q postgresql; uname -a
postgresql-8.4.5-1.fc13.x86_64
Linux hostname 2.6.36-1.fc13.x86_64 #1 SMP Tue Nov 2 23:39:09 EDT 2010 x86_64
x86_64 x86_64 GNU/Linux
# service postgresql start
Starting postgresql service: [ OK ]
# ps aux |grep post
root 14926 0.0 0.0 103204 800 pts/7 S+ 14:56 0:00 grep post
# tail -n3 /var/lib/pgsql/data/pg_log/postgresql-Wed.log
PANIC: could not open file "pg_xlog/000000010000000100000023" (log file 1,
segment 35): Invalid argument
LOG: startup process (PID 14922) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
# su -l postgres -c "pg_resetxlog -f /var/lib/pgsql/data"
Transaction log reset
# service postgresql start
Starting postgresql service: [ OK ]
# ps aux |grep post
root 14926 0.0 0.0 103204 800 pts/7 S+ 14:56 0:00 grep post
# tail -n3 /var/lib/pgsql/data/pg_log/postgresql-Wed.log
PANIC: could not open file "pg_xlog/000000010000000100000024" (log file 1,
segment 36): Invalid argument
LOG: startup process (PID 16536) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
# tail -n4 /var/log/messages
Nov 3 15:43:08 hq2 abrt[16537]: saved core dump of pid 16536
(/usr/bin/postgres) to /var/spool/abrt/ccpp-1288813387-16536.new/coredump
(30986240 bytes)
Nov 3 15:43:08 hq2 abrtd: Directory 'ccpp-1288813387-16536' creation detected
Nov 3 15:43:08 hq2 abrtd: Crash is in database already (dup of
/var/spool/abrt/ccpp-1288794001-5932)
Nov 3 15:43:08 hq2 abrtd: Deleting crash ccpp-1288813387-16536 (dup of
ccpp-1288794001-5932), sending dbus signal