Ryfujk

Can a planet have a different gravitational pull depending on its location in orbit around its sun?

Why doesn't a const reference extend the life of a temporary object passed via a function?

Can the Produce Flame cantrip be used to grapple, or as an unarmed strike, in the right circumstances?

Why is my log file so massive? 22gb. I am running log backups

Why airport relocation isn't done gradually?

I see my dog run

Is every set a filtered colimit of finite sets?

Lied on resume at previous job

What does "enim et" mean?

Calculate Levenshtein distance between two strings in Python

Does bootstrapped regression allow for inference?

Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?

COUNT(*) or MAX(id) - which is faster?

If a centaur druid Wild Shapes into a Giant Elk, do their Charge features stack?

How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?

Need help identifying/translating a plaque in Tangier, Morocco

Typesetting a double Over Dot on top of a symbol

Is this food a bread or a loaf?

Re-submission of rejected manuscript without informing co-authors

Email Account under attack (really) - anything I can do?

What is the offset in a seaplane's hull?

Crop image to path created in TikZ?

How to move the player while also allowing forces to affect it

Are objects structures and/or vice versa?

I think I am unable to relock my postgres psql account

Cannot change password for user postgres in postgresqlpsql empty database before restorePSQL error with restarting postgres in SSLCannot access psql after installing postgrespsql editor setting on UbuntuPSQL 64bit driver errorPostgres roles best practice implementationpg_dump: [archiver (db)] connection to database failed: FATAL: Peer authentication failed for user “postgres”PostgreSQL password issue with psqlparallize postgres queries with bash and psql?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

When I was setting up postgresql on linux, I was following a tutorial that I think had me change the postgres account password and I did not know any better. Please forgive my ignorance.

When I type "psql postgres" it asks for a password and only one password works. I have tried following previous answers by implementing "sudo passwd --lock postgres" and "sudo -u postgres psql postgres" with "password postgres" and setting a new password (which does not work).

I am afraid to edit /etc/passwd and put * instead of the password because that comment has very few upvotes and I don't know what it will actually do.

Everything I try (even changing md5 to trust in pg_hba.conf), after I enter "sudo /etc/init.d/postgresql restart", psql postgres STILL REQUIRES a password and it only accepts the one password that works. Anything else returns 'psql: FATAL: password authentication failed'.

What can I do?

password ubuntu-18.04 psql

share|improve this question

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

When I was setting up postgresql on linux, I was following a tutorial that I think had me change the postgres account password and I did not know any better. Please forgive my ignorance.

When I type "psql postgres" it asks for a password and only one password works. I have tried following previous answers by implementing "sudo passwd --lock postgres" and "sudo -u postgres psql postgres" with "password postgres" and setting a new password (which does not work).

I am afraid to edit /etc/passwd and put * instead of the password because that comment has very few upvotes and I don't know what it will actually do.

Everything I try (even changing md5 to trust in pg_hba.conf), after I enter "sudo /etc/init.d/postgresql restart", psql postgres STILL REQUIRES a password and it only accepts the one password that works. Anything else returns 'psql: FATAL: password authentication failed'.

What can I do?

password ubuntu-18.04 psql

share|improve this question

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

When I was setting up postgresql on linux, I was following a tutorial that I think had me change the postgres account password and I did not know any better. Please forgive my ignorance.

When I type "psql postgres" it asks for a password and only one password works. I have tried following previous answers by implementing "sudo passwd --lock postgres" and "sudo -u postgres psql postgres" with "password postgres" and setting a new password (which does not work).

I am afraid to edit /etc/passwd and put * instead of the password because that comment has very few upvotes and I don't know what it will actually do.

Everything I try (even changing md5 to trust in pg_hba.conf), after I enter "sudo /etc/init.d/postgresql restart", psql postgres STILL REQUIRES a password and it only accepts the one password that works. Anything else returns 'psql: FATAL: password authentication failed'.

What can I do?

password ubuntu-18.04 psql

share|improve this question

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 15 mins ago

Humble-Data-22Humble-Data-22

1

New contributor

Humble-Data-22 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 15 mins ago

Humble-Data-22Humble-Data-22

1