Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system
Strongest points are its stability, and transactional safety.
Many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications.
eRServer(c) v1.0+ for the PostgreSQL database

Creating Postgresql user

TIP: Have be the user postgres (who owns postmaster) to create your first new PostgreSQL user.

$ sudo -u postgres psql template1
...
> create user david with encrypted password 'foobar' createdb;

$ psql template1 david

Don't forget to setup /var/lib/pgsql/data/pg_hba.conf. RedHat sets this to be sameuser, i.e. authentication is determined by the OS. I prefer using the passwords stored in the database. Means your database user doesn't need to have the same name as your Linux user. (NB: postgresql should be restarted or sent a SIGHUP after changing pg_hba.conf.)

local   all  all  md5

Postgresql Links

PostgreSQL 7.3 Documentation
Working with psql
ECPG Tutorial
How PostgreSQL Rose to Fame
PGDesigner
libpqxx a C++ API for PostgreSQL
FTP PostgreSQL
Multiple connections in embedded SQL
Linux tutorials (includes PG)
ECPG tutorial
Practical PostgreSQL - the PostgreSQL book

Linux | Software | MySQL | DatabaseLinks | CategoryDatabases