pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
initial windows install : can't createuser or createdb - what user / pass to use?
2+ messages / 1 participants
[nested] [flat]

* initial windows install : can't createuser or createdb - what user / pass to use?
@ 2004-12-31 09:48 Henry Kon <henry.kon@gmail.com>
  2004-12-31 09:59 ` Re: initial windows install : can't createuser or createdb - what user / pass to use? Henry Kon <henry.kon@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Henry Kon @ 2004-12-31 09:48 UTC (permalink / raw)
  To: pgsql-admin

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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: initial windows install : can't createuser or createdb - what user / pass to use?
  2004-12-31 09:48 initial windows install : can't createuser or createdb - what user / pass to use? Henry Kon <henry.kon@gmail.com>
@ 2004-12-31 09:59 ` Henry Kon <henry.kon@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Henry Kon @ 2004-12-31 09:59 UTC (permalink / raw)
  To: pgsql-admin

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
>



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-31 09:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-31 09:48 initial windows install : can't createuser or createdb - what user / pass to use? Henry Kon <henry.kon@gmail.com>
2004-12-31 09:59 ` Henry Kon <henry.kon@gmail.com>

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