$schemamarkup = get_post_meta(get_the_ID(), 'schemamarkup', true); if(!empty($schemamarkup)) { echo $schemamarkup; }

PostgreSQL 10 Admin Guide Fedora

December 14, 2017 | By the+gnu+linux+evangelist.

PostgreSQL 10 Admin Guide Fedora

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

And this Fedora 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 Fedora and PostgreSQL 10 Online Docs.

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

    Here PostgreSQL 10 Fedora Install
    How to Easy-Install the PostgreSQL 10 Server on Fedora
  2. 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. 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. Login as the postgres User

    Copy
    su postgres

    Change to the Home Directory:

    Copy
    cd 
  5. Then Setup First, PostgreSQL DB Cluster.

    Copy
    initdb -D /home/postgres/data
  6. Next Start PostgreSQL Server.

    Copy
    pg_ctl -D /home/postgres/data -l logfile start
  7. Create a PostgreSQL test Database.

    Copy
    createdb test
  8. Finally, 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
  9. Then to Create a Table.

    Copy
    CREATE TABLE account(/nuser_id serial PRIMARY KEY,/nusername VARCHAR (50) UNIQUE NOT NULL 
    );
    
  10. Next to List Tables.

    Copy
    \dt
  11. Again Listing Databases.

    Copy
    \l 

    ‘q’ to Quit.

  12. For More See PostgreSQL 10 Online Documentation

    Here PostgreSQL 10 SQL Guide
    PostgreSQL 10 Official Online Documentation
  13. Finally, to Delete test Database.

    Copy
    dropdb test
  14. For PostgreSQL 10 GUI Administration Install PgAdmin 4

    Here PgAdmin4 on Fedora Install
    How to Install and Getting-Started with PgAdmin 4 on Fedora