Re: Strange behaviour: create database hangs (v 8.4.4)

From: Dale Gallagher <dale(dot)gallagher(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)
Date: 2010-05-31 11:31:42
Message-ID: AANLkTilsKP5ik1vMKHApdE4J7_CF7XLR4eqGTPN6sRPC@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 31 May 2010 13:10, Dale Gallagher <dale(dot)gallagher(at)gmail(dot)com> wrote:
> I am now using strace on postgres startup and watching the filesystem
> during the creation of the database. So far, it seems that files in
> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
> 7 minutes and 92 files have been created. The command has not
> completed within psql....
>
> Could this be a filesystem corruption issue? The host is using ext4.

The command finally completed. It took a VERY long time. Something is
wrong, but I have no clue what.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dimitri Fontaine 2010-05-31 13:43:45 Re: Advice on HA/LB setup for small installation
Previous Message Dale Gallagher 2010-05-31 11:10:46 Re: Strange behaviour: create database hangs (v 8.4.4)