Re: simple installation problem in windows system

Many thanks
Now I enter c:\Program Files\PostgreSQL\8.3\bin\createdb mydb;
PG asks me password
Is the password as superadmin's password or postgre's password what I set
when postgresql installed in windows
I try both, but does not work" user administrator password fail"
so How to log on as superadmin.

long

On Thu, Jul 3, 2008 at 11:58 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> On 03/07/2008 14:40, Long Cui wrote:
>
>> I install PostgreSQL 8.3.3 in Windows XP, and set Path environment
>> viarable to C:\Program Files\PostgreSQL\8.3\bin, when I enter "create
>> database mydb;" it successed, however when "createdb mydb;" told me syntax
>> error. Dose the Path set wrong or I need to set other viarables?
>>
>
> It sounds as if you're issuing the commands from within psql - hence the
> standard SQL "create database...." works, but "createdb.." won't.
>
> createdb is just a wrapper program that sends a "create database..."
> command to the server, so you need to run it from the Windows command-line.
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>