Re: simple installation problem in windows system - Mailing list pgsql-general

From Long Cui
Subject Re: simple installation problem in windows system
Date
Msg-id 23167a1b0807040703w1a7900bct762bc832e0c93fc0@mail.gmail.com
Whole thread Raw
In response to Re: simple installation problem in windows system  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: simple installation problem in windows system
List pgsql-general
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@iol.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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Cyril SCETBON
Date:
Subject: Re: redundants indexes can be created
Next
From: Gwyneth Morrison
Date:
Subject: Re: Delete from Join