By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,905 Members | 1,607 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,905 IT Pros & Developers. It's quick & easy.

Books for PostgreSQL?

P: n/a
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary
Nov 11 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on
a RH8.0 server. Which books would you guys recommand?
Thank you.
Gary


Well Gary, I'm a newbie too and I found that 'PostgreSQL' by Douglas &
Douglas (ISBN: 0735712573) offers a very good introduction. I haven't
gotten a lot further than that for the moment, but the rest of the book
looks very prommising too. You should check the customer-reviews on Amazon
or something. You'll probably find more booktitles and info there...

Greetz
--
Tom Van den Brandt
I try...
Nov 11 '05 #2

P: n/a
>

Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?

Well there are official documentation of course
http://www.postgresql.org/docs/ which are very good. But since you asked
for books, there are some printed books available online:
http://www.postgresql.org/docs/awbook.html and
http://www.commandprompt.com/ppbook/book1.htm

Kaarel
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #3

P: n/a
Together with the official documentation I still use
PostgreSQL - Introduction and Concepts from Bruce Momjian. He should write a
much more comprehensive (tuning, large objects vs bytea) and updated (to 7.4)
2nd edition, but it is still very good and really worth the money.
Regards
Christoph
Am Donnerstag, 21. August 2003 05:13 schrieb G Lam:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #4

P: n/a
Ron
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

'PostgreSQL Essential Reference' by Barry Stinson is a useful book to
have at your desk, it's the only one I use. As the name suggests, it's a
reference and not a database/SQL how-to for total database newbies. OTOH
I *can't* recommend the O'Reilly book because the index is very poor,
making it useless as reference material.

Ron
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #5

P: n/a
> Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it
on a
RH8.0 server. Which books would you guys recommand?


Well, I'm a little biased because I work at the author's shop :), but I
use Practical PostgreSQL from O'Reilly (link below also has the book
online). And I also use Bruce Momjian's PostgreSQL Introduction and
Concepts book a lot -- it's been commuting with me to work for the past
few weeks.

I'm always on the lookout for more PostgreSQL books so I'll be
following this thread with interest.

--
Best,
Al Hulaton | Sr. Account Engineer | Command Prompt, Inc.
503.222.2783 | ah******@commandprompt.com
Home of Mammoth PostgreSQL and 'Practical PostgreSQL'
Managed PostgreSQL, Linux services and consulting
Read and Search O'Reilly's 'Practical PostgreSQL' at
http://www.commandprompt.com
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #6

P: n/a
I'll second the usefulness of Bruce's book. I still refer to it
years after buying it.

I'd highly recommend either of the two books out by Sams with by Hans and
Ewald. Both very good good books. One is just purely Postgresql, the
other is a PHP/Postgresql book.

On Wed, 27 Aug 2003, Christoph Becker wrote:
Together with the official documentation I still use
PostgreSQL - Introduction and Concepts from Bruce Momjian. He should write a
much more comprehensive (tuning, large objects vs bytea) and updated (to 7.4)
2nd edition, but it is still very good and really worth the money.
Regards
Christoph
Am Donnerstag, 21. August 2003 05:13 schrieb G Lam:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #7

P: n/a
On Wed, 2003-08-20 at 22:13, G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?


As important as the book: what version are you using? That which
comes with RH8.0? It is recommended that you upgrade to v7.3.4.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

4 degrees from Vladimir Putin
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #8

P: n/a
You could try postgres documentation at http://www.postgresql.org/docs/

or there is an online book titled 'PostgreSQL: Introduction and Concepts'
at http://candle.pha.pa.us/main/writings/computer.html
G Lam wrote:
Hi, I have some experience in MS Access 97 and 2000 and did write some
application with them. Now, I want to learn PostgreSQL. I installed it on a
RH8.0 server. Which books would you guys recommand?
Thank you.
Gary

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #9

P: n/a
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).

The index isn't great, but easily overcome:
grep -i "search phrase" /usr/local/pgsql/doc/html/* | less

Try to do that with a book. :-)

When I can't find the answer there, I search the mailing list archives
and/or google.

-heath

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #10

P: n/a
> Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).

The index isn't great, but easily overcome:
grep -i "search phrase" /usr/local/pgsql/doc/html/* | less

Try to do that with a book. :-)

When I can't find the answer there, I search the mailing list archives
and/or google.


I'm sorry, but I'm also a DB newbie, and I find the online documentation
ok/good, and very good if you are a seasoned user who just needs
reference. It esp sucks regarding the configuration file. Yes it
explains each line item, but not how it affects the database, when do
you want a large value here, when do you want a small value, etc. This
fact is born out by the number of times people have to respond with "did
you tweak xxxx in the config file?" Maybe the books aren't any better....

--
--Chris

Eagles may soar, but weasels don't get sucked into jet engines.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #11

P: n/a
On 28 Aug 2003 at 7:55, Chris Webster wrote:
Not to take anything away from the books on the topic, but my favorite
source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).

The index isn't great, but easily overcome:
grep -i "search phrase" /usr/local/pgsql/doc/html/* | less

Try to do that with a book. :-)

When I can't find the answer there, I search the mailing list archives
and/or google.


I'm sorry, but I'm also a DB newbie, and I find the online documentation
ok/good, and very good if you are a seasoned user who just needs
reference. It esp sucks regarding the configuration file. Yes it
explains each line item, but not how it affects the database, when do
you want a large value here, when do you want a small value, etc. This
fact is born out by the number of times people have to respond with "did
you tweak xxxx in the config file?" Maybe the books aren't any better....


http://www.varlena.com/varlena/Gener...ed_conf_e.html
http://www.varlena.com/varlena/Gener...bits/perf.html

These are actually collections of FAQ put in a nice sugar candy.

HTH

Bye
Shridhar

--
Respect is a rational process -- McCoy, "The Galileo Seven", stardate 2822.3
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.