Обсуждение: psql won't "createdb"

Поиск
Список
Период
Сортировка

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

Re: psql won't "createdb"

От
"Vishal Kashyap @ [Sai Hertz And Control Systems]"
Дата:
Do you have sufficient space and is your file system NTFS
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com

Re: psql won't "createdb"

От
John DeSoi
Дата:
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