Re: Creating a database

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