Step-by-step | PostgreSQL 11 Admin Guide on CentOS Gnu/Linux

February 5, 2019 | By the+gnu+linux+evangelist.

CentOS PostgreSQL 11 Admin

Hi! This Article Resume the Start-Up Procedure Following the Installation for Getting-Started with PostgreSQL 11 CLI and GUI Administration in Fedora GNU/Linux.

And this CentOS PostgreSQL 11 Admin Guide let you make the First, Steps Easily with PostgreSQL 11 Database.

Moreover, the Procedure Described is Expressly Resumed in Few Words to Give Focus to the Essential Commands Needed to the Initial SetUp.

Finally, the post include also information on Installing PostgreSQL 11 on CentOS and PostgreSQL 11 Online Docs.

PostgreSQL 11 Admin Guide CentOS - Featured

How to Install PostgreSQL 11 Server on CentOS

Here PostgreSQL 11 CentOS Install

How to Install PostgreSQL 11 Server on CentOS GNU/Linux

First, Make Needed Directories.

Copy

sudo mkdir -p /home/postgres/data

Set postgres as Owner with:

Copy

sudo chown -R postgres:postgres /home/postgres

Set the postgres User Password
Copy
```
sudo passwd postgres
```
Give a Password to the postgres User Account.
If Got “User is Not in Sudoers file” then see: How to Enable sudo
Login as the postgres User
Copy
```
su postgres
```
Change to the Home Directory:
Copy
```
cd 
```

And Setup User’s Path.

Copy

/necho "export PATH=$PATH:/usr/lib/postgresql/10/bin" 
> /var/lib/postgresql/.bashrc

Load the New PATH with:

Copy

bash

Then Setup First, PostgreSQL DB Cluster.
Copy
```
initdb -D /home/postgres/data
```
Next ReStart PostgreSQL Server.
Copy
```
service postgresql restart
```
Create a PostgreSQL test Database.
Copy
```
createdb test
```
Access PostgreSQL Database CLI
First, Set the postgres Database’s Password:
Copy
```
psql template1
```
And then on the template1# Prompt:
Copy
```
password postgres
```
And Exit with:
Copy
```
\q
```
Then to Access test Database:
Copy
```
psql test
```

Then to Create a Table.

Copy

CREATE TABLE account(/nuser_id serial PRIMARY KEY,/nusername VARCHAR (50) UNIQUE NOT NULL 
);

Next to List Tables.
Copy
```
\dt
```
Again Listing Databases.
Copy
```
\l 
```
‘q’ to Quit.
For More See PostgreSQL 11 Online Documentation
Finally, to Delete test Database.
Copy
```
dropdb test
```
For PostgreSQL 11 GUI Administration Install PgAdmin 4

Here PgAdmin4 on CentOS Install

How to Install and Getting-Started with PgAdmin 4 on Linux CentOS

Tags: CentOS, Database, Guide, How-to, Install, Linux, PostgreSQL, PostgreSQL 11 Admin CentOS, PostgreSQL 11 Admin Guide CentOS, postgresql administration guide, postgresql administration guide ubuntu, postgresql administration quick start, postgresql ubuntu quick start, Tutorial