Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

PostgreSQL Installation Help

  • 10-03-2018 10:57PM
    #1
    Midnight Diamond
    Registered Users, Registered Users 2 Posts: 7 ✭


    Hi,

    I've recently installed PostgreSQL and have it launching at start up on my machine. It's looking for a password to login although I never set one up. I've tried to reset the password through the command line but it's still asking for a password there. Can anyone shed some light on this for me?

    Thanks in advance


Comments

  • #2
    mightyreds
    Registered Users, Registered Users 2 Posts: 2,937 ✭✭✭mightyreds


    If using linux the password will be blank , if windows you should have set it on install deafult user is usually postgres


  • #3
    Midnight Diamond
    Registered Users, Registered Users 2 Posts: 7 ✭Midnight Diamond


    I'm using a Mac and I've tried a blank password in terminal but I'm getting 'psql: fe_sendauth: no password supplied' back. It doesn't let me login on startup either with a blank password


  • #4
    mightyreds
    Registered Users, Registered Users 2 Posts: 2,937 ✭✭✭mightyreds


    try in the terminal , sudo -u postgres psql


  • #5
    Midnight Diamond
    Registered Users, Registered Users 2 Posts: 7 ✭Midnight Diamond


    That worked! Thank you!


  • #6
    mightyreds
    Registered Users, Registered Users 2 Posts: 2,937 ✭✭✭mightyreds


    you can now set a password too with ALTER USER postgres WITH PASSWORD 'new_password';


  • Advertisement
Advertisement