From: Henry Kon <henry.kon@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: initial windows install : can't createuser or createdb - what user / pass to use?
Date: Fri, 31 Dec 2004 04:59:47 -0500
Message-ID: <ff8d7aa504123101595df38450@mail.gmail.com> (raw)
In-Reply-To: <ff8d7aa50412310148f043e8f@mail.gmail.com>
References: <ff8d7aa50412310148f043e8f@mail.gmail.com>
the initial admin user comes from the service installation screen.
from this web site I just found.
http://pginstaller.projects.postgresql.org/
HK
On Fri, 31 Dec 2004 04:48:25 -0500, Henry Kon <henry.kon@gmail.com> wrote:
> I've just installed postgresql on windows version 8.0.0 rc-2 and am
> trying to do very first things like createuser or createdb but all I
> get is messages like:
>
> createuser: could not connect to database template1: FATAL: password
> authentication failed for user "xxxxx"
>
> How do I add users or do other admin stuff at startup? Is there a
> default administrative user and password that I should know about?
>
> From the example below, lbaigell is the user I log into windows with -
> so Postgres knows about that user name by itself - the password I'm
> trying to use is the windows password - a 6 alpha character string.
>
> Thank you
> Henry
>
> interaction below:
>
> C:\Program Files\PostgreSQL\8.0.0-rc2\bin>createuser
> Enter name of user to add: mkon
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> Password:
> createuser: could not connect to database template1: FATAL: password
> authentication failed for user "lbaigell"
>
> C:\Program Files\PostgreSQL\8.0.0-rc2\bin>c
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: henry.kon@gmail.com
Subject: Re: initial windows install : can't createuser or createdb - what user / pass to use?
In-Reply-To: <ff8d7aa504123101595df38450@mail.gmail.com>
References: <ff8d7aa50412310148f043e8f@mail.gmail.com> <ff8d7aa504123101595df38450@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox