Analyze. Act. Achieve.
Kurinchilion KURINCHILION Analyze. Act. Achieve.

Articles

PostgreSQL: Create database, connect and list (command line)

Changing host configuration $ vi /var/lib/pgsql/8.4/data/pg_hba.conf

Add postgresql to startup process $ chkconfig postgresql-8.4 on

Start postgresql service $ service postgresql-8.4 start

Access postgresql $ su - postgresql $ psql

Create database postgres-# create database test

List databases postgres-# \list

Exit postgresql postgres-# \q (or \quit)

Connect to database postgres-# \c test (\connect test)