Re: Strange behaviour: create database hangs (v 8.4.4) - Mailing list pgsql-admin

From Dale Gallagher
Subject Re: Strange behaviour: create database hangs (v 8.4.4)
Date
Msg-id AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com
Whole thread Raw
In response to Strange behaviour: create database hangs (v 8.4.4)  (Dale Gallagher <dale.gallagher@gmail.com>)
Responses Re: Strange behaviour: create database hangs (v 8.4.4)
List pgsql-admin
On 31 May 2010 12:50, Dale Gallagher <dale.gallagher@gmail.com> wrote:
> When running the command 'create database test' as user postgres from
> within psql, the command hangs indefinitely.

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.

pgsql-admin by date:

Previous
From: Dale Gallagher
Date:
Subject: Strange behaviour: create database hangs (v 8.4.4)
Next
From: Dale Gallagher
Date:
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)