In this blog, we are going to discuss how to install PostgreSQL, verify the installation, start the database server, create database, create basic table, insert data into the table, see list of databases, see list of tables, see list of users, login as particular user, run sql query on table etc. Basically this blog will […]
You’ll be reading:First stop PostgreSQL serviceStoping PostgreSQL on Linux:Stopping PostgreSQL on macOS:Stopping PostgreSQL on windows:Make Changes to pg_hbe.conf fileStarting the PostgreSQL ServiceStarting PostgreSQL on Linux:Starting PostgreSQL on macOS:Starting PostgreSQL On windows To List all users in PostgreSQLChange password for any usernameCreate new user and set password If you have forgotten PostgreSQL passwords like me, this
