Обсуждение: BUG #5723: Can not start postgres after install

Поиск
Список
Период
Сортировка

BUG #5723: Can not start postgres after install

От
"Marcus"
Дата:
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.

./configure --prefix=$HOME/opt/postgres
... (good)
./make && make install
... (good)

$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
LOG:  startup process (PID 5010) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure

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

От
John R Pierce
Дата:
On 10/25/10 7:50 AM, 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.
>
> ./configure --prefix=$HOME/opt/postgres
> ... (good)
> ./make&&  make install
> ... (good)
>
> $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
> LOG:  startup process (PID 5010) was terminated by signal 6: Aborted
> LOG:  aborting startup due to startup process failure
>

did you run initdb ?

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

От
Craig Ringer
Дата:
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.

--
Craig Ringer