Обсуждение: Getting Started
Hi
I have just downloaded and installed PostGreSQL 8.4.
When in pgAdmin III I cannot connect to the default server PostgreSQL 8.4 (localhost:5432) as it asks for a password.
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?
Thank you
Ian Waterman
Dene Business Solutions Ltd
Tel 07966 190606
LinkedIn Profile http://www.linkedin.com/in/ianwaterman
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