From: Dale Gallagher <dale.gallagher@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)
Date: Mon, 31 May 2010 13:31:42 +0200
Message-ID: <AANLkTilsKP5ik1vMKHApdE4J7_CF7XLR4eqGTPN6sRPC@mail.gmail.com> (raw)
In-Reply-To: <AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com>
References: <AANLkTinrjvDOQAWcU3MYWPdEiEMR6QfuLydGfX-lMSOu@mail.gmail.com>
<AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com>
On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@gmail.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dale.gallagher@gmail.com
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)
In-Reply-To: <AANLkTilsKP5ik1vMKHApdE4J7_CF7XLR4eqGTPN6sRPC@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox