Re: Creating a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Francis Duggan <dugganr(at)student(dot)cs(dot)ucc(dot)ie>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating a database
Date: 2001-01-15 01:27:39
Message-ID: 15853.979522059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Francis Duggan <dugganr(at)student(dot)cs(dot)ucc(dot)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.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Stringer 2001-01-15 02:29:29 Re: Creating a database
Previous Message The Hermit Hacker 2001-01-15 01:11:31 Re: Does PostgreSQL support Dynamic SQL?