Important PostgreSQL DBA Commands -2

In this post, I am sharing few important and basic commands for Database Administrator of PostgreSQL.

Check the version of PostgreSQL:

SELECT version();
Create a database using the script:

CREATE DATABASE Database_Name WITH OWNER User_Name;
Change the owner of the database:

ALTER DATABASE Database_Name OWNER TO User_Name;
Create a full copy of the database with structure and data:

CREATE DATABASE NewDB WITH TEMPLATE OldDB;
Create a database User using the script:

CREATE USER Anvesh WITH password 'testPassword';
Change the password of the User:

ALTER USER postgres WITH PASSWORD 'temproot';
Upgrade the existing User to Superuser:

ALTER USER TestUser WITH SUPERUSER;
Reload the PostgreSQL configuration file:

SELECT  pg_reload_conf();
Rotate the PostgreSQL Log file:

SELECT pg_rotate_logfile();
Find the Postgres server start time:

SELECT pg_postmaster_start_time();