Re: Creating a database - Mailing list pgsql-general

From Ben Stringer
Subject Re: Creating a database
Date
Msg-id 3A626089.6B2968C1@magicrock.net
Whole thread Raw
In response to Creating a database  (Richard Francis Duggan <dugganr@student.cs.ucc.ie>)
List pgsql-general
Tom Lane wrote:
>
> Richard Francis Duggan <dugganr@student.cs.ucc.ie> writes:
> > I am trying to create a database and use the following command:
> > 'createdb <database-name>'
> > However I get the following error:
> > ERROR:  CREATE DATABASE: could not initialize database directory
> > createdb: database creation failed
>
> Hm.  That's not an especially easy error to get ... to get that far,
> you must have a running postmaster and a working template1 database.
> Furthermore you don't have a permissions problem, because it already
> was able to create the new subdirectory for the new database.  What's
> failing is the 'cp' command to copy files into that subdirectory from
> template1.  Most odd.

Richard - Is there room on the filesystem for your new DB? Are there any
quotas on usage of disk space in your environment?


>
> What platform are you on?  What's the name of the intended new database?
> Also, just reaching at straws, what's the PGDATA setting you are using
> (full pathname)?
>
>                         regards, tom lane

--
_____________________________________________________________
 Ben Stringer
 Burbong Consultants P/L   ACN 092 664 198
 ben@burbong.com    http://www.burbong.com   ph 0402 211 638

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Can't compare decimal columns???
Next
From: "Thomas T. Thai"
Date:
Subject: Re: stale portmaster processes