Skip to main content

Grant a postgres user password and create database option

 Grant a postgres user password and create database option


To give a postgres user a new password, run this command in postgres CLI:

ALTER USER user_name WITH PASSWORD 'new_password';


To grant the postgres user create database permission, run this command in postgres CLI:

ALTER USER username CREATEDB;


Comments

Post a Comment

Popular posts from this blog

How to Uninstall an Odoo Module via Command Line (CLI)

How to Uninstall an Odoo Module via Command Line (Odoo Shell Guide) Uninstalling an Odoo module from the user interface is straightforward — until it isn’t. If your instance is broken, the UI won’t load, or a custom module causes errors, the safest way to proceed is to uninstall the module using the Odoo command line (CLI) . In this guide, you'll learn how to uninstall an Odoo module using the Odoo shell , when to use it, and how to avoid common mistakes that can break your database. When Should You Use the Command Line? The CLI method is especially useful in the following situations: The Odoo web interface is not accessible A module causes server startup errors You are working on a remote or headless server You are debugging or developing custom modules You need more control over the uninstall process Step-by-Step: Uninstall a Module Using Odoo Shell 1. Start the Odoo Shell Navigate to your Odoo installation directory and run: ./odoo-bin ...
Post a Comment
Read more

Use CS50 Library in Your Local Machine Offline (C Language Setup)

Use CS50 Library in Your Local Machine Offline (C Language Setup) Make Your PC Ready for C Programming with CS50 In this guide, you will learn how to prepare your computer to run C programs locally and use the CS50 library offline. The following videos will walk you through all required tools and setup steps. Step 1: Install Visual Studio Code This video explains how to download and install Visual Studio Code on Windows 10. Step 2: Install C/C++ Compiler (GCC, G++, GDB) Learn how to install the C/C++ toolchain using MinGW-w64 and MSYS2. Step 3: Configure VS Code for C/C++ This step shows how to properly configure Visual Studio Code for C and C++ programming. How to Use CS50 Library Offline After completing the setup above, follow these steps to use the CS50 library locally without internet access: Download the CS50 library from GitHub Releases: https://github.com/cs50/libcs50/rel...
Post a Comment
Read more