DEV Community

Zaw Htut Win
Zaw Htut Win

Posted on

How to update postgres (default user) password and rails+ruby compatibility table

First login into postgres server

$ sudo -u postgres psql
Enter fullscreen mode Exit fullscreen mode

Change the password

ALTER USER postgres WITH ENCRYPTED PASSWORD 'postgres';
Enter fullscreen mode Exit fullscreen mode

Then go and change the conf

$sudo nano /etc/postgresql/9.5/main/pg_hba.conf
Enter fullscreen mode Exit fullscreen mode

Change from peer to md5
Instead of this

local   postgres   postgres   peer
Enter fullscreen mode Exit fullscreen mode

Change to this

local   postgres   postgres   md5
Enter fullscreen mode Exit fullscreen mode

Then restart server

$ sudo service postgresql restart
Enter fullscreen mode Exit fullscreen mode

Credits:
https://stackoverflow.com/a/69778580/379779

https://www.fastruby.io/blog/ruby/rails/versions/compatibility-table.html

Top comments (0)

Read next

westernal profile image

When is the best time to post on Dev?

Ali Navidi -

philip_zhang_854092d88473 profile image

Decoding URL Encoding: Unveiling the Mystery Behind % Symbols

Philip -

philip_zhang_854092d88473 profile image

Top 5 Enterprise-Grade API Documentation Tools and Software for Seamless Integration

Philip -

philip_zhang_854092d88473 profile image

EchoAPI for VS Code: A Lightweight Alternative to Postman & Thunder Client

Philip -