PostgreSQL 9 Admin Guide Ubuntu
You are Welcome! 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.
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 information on Installing PostgreSQL 9 on Ubuntu and PostgreSQL 9 Online Docs.
-
How to Install the PostgreSQL 9 Server 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:
-
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( 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
-
Finally, to Delete test Database.
dropdb test
-
For GUI Administration Install PgAdmin 3:
PgAdmin3 on Ubuntu Install
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
