PostgreSQL 10 Admin Guide Ubuntu Linux

October 16, 2017 | By the+gnu+linux+evangelist.

PostgreSQL 10 Admin Guide Ubuntu

Hi! This Article Resume the Start-Up Procedure Following the Installation for Getting-Started with PostgreSQL 10 Administration on Ubuntu Linux.

And this Ubuntu PostgreSQL 10 Admin Guide let you make the First, Steps Easily with PostgreSQL 10 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 10 on Ubuntu and PostgreSQL 10 Online Docs.

PostgreSQL 10 Admin Guide Ubuntu - Featured
  1. How to Install PostgreSQL 10 Server on Ubuntu

    PostgreSQL 10 Ubuntu Install
  2. First, Make Needed Directories.

    sudo mkdir -p /home/postgres/data

    Set postgres as Owner with:

    sudo chown -R postgres:postgres /home/postgres
  3. 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 sudo

  4. Login as the postgres User

    su postgres

    Change to the Home Directory:

    cd 
  5. And Setup User’s Path.

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

    Load the New PATH with:

    bash
  6. Then Setup First, PostgreSQL DB Cluster.

    initdb -D /home/postgres/data
  7. Next ReStart PostgreSQL Server.

    service postgresql restart
  8. Create a PostgreSQL test Database.

    createdb test
  9. 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
  10. Then to Create a Table.

    CREATE TABLE account(
    user_id serial PRIMARY KEY,
    username VARCHAR (50) UNIQUE NOT NULL 
    );
    
  11. Next to List Tables.

    \dt
  12. Again Listing Databases.

    \l 

    ‘q’ to Quit.

  13. For More See PostgreSQL 10 Online Documentation

    PostgreSQL 10 SQL Guide
  14. Finally, to Delete test Database.

    dropdb test
  15. For PostgreSQL 10 GUI Administration Install PgAdmin 4


QuickChic Theme • Powered by WordPress