PostgreSQL - what are the best resources on the net?

Databases
1

PostgreSQL -what are the best resources on the net?

Can anybody submit good links, tutorials, links to references, and recommended books

thanks,

DH

2
  • <snip/> (actually, you only need to know this site, because everything good about PostgreSQL is linked here sooner or later, including online books, tutorials, etc…)
  • http://archives.postgresql.org/ (sign up to some of the mail lists and you will get the best education in PostgreSQL possible)
  • http://dbforums.com/ and http://forums.devshed.com/ (each has a decent PostgreSQL forum)
  • Oh, and yours truly is currently listed as the top PostgreSQL expert at Tek-Tips :wink:
  • http://www.freebsddiary.org/ – of course PostgreSQL is the natural choice of a DBMS for FreeBSD, and occasionally there are PostgreSQL articles here.
  • http://gborg.postgresql.org/ – all kinds of projects related to PostgreSQL and PostgreSQL enhancements.
  • <snip/> – nice collection of links for PostgreSQL
  • www.dbdebunk.com – not a PostgreSQL site, but good for people interested in understanding relational databases more deeply. Thought you knew what a relational DBMS is? Think again.

There are a couple decent books out for PostgreSQL, such as “PostgreSQL Developer’s Handbook”, but so far I have not seen any great books for PostgreSQL. They tend to be good for administration, but they don’t dig too deeply into the logical capabilities of PostgreSQL. Also, most of these books are out of date, since PostgreSQL introduced schema and domain support in version 7.3.

3

There are some people very knowledgeable about PostgreSQL that frequent the database forum at [URL=http://www.phpbuilder.com]PHP Builder .

4

Not too sure if this is the right place though I’ve come across an tutorial (unread as of yet though so can’t comment on contents) so thought I’d share the link with you all ?

I’ll have a read of it later myself but in the mean time here is the link:

http://www.databasejournal.com/features/postgresql/article.php/3064861

Enjoy :slight_smile:

5

I’d also suggest hanging around #postgresql in Freenode :). Sometimes there are things so obvious Google will spend too long looking for but you can ask people quickly there.

6

http://pgsql.ru
Can be used as interface to a set of useful PG related resources

7

don’t forget the pgsql mailing list! it has been a lifesaver so many times that i feel like i’ve lowered the average number of cat lives from 9 to 7…

http://www.postgresql.org/community/lists/

the novice list is a great place to start.

8

This blog is quite good: IAmA DBA AMA

9

Gregory Smith - PostgreSQL 9.0 High Performance is highly advised book.

I advised blogs of the PostgreSQL developers.

http://www.depesz.com/
http://michael.otacoo.com/
http://planet.postgresql.org/

10

Thanks everyone.

This is an old thread and in need of updating. If anyone has something they think should be added to it, please contact a member of the Programming Team.