Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting Started with PostgreSQL for Windows - Mailing list pgsql-novice

From Tomeh, Husam
Subject Re: Getting Started with PostgreSQL for Windows
Date
Msg-id CB0FB369FF86E248A884BCC002562BCB0227D9DF@pisgsna01sxch01.ana.firstamdata.com
Whole thread Raw
In response to Getting Started with PostgreSQL for Windows  ("James Schiiller" <jamesschiiller@gmail.com>)
List pgsql-novice
Tree view
If the password for the postgres database account is not working, then what you may want to do is
 
1. Shut down postgres server by going to windows services and stopping the postgres service.
2. Edit postgres pg_hba.conf and allow for "trust" authentication method instead of "md5" for your local host. (http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF)
3. Start up postgres service again
4. Login to postgres (psql -U postgres). It will not ask you for a password. If you want to enforce md5 again, make sure to alter the "postgres" password before updating the pg_hba.conf again.
 
If the password for the postgres windows account is the one that's not working, then you may need to reset it by following the steps specified:
 
--
  Husam
 
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of James Schiiller
Sent: Friday, September 08, 2006 9:39 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Getting Started with PostgreSQL for Windows

Hi,

 

I am just beginning postgreSQL.

I think I have installed PostgreSQL correctly.

There is some trouble getting started.

I also downloaded something called Pagila (Kool name).

 

Installation and getting started were started last week.

The getting started was never completed.

I come back today and PostgreSQL is not in Start | Programs anymore.

It was there last week.

Should I un- and reinstall the prog?

 

Some Getting Started with PostgreSQL for Windows PDF file by Charlton H. Lopez was downloaded and followed.

 

From the directions I started the command-line interface –

C:\Program Files\PostgreSQL\8.1\bin>psql –U postgres –h localhost

That instruction worked fine.

Then I tried the next inst.

Password for user postgres:

The prog. would not accept my password.

That auto gen password is very cryptic and the compliance character was not being recognized in the command-line interface.

I know you cannot see the alphanumbers as you type the password, however, I typed on a different line and the § character, ASCII character- 0167, would display as Character- 167- º . I don't know how many times I tried the password. I finally gave up.

Could someone try to help me out please?

 

 

--James

**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                                                                                                         FADLD Tag
**********************************************************************

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: replication/synchronisation
Next
From: toto titi
Date:
Subject: Problem with template1 database