TurnKey Linux Virtual Appliance Library

can't login to PostgresSQL on EC2

spam_ml's picture


after i opened all Conections (5432) i still can't log in to the PG-Server on EC2.

not with the local phpPGAdmin and not with PGadmin

it always comes the Message "Password authentification failed for user "postgres"

i didn't changed any password, the applicance is installed fresh.

Is there any other Password i should know?

Thanks in advance


Alon Swartz's picture

postgres password set randomly on ec2

Because EC2 instances are publically accessible on the internet, the postgres (and root) passwords are set randomly on first boot for security reasons. This is also true for mysql where relevant.

You can find the password in the ec2 console output, and in /root/README. This will be changed in the upcoming release to be more user friendly, details to follow...

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)