If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

PostgreSQL Installation Help

Midnight Diamond · 2018-03-10 22:57:18

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

10-03-2018 10:57pm

#1

Midnight Diamond

Registered Users, Registered Users 2 Posts: 7 ✭

Join Date: August 2012

Posts: 6

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

0

Comments

#2 10-03-2018 11:00pm

mightyreds

Registered Users, Registered Users 2 Posts: 2,824 ✭✭✭

Join Date: December 2009

Posts: 2781

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

0
#3 10-03-2018 11:04pm

Midnight Diamond

Registered Users, Registered Users 2 Posts: 7 ✭

Join Date: August 2012

Posts: 6

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

0
#4 10-03-2018 11:10pm

mightyreds

Registered Users, Registered Users 2 Posts: 2,824 ✭✭✭

Join Date: December 2009

Posts: 2781

try in the terminal , sudo -u postgres psql

0
#5 10-03-2018 11:15pm

Midnight Diamond

Registered Users, Registered Users 2 Posts: 7 ✭

Join Date: August 2012

Posts: 6

That worked! Thank you!

0
#6 10-03-2018 11:17pm

mightyreds

Registered Users, Registered Users 2 Posts: 2,824 ✭✭✭

Join Date: December 2009

Posts: 2781

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

0
Advertisement