PostgreSQL: Important Database Administrator Commands Part I

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

Check version of PostgreSQL:

Create database using the script:
Change owner of the database:
Create a full copy of the database with structure and data:
Create database User using the script:
Change password of the User:
Upgrade existing User to Superuser:
Reload PostgreSQL configuration file:
Rotate PostgreSQL Log file:
Find Postgres server start time:
Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz