How do I create a database if I can't connect to it?

From: "Paolo Victor" <paolovictor(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How do I create a database if I can't connect to it?
Date: 2007-07-27 14:28:58
Message-ID: f8c46d190707270728m6c17c7a9xb1918fa316a80f9c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

For a short description, I'll just show the sequence of commands I'm trying
to execute:

paolo(at)box> initdb -D /usr/local/pgsql/data/
paolo(at)box> postgres -D /usr/local/pgsql/data -i -p 5435
paolo(at)box> createdb foo -p 5435
createdb: could not connect to database foo: FATAL: database "foo" does not
exist

And

"postgres -D /usr/local/pgsql/data -i -p 5435"'s output:

/*
LOG: database system was shut down at 2007-07-27 11:25:27 BRT
LOG: checkpoint record is at 0/42C4B4
LOG: redo record is at 0/42C4B4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/593; next OID: 10820
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
FATAL: database "foo" does not exist
*/

Now, am I doing something terribly wrong/noobish, or Postgres is freaking
out because I want to create a database that does not exist?

Thanks in advance,
~Paolo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2007-07-27 15:19:52 Re: How do I create a database if I can't connect to it?
Previous Message Merlin Moncure 2007-07-27 13:59:03 Re: upgrade to 8.2.? or implement Slony, which first?