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

PostgreSQL 9 Admin Guide Ubuntu Linux

June 1, 2012 | By Duchateaux.

PostgreSQL 9 Admin Guide Ubuntu

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

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

PostgreSQL 9 Admin Guide Ubuntu Linux

  1. How to Install PostgreSQL 9 Server on Ubuntu:

    ❤️ Love Linux? Be part of our survival.
    We’ve Solved Tons of Issues but never even got offered a beer! 🍺

    ❤️ Support GNU/Linux Freedom

    PostgreSQL on Ubuntu

  • 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

  • Login as the postgres User.

    su postgres

  • Create a PostgreSQL test Database.

    createdb test

    If your Database is Not Already Started or the psql Command do Not Works look the Troubleshooting Here Below.

    How to StartUp the PostgreSQL 9 Server:

    ❤️ Love Linux? Be part of our survival.
    We’ve Solved Tons of Issues but never even got offered a beer! 🍺

    ❤️ Support GNU/Linux Freedom

    PostgreSQL on Ubuntu Tips

  • Access PostgreSQL Database CLI
    First, Set the postgres Database’s Password:

    psql template1
    template1# 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 9 Online Documentation

    PostgreSQL 9 SQL Guide
    PostgreSQL 9 Docs

  • Finally, to Delete test Database.

    dropdb test

  • For GUI Administration Install PgAdmin 3:

    ❤️ Love Linux? Be part of our survival.
    We’ve Solved Tons of Issues but never even got offered a beer! 🍺

    ❤️ Support GNU/Linux Freedom

    PgAdmin3 on Ubuntu Install
    How to Install and Getting-Started to Create Databases with PgAdmin 3 on Ubuntu

    • Tags: , , , , , , , , , , , , ,

    «
    »