Postgres Pro
Downloads
Home   >   mailing lists

Problem with initdb and ephemeral drives when rebooting - Mailing list pgsql-general

From Sébastien Lorion
Subject Problem with initdb and ephemeral drives when rebooting
Date
Msg-id CAGa5y0PHBO5ywWcVk-=aW7ZMkiEB_hRqBU1OyFbAp9iznYPfSQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Views versus user-defined functions: formatting, comments, performance, etc.
Next
From: Willy-Bas Loos
Date:
Subject: [postgis-users] pg_dump -s should use add_geometrycolumn(...)