Skip site navigation (1) Skip section navigation (2)

BUG #5726: Re: BUG #5723: Can not start postgres after install

From: "Marcus" <marcusbooster(at)mailinator(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5726: Re: BUG #5723: Can not start postgres after install
Date: 2010-10-26 01:43:06
Message-ID: 201010260143.o9Q1h6ZY040192@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5726
Logged by:          Marcus
Email address:      marcusbooster(at)mailinator(dot)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(at)mailinator(dot)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)

pgsql-bugs by date

Next:From: Robert HaasDate: 2010-10-26 02:37:31
Subject: Re: BUG #5725: server couldn't start when installing on liveCD
Previous:From: Craig RingerDate: 2010-10-25 23:54:30
Subject: Re: BUG #5723: Can not start postgres after install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group