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:10:46
Message-ID: AANLkTimtPtGKaa7ViHc2KT_Gk4H6dTU4pFn8JKiQDqEE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 31 May 2010 12:50, Dale Gallagher <dale(dot)gallagher(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dale Gallagher 2010-05-31 11:31:42 Re: Strange behaviour: create database hangs (v 8.4.4)
Previous Message Dale Gallagher 2010-05-31 10:50:14 Strange behaviour: create database hangs (v 8.4.4)