psql won't "createdb"

[Shayne Patton]

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).

I've uninstalled/reinstalled several times, making sure to remove all
the pg srvcs, users, files, and registry entries. I've re-downloaded
the .msi on the chance it was corrupted (twice).

Anyone have any ideas??

Universally,
Shayne

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Vishal Kashyap @ [Sai Hertz And Control Systems]]

Do you have sufficient space and is your file system NTFS

[John DeSoi]

Post by Shayne Patton
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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)