Before you begin
Make sure the database you are using meet the requirements described in
Compatible databases and the following ones.
Procedure
-
Log in to an existing database as a database superuser or a user who has
CREATEROLE and CREATEDB
privileges.
psql.exe -h <HOST-NAME> -W -U <USER_NAME> -p <PORT> -d <DATABASE_NAME>
-
Create a user MM and a database
MM with the following privileges.
-- Delete previous user if needed
DROP USER "MM";
-- If the user cannot be dropped due to any ownership issues, you need to reassign those objects to another user
REASSIGN OWNED BY "MM" TO <OTHER-USER-NAME>;
-- Or drop those objects
DROP OWNED BY "MM";
-- Create a database MM with UTF8 encoding. You may use a different tablespace.
CREATE DATABASE MM;
-- Create a user MM with LOGIN privilege
CREATE ROLE MM WITH LOGIN PASSWORD 'MM123!';
-- Grant privileges on MM database to MM user
GRANT ALL PRIVILEGES ON DATABASE MM TO MM;
-
For maintenance reasons, PostgreSQL database indexes can be rebuilt as
follows.
For more information on reindexdb
, refer to the PostgreSQL
documentation.