Learning PostgreSQL

Question

What's the best place to start learning PostgreSQL administration and programming in a Linux environment? What websites are the most recommended, concise and have easy to learn tutorials?

I am already familiar with ANSI SQL from playing with SQL Server and MySQL; however, I've never touched PostgreSQL before. Any direction you can give is appreciated.

Answer 1

I have found the documentation on the web for postgresql to be very high quality.

Answer 2

best way to learn to admin a database is to download it, install it, and start it up and work through the problems/questions as they happen.

download from: http://www.postgresql.org/

Once you have it up and running, pick a topic to learn and read up on that one topic. Move from topic to topic, until you can do everything you want to do.

Answer 3

Having gone through this exact process about a year ago I found the following useful:

1. psql prompt is your friend.
2. The postgres online docs are great.
3. This postgres book was great for both admin and programing for postgres driven programs.

Answer 4

The online documentation and IRC are the best locations. IRC is very, very helpful.

Answer 5

PostgreSQL documentation mentioned above is very comprehensive. Additionally you can find many PostgreSQL related blog posts on Planet PostgreSQL

Answer 6

The PostgreSQL mailing lists are superb, particularly pgsql-general; they provide a level of help and support that couldn't be bought for any money.