Postgres Pro
Downloads
Home   >   mailing lists

Thread: Getting Started

Getting Started

From
"Ian Waterman"
Date:
<div class="Section1"><p class="MsoNormal">Hi<p class="MsoNormal"> <p class="MsoNormal">I have just downloaded and
installedPostGreSQL 8.4. <p class="MsoNormal"> <p class="MsoNormal">When in pgAdmin III I cannot connect to the default
serverPostgreSQL 8.4 (localhost:5432) as it asks for a password.<p class="MsoNormal"> <p class="MsoNormal">I did not
adda password and cannot find what the default password is. Can you tell me what it is likely to be or how I can go
aboutresetting it?<p class="MsoNormal"> <p class="MsoNormal">Thank you<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">IanWaterman</span></b><br /><span
style="font-size:9.0pt;font-family:"Arial","sans-serif""><br/> Dene Business Solutions Ltd <br /> Tel 07966 190606 <br
/><br/> LinkedIn Profile http://www.linkedin.com/in/ianwaterman</span><p class="MsoNormal"> </div>

Re: Getting Started

From
Rainer Bauer
Date:
Hello Ian,

Friday, September 4, 2009, 12:15:10 PM, you wrote:

IW> I did not add a password and cannot find what the default password is. Can
IW> you tell me what it is likely to be or how I can go about resetting it?

Per FAQ:
<http://wiki.postgresql.org/wiki/FAQ#I_lost_the_database_password.__What_can_I_do_to_recover_it.3F>

Rainer

Re: Getting Started

From
Robert Doerfler
Date:
Hi,

> I did not add a password and cannot find what the default password is.
> Can you tell me what it is likely to be or how I can go about
> resetting it?

... root-password worked for me.

-- 
Greetings,
Robert

Re: Getting Started

From
Rainer Bauer
Date:
Hello Ian,

please CC the list.

Tuesday, September 8, 2009, 10:48:26 AM, you wrote:

IW> Thanks for your mail. However, its not the DB password but the Server
IW> password.

Yes. When you connect the the cluster (i.e. what you call "Server"),
pgAdminIII will automatically connect you to the database "postgres".

IW> When I try to connect to the localhost server it opens a password
IW> dialog box.

Did you restart the server (or reload the config?) after altering
pg_hba.conf?

Rainer

Re: Getting Started

From
"Ian Waterman"
Date:
Rainer

I can not connect to cluster/server.

I did restart the server, do I have to reload config file as well. How do I
do that?

Ian

-----Original Message-----
From: Rainer Bauer [mailto:usenet@munnin.com] 
Sent: 08 September 2009 21:44
To: pgadmin-support@postgresql.org
Cc: Ian Waterman
Subject: Re[2]: [pgadmin-support] Getting Started

Hello Ian,

please CC the list.

Tuesday, September 8, 2009, 10:48:26 AM, you wrote:

IW> Thanks for your mail. However, its not the DB password but the Server
IW> password.

Yes. When you connect the the cluster (i.e. what you call "Server"),
pgAdminIII will automatically connect you to the database "postgres".

IW> When I try to connect to the localhost server it opens a password
IW> dialog box.

Did you restart the server (or reload the config?) after altering
pg_hba.conf?

Rainer

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.409 / Virus Database: 270.13.86/2355 - Release Date: 09/08/09
20:45:00