PostgreSQL 9 Admin Guide Ubuntu Linux

June 1st, 2012 by Regaz

PostgreSQL 9 Admin Guide Ubuntu




You are Welcome! This Article Resume the Start-Up Procedure Following to 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.

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 informations on Installing PostgreSQL 9 on Ubuntu and PostgreSQL 9 Online Docs.

PostgreSQL Admin Guide Ubuntu Linux - Featured
  1. How-to Install the PostgreSQL 9 Server on Ubuntu:

    PostgreSQL on Ubuntu
  2. 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 Look: Solution

  3. Login as the postgres User

    su postgres
  4. 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:

    PostgreSQL on Ubuntu Tips
  5. Access PostgreSQL Database CLI
    First Set the postgres Database’s Password:

    psql template1
    template1# password postgres

    And Exit with:

    template1# \q

    Then to Access test Database:

    psql test
  6. Then to Create a Table

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

    \dt
  8. Again Listing Databases

    \l 

    ‘q’ to Quit.

  9. For More See PostgreSQL 9 Online Documentation

    PostgreSQL 9 SQL Guide
  10. Finally to Delete test Database

    dropdb test
  11. For GUI Administration Install PgAdmin 3:

    PgAdmin3 on Ubuntu Install

Tags: , , , , , , , , , , , , ,