Re: simple installation problem in windows system

------=_Part_10638_5198459.1215180183017
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@[EMAIL PROTECTED]
> 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@[EMAIL PROTECTED]
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>

------=_Part_10638_5198459.1215180183017
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Many thanks<br>Now I enter c:\Program Files\PostgreSQL\8.3\bin\createdb
mydb;<br>PG asks me password<br>Is the password as superadmin&#39;s
password or postgre&#39;s password what I set when postgresql installed in
windows<br>
I try both, but does not work&quot; user administrator password
fail&quot;<br>so How to log on as superadmin.<br><br>long<br><br><br><div
class="gmail_quote">On Thu, Jul 3, 2008 at 11:58 PM, Raymond O&#39;Donnell
&lt;<a href="mailto:rod@[EMAIL PROTECTED]
">rod@[EMAIL PROTECTED]
>&gt; wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">On 03/07/2008 14:40, Long Cui wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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 &quot;create
database mydb;&quot; it successed, however when &quot;createdb mydb;&quot;
told me syntax error. Dose the Path set wrong or I need to set other
viarables?<br>

</blockquote>
<br></div>
It sounds as if you&#39;re issuing the commands from within psql - hence
the standard SQL &quot;create database....&quot; works, but
&quot;createdb..&quot; won&#39;t.<br>
<br>
createdb is just a wrapper program that sends a &quot;create
database...&quot; command to the server, so you need to run it from the
Windows command-line.<br>
<br>
Ray.<br>
<br>
------------------------------------------------------------------<br><font
color="#888888">
Raymond O&#39;Donnell, Director of Music, Galway Cathedral, Ireland<br>
<a href="mailto:rod@[EMAIL PROTECTED]
" target="_blank">rod@[EMAIL PROTECTED]
><br>
Galway Cathedral Recitals: <a
href="http://www.galwaycathedral.org/recitals"
target="_blank">http://www.galwaycathedral.org/recitals</a><br>
------------------------------------------------------------------<br>
</font></blockquote></div><br>

------=_Part_10638_5198459.1215180183017--