Обсуждение: Getting Started
<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>
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
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
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
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