Re: psql won't "createdb"

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Shayne Patton <sanitys3j(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql won't "createdb"
Date: 2004-11-01 02:12:17
Message-ID: 749D2D1D-2BAB-11D9-A718-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Oct 27, 2004, at 2:45 AM, Shayne Patton wrote:

> This is kinda weird. I'm using the pg8 beta4. When I install on Win
> 2k3 server, it lets me do everything I want to do through pgAdmin,
> however I prefer the console based psql. Problem is, when I connect
> to template1 (or anything else) I'm unable to "createdb". This
> happens when I attempt it w/out the wrapper as well (as in CREATE
> DATABASE).

From your description it sounds like you are trying connect via psql
and then use "createdb". But createdb is a command line program you
need to run at the command prompt (not the psql prompt). Apologies if
you know all this and I have just misunderstood your description of the
problem.

Post the error output from createdb if you still can't get it to work.

Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Iain 2004-11-01 02:22:31 pg_restore TODO - delay PK creation
Previous Message Iain 2004-11-01 01:45:46 Re: pg_restore error