Skip site navigation (1) Skip section navigation (2)

Re: Getting Started with PostgreSQL for Windows

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "James Schiiller" <jamesschiiller(at)gmail(dot)com>,pgsql-novice(at)postgresql(dot)org
Subject: Re: Getting Started with PostgreSQL for Windows
Date: 2006-09-14 21:02:46
Message-ID: CB0FB369FF86E248A884BCC002562BCB0227D9DF@pisgsna01sxch01.ana.firstamdata.com (view raw or flat)
Thread:
Lists: pgsql-novice
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:
       http://support.microsoft.com/default.aspx?scid=kb;en-us;298252
 
--
  Husam
  http://firstdba.googlepages.com <http://firstdba.googlepages.com> 
 
________________________________

From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of James Schiiller
Sent: Friday, September 08, 2006 9:39 PM
To: pgsql-novice(at)postgresql(dot)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
**********************************************************************

In response to

pgsql-novice by date

Next:From: toto titiDate: 2006-09-15 12:46:21
Subject: Problem with template1 database
Previous:From: Shane AmblerDate: 2006-09-14 20:23:19
Subject: Re: replication/synchronisation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group