PostgreSQL 9 Admin Guide Ubuntu Linux

June 1, 2012 | By Regaz | Filed in: Uncategorized.

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.

Furthermore 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

How-to Install the PostgreSQL 9 Server on Ubuntu:

PostgreSQL on Ubuntu

The Article Contains Instructions about Installing the PostgreSQL 9 Server on Ubuntu Linux.
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
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:

PostgreSQL on Ubuntu Tips

How-to Start-Up Correctly the PostgreSQL Server on the Ubuntu Platform.
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
```

Then to Create a Table

CREATE TABLE account(
    user_id serial PRIMARY KEY,
    username 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:

PgAdmin3 on Ubuntu Install

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

Tags: Database, Guide, How-to, Install, Linux, PostgreSQL, PostgreSQL 9 Admin Guide Ubuntu, PostgreSQL 9 Admin Ubuntu, postgresql administration guide, postgresql administration guide ubuntu, postgresql administration quick start, postgresql ubuntu quick start, Tutorial, Ubuntu