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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform