Red Hat Linux 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 Red Hat Enterprise GNU/Linux.
And this Red Hat Linux 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 Red Hat Linux and PostgreSQL 11 Online Docs.
How to Install PostgreSQL 11 Server on Red Hat Linux
First, Make Needed Directories.
sudo mkdir -p /home/postgres/data
Set postgres as Owner with:
sudo chown -R postgres:postgres /home/postgres
Set the postgres User Password
sudo passwd postgres
Give a Password to the postgres User Account.
If Got “User is Not in Sudoers file” then see: How to Enable sudoLogin as the postgres User
su postgres
Change to the Home Directory:
cd
And Setup User’s Path.
/necho "export PATH=$PATH:/usr/lib/postgresql/10/bin" > /var/lib/postgresql/.bashrc
Load the New PATH with:
bash
Then Setup First, PostgreSQL DB Cluster.
initdb -D /home/postgres/data
Next ReStart PostgreSQL Server.
service postgresql restart
Create a PostgreSQL test Database.
createdb test
Access PostgreSQL Database CLI
First, Set the postgres Database’s Password:psql template1
And then on the template1# Prompt:
password postgres
And Exit with:
\q
Then to Access test Database:
psql test
Then to Create a Table.
CREATE TABLE account(/nuser_id serial PRIMARY KEY,/nusername VARCHAR (50) UNIQUE NOT NULL );
Next to List Tables.
\dt
Again Listing Databases.
\l
‘q’ to Quit.
For More See PostgreSQL 11 Online DocumentationFinally, to Delete test Database.
dropdb test
For PostgreSQL 11 GUI Administration Install PgAdmin 4
PgAdmin4 on Red Hat Linux Install