Re: Install as program - Mailing list pgsql-hackers-win32

From Merlin Moncure
Subject Re: Install as program
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3415C2827@Herge.rcsinc.local
Whole thread Raw
In response to Install as program  ("Brian J. Erickson" <ericksbr@infocon-inc.com>)
List pgsql-hackers-win32
> When PostgreSQL is installed as a program,
> the install does not ask for a user name or password.

The .msi installer prompts you for the root account name and password
(usually postgres).  Logging onto the database is possible without a
password if the terminal you are logging in from (127.0.0.1) uses the
'trust' authentication method in pg_hba.conf.  Open this file and read
it over until you understand it completely.

> How does someone connect to the Database Server,
> without a user name or password,
> especially, if the database server has no accounts?


The database is always installed with an account. I'd suggest going
through the install process once again...don't confuse the database root
account with the NT user account the database runs under.

Merlin

pgsql-hackers-win32 by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Install as program
Next
From: "Knut P. Lehre"
Date:
Subject: errors in postgresql-8.0.3.zip from 2005-05-12?