Step-by-step | PostgreSQL Admin Guide for Gnu/Linux

Getting Started

2. Making Directories

First, Make Needed Directories.
Copy
```
sudo mkdir -p /home/postgres/data
```
Set postgres as Owner with:
Copy
```
sudo chown -R postgres:postgres /home/postgres
```
3. Setting up postgres Pass

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
4. Logging in

Login as the postgres User
Copy
```
su postgres
```
Change to the Home Directory:
Copy
```
cd 
```
5. Setting up PATH

And Setup User’s Path.
Copy
```
echo "export PATH=$PATH:/usr/lib/postgresql/[REL]/bin" >> ~/.bashrc
```
Replace [REL] with your Current one in the above Command.

Load the New PATH with:
Copy
```
bash
```
6. Making PostgreSQL DB Cluster

Then Setup First, PostgreSQL DB Cluster
Simply run:
Copy
```
initdb -D /home/postgres/data
```
This just for testing pourposes…
7. Starting PostgreSQL Server

Next to Start PostgreSQL Server
Play:
Copy
```
pg_ctl -D /home/postgres/data -l logfile start
```
In case of Issue then Check the logfile with:
Copy
```
cat logfile
```
8. Making PostgreSQL Test DB

Create a PostgreSQL test Database
Issue:
Copy
```
createdb test
```
9. Accessing PostgreSQL Database

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
```

10. Creating Table

Then to Create a Table.

Copy

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

11. Listing Tables

Next to List Tables
With:
Copy
```
\dt
```
12. Listing Databases

Again Listing Databases
Use:
Copy
```
\l 
```
‘q’ to Quit.
For More See PostgreSQL Online Documentation
13. Dropping Test DB

Finally, to Delete test Database
Issue:
Copy
```
dropdb test
```
14. Installing PostgreSQL Admin UI

For PostgreSQL GUI Administration Install PgAdmin 4

Here PgAdmin4 on Linux Install

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

Pages: 1 2

Step-by-step | PostgreSQL Admin Guide for Gnu/Linux

Getting Started

2. Making Directories

3. Setting up postgres Pass

4. Logging in

5. Setting up PATH

6. Making PostgreSQL DB Cluster

7. Starting PostgreSQL Server

8. Making PostgreSQL Test DB

9. Accessing PostgreSQL Database

10. Creating Table

11. Listing Tables

12. Listing Databases

13. Dropping Test DB

14. Installing PostgreSQL Admin UI

Contents