Problem with initdb and ephemeral drives when rebooting

Поиск
Список
Период
Сортировка
От Sébastien Lorion
Тема Problem with initdb and ephemeral drives when rebooting
Дата
Msg-id CAGa5y0PHBO5ywWcVk-=aW7ZMkiEB_hRqBU1OyFbAp9iznYPfSQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Views versus user-defined functions: formatting, comments, performance, etc.
Следующее
От: Willy-Bas Loos
Дата:
Сообщение: [postgis-users] pg_dump -s should use add_geometrycolumn(...)