The following bug has been logged online:
Bug reference: 5726
Logged by: Marcus
Email address: marcusbooster@mailinator.com
PostgreSQL version: 9.0.1
Operating system: Ubuntu 10.10
Description: Re: BUG #5723: Can not start postgres after install
Details:
On 10/25/2010 10:50 PM, Marcus wrote:
>> The following bug has been logged online:
>> Bug reference: 5723
>> Logged by: Marcus
>> Email address: marcusbooster@mailinator.com
>> PostgreSQL version: 9.0.1
>> Operating system: Ubuntu 10.10
>> Description: Can not start postgres after install
>> Details:
>> A user installing from source to a local directory.
>> Builds and installs fine, but panics when starting the server.
>> uname -a:
>> Linux myname 2.6.35-22-server #35-Ubuntu SMP Sat Oct 16 22:02:33 UTC
2010
>> x86_64 GNU/Linux
>> Tried on ext3 and ext4 filesystems.
> You mean you've tried putting $HOME/var/pgsql on both ext3 and ext4?
>> $HOME/opt/postgresql/bin/pg_ctl -D $HOME/var/pgsql/data start
>> server starting
>> LOG: database system was shut down at 2010-10-25 01:09:49 EDT
>> PANIC: could not open file "pg_xlog/000000010000000000000000" (log file
0, segment 0): Invalid argument
> What're the mount options used? The output of the "mount" command without
arguments would be useful.
Yes I did an initdb on $HOME/var/pgsql/data, that wasn't it.
After consulting the irc channel I was shown a workaround:
In postgresql.conf I had to explicitly set 'wal_sync_method = fsync' (which
was commented out), for whatever reason the default was causing the panic.
This is after a new Ubuntu 10.10 install,
mount:
/dev/mapper/myname-root on / type ext4 (rw,errors=remount-ro,commit=0)
proc on /proc type proc (rw,noexec,nosuid,nodev)
none on /sys type sysfs (rw,noexec,nosuid,nodev)
fusectl on /sys/fs/fuse/connections type fusectl (rw)
none on /sys/kernel/debug type debugfs (rw)
none on /sys/kernel/security type securityfs (rw)
none on /dev type devtmpfs (rw,mode=0755)
none on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=0620)
none on /dev/shm type tmpfs (rw,nosuid,nodev)
none on /var/run type tmpfs (rw,nosuid,mode=0755)
none on /var/lock type tmpfs (rw,noexec,nosuid,nodev)
/dev/sdb1 on /boot type ext2 (rw)
/home/myname/.Private on /home/myname type ecryptfs
(ecryptfs_sig=c1f838f60a32df99,ecryptfs_fnek_sig=aa11aefa959dd3c5,ecryptfs_c
ipher=aes,ecryptfs_key_bytes=16)