Re: createdb after initdb

On Fri, 27 Jul 2001 20:45:45 +0100, Danno <danny@intuitivemedia.com> wrote:
> I'm trying to get Postgres up and running.  I've followed the
> instructions in the online documentation and started the postmaster.
>
> I can add users, so I gave myself the privieges to add users and
> create databases, but I get this error when I attempt to create a new
> database.
>
> $ ./createdb test
> ERROR:  CREATE DATABASE: Could not initialize database directory. Delete
> failed as well
> createdb: database creation failed
>

Make sure it is working on the correct dirctory:

createdb -D /usr/local/pgsql/data/ test

or try creating the new database from psql:

psql template1
create database test;