How can I change a PostgreSQL user password?

Sumit Kumar Sharan

Jun 7, 2023

sudo -u user_name psql db_name

ALTER USER user_name WITH PASSWORD 'new_password';

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Written by Sumit Kumar Sharan

No responses yet

Write a response

What are your thoughts?

Also publish to my profile

Recommended from Medium

Another way to Optimize MySQL Queries from 190 Seconds to 1 Second for Tens of Millions of Records

In

Towards Dev

by

Mike Chan

Another way to Optimize MySQL Queries from 190 Seconds to 1 Second for Tens of Millions of Records

Another solution to handle the performance issue in 1 second without the need to change the business nature of the SQL

Oct 21, 2024

Postgres Security 101: Logging and Auditing (3/8)

Oz

Postgres Security 101: Logging and Auditing (3/8)

Logging and auditing are critical components of any robust security strategy for PostgreSQL. Proper logging enables database administrators…

Oct 4, 2024

Lists

Staff picks

827 stories1648 saves

Stories to Help You Level-Up at Work

19 stories948 saves

Self-Improvement 101

20 stories3355 saves

Productivity 101

20 stories2819 saves

How to Migrate from Oracle to PostgreSQL Using Ora2Pg: Step-by-Step Tutorial

Sheikh Wasiu Al Hasib

How to Migrate from Oracle to PostgreSQL Using Ora2Pg: Step-by-Step Tutorial

Ora2Pg is an open-source tool designed to migrate Oracle databases to PostgreSQL. It automates the process of converting Oracle database…

Nov 20, 2024

Middleware for PostgreSQL: Is It Feasible or a Maintenance Nightmare?

Mr.PlanB

Middleware for PostgreSQL: Is It Feasible or a Maintenance Nightmare?

PostgreSQL, one of the most versatile and powerful relational databases, offers a wide range of features for managing data. Its…

Jan 4

Cron Jobs with PostgreSQL and the pg_cron extension

Tihomir Manushev

Cron Jobs with PostgreSQL and the pg_cron extension

plus Docker and Ubuntu

Mar 5

PostgreSQL Scripts for Effective Database Management and Optimization

Azik 🇺🇿

PostgreSQL Scripts for Effective Database Management and Optimization

In this post, we will explore various PostgreSQL scripts designed to help monitor database performance, identify issues, and optimize…

Nov 1, 2024

See more recommendations

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams