Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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();

Comments

Popular posts from this blog

PostgreSQL DOMAIN Data Type -2

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Postgres Database Patch

PostgreSQL Enterprise Manager - PEM Monitoring Tools