Re: [GENERAL] simple installation problem in windows system

2008-07-04 Thread Raymond O'Donnell
On 04/07/2008 15:36, Raymond O'Donnell wrote: Having said that, what you need to do is use the -U option to specify the Postgres user to use for the connection; if you don't, Postgres will try to authenticate you as the Windows account under which you're logged in. Look it up in the docs. ..

Re: [GENERAL] simple installation problem in windows system

2008-07-04 Thread Raymond O'Donnell
On 04/07/2008 15:03, Long Cui wrote: 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

Re: [GENERAL] simple installation problem in windows system

2008-07-04 Thread Long Cui
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 superadm

Re: [GENERAL] simple installation problem in windows system

2008-07-03 Thread Raymond O'Donnell
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 se

[GENERAL] simple installation problem in windows system

2008-07-03 Thread Long Cui
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?