Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B417E6332DD for ; Tue, 1 Jun 2010 08:17:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 75659-08 for ; Tue, 1 Jun 2010 11:17:05 +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 7BA7B633217 for ; Tue, 1 Jun 2010 08:17:06 -0300 (ADT) Received: by wwb28 with SMTP id 28so1883593wwb.19 for ; Tue, 01 Jun 2010 04:17:04 -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 :content-transfer-encoding; bh=IhWFWjv81Roc3fkE2BGMI/27E/VIFX1O1GsBeWtRo3E=; b=ncUr4Q2HH68a3BtV+CQoLFgTlNq+NAtP/6xfPyEOBc/OXsHsWUnU0X/Z5c8S3H+hEv Ye44u7VKO8hvbge8t2psem+BdTSnPTWV7Vvmw7XQc0Ukc1zIXHl88NsT+9DYUVHz9cJH aYWsMP2VkdHQuA9EKjUJQv8I0a8KqI1xpxLSE= 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:content-transfer-encoding; b=gUX1pqmpRGzoRwA32aEOg0GtslY5D7wQhOmeAgJd7N4qBzCOY3BmM0Pmnd1n04w365 1BJyXWrHOPRV1enY1S8ndfmmHGnNpNHjVIWIElCqHNpZFCTodQMPggd7MCocQvAncwmR 77jm95JDHypCAGSR+2eQq1O3LE92IwoITgRao= MIME-Version: 1.0 Received: by 10.216.188.146 with SMTP id a18mr5181973wen.22.1275391023711; Tue, 01 Jun 2010 04:17:03 -0700 (PDT) Received: by 10.216.1.68 with HTTP; Tue, 1 Jun 2010 04:17:03 -0700 (PDT) In-Reply-To: <14831.1275325174@sss.pgh.pa.us> References: <14831.1275325174@sss.pgh.pa.us> Date: Tue, 1 Jun 2010 13:17:03 +0200 Message-ID: Subject: Re: Strange behaviour: create database hangs (v 8.4.4) From: Dale Gallagher To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201006/5 X-Sequence-Number: 34783 On 31 May 2010 18:59, Tom Lane wrote: > Seems like you must have a kernel/filesystem issue, but I don't know > what either. =A0CREATE DATABASE just copies the contents of template1 > using some absolutely straightforward code (look into src/port/copydir.c) > so it's entirely filesystem-limited. Thanks Tom. I've confirmed that it's not related to PostgreSQL, as installing this version on another system has zero issues. I've posted the issue to a Slackware specific forum: http://www.linuxquestions.org/questions/slackware-14/slackware-13-sluggish-= system-possibly-filesystem-811442/