Thread: Problem with initdb and ephemeral drives when rebooting

Problem with initdb and ephemeral drives when rebooting

From
Sébastien Lorion
Date:
Hello,

When doing the setup for a benchmark of pgsql on an High IO instance of Amazon, I got the following problem and was wondering if it is expected:

On FreeBSD 9.0 amd64, I installed PostgreSQL 9.1.5 on the boot drive (UFS), created a ZFS pool using the 2 SSD drives (tank/db), chown pgsql tank/db, ran initdb -D /tank/db as pgsql and all went well. When I rebooted the instance, I tried to recreate the db in the same way, but I get the following error:

FATAL: could not open file pg_xlog/000000010000000000000001

I searched a bit to find what could cause this, but did not find any useful information.

Sébastien