Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 218686336CF
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 31 May 2010 08:31:53 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 39949-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 31 May 2010 11:31:45 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com
 [74.125.82.46])
	by mail.postgresql.org (Postfix) with ESMTP id DC25463367E
	for <pgsql-admin@postgresql.org>; Mon, 31 May 2010 08:31:44 -0300 (ADT)
Received: by wwb28 with SMTP id 28so1185024wwb.19
	for <pgsql-admin@postgresql.org>; Mon, 31 May 2010 04:31:42 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:content-type;
	bh=wGLbk/nKw463NfUiQNAt2CW1aQi5guRVqbTpgbBYPDc=;
	b=v5DVk00Cs52kXwGDfowFuvf0tzZ4KGVC4LRGY2qsIfLn4NBKYRo0q19FWwuPAbZp7n
	9FWrphXKx712SaYjcgw8rHiZfr0ONfHqyuh8cftVcayu1E7vj/C9B6OtxhUuDKQIuxme
	vyC/UEdO03yufGH3guqomuRiVglWlVkMtsmaA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=GYvsMclXJNSjat/Mo7RJN7cew03jPs2wxPh6oJqakDKI9AjjmHyQGBSrh13sXoiEpB
	X8zWCrueS2heZtt0cS3wSJAMAH/nfICcdNaVX7DcdzH3tttX2jhEf5+W1XO4hhUjjUfp
	kVBrYeoO2TO+R0oCOkEDI4ybQRwLPJzM56RmM=
MIME-Version: 1.0
Received: by 10.216.184.197 with SMTP id s47mr4157696wem.63.1275305502635;
	Mon, 31 May 2010 04:31:42 -0700 (PDT)
Received: by 10.216.1.68 with HTTP; Mon, 31 May 2010 04:31:42 -0700 (PDT)
In-Reply-To: <AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com>
References: <AANLkTinrjvDOQAWcU3MYWPdEiEMR6QfuLydGfX-lMSOu@mail.gmail.com>
	<AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com>
Date: Mon, 31 May 2010 13:31:42 +0200
Message-ID: <AANLkTilsKP5ik1vMKHApdE4J7_CF7XLR4eqGTPN6sRPC@mail.gmail.com>
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)
From: Dale Gallagher <dale.gallagher@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8
X-Spam-Level: 
X-Archive-Number: 201005/300
X-Sequence-Number: 34773

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.