Replication exists in multiple manners for PostgreSQL. There is Mammoth replicator (our product),1. Replication: Like it or not most people regard their data and access to their data as 'invaluable'. If not, why are they storing it. Having a secondary server (read slaves) on which you can perform backups, load balance RO traffic, and eventually use as a failover has been one of the great selling points of MySQL for my specific applications. I wish there were a Master-Master replication scheme out there, but that is not the case.
ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster.
2. Documentation: In delving deeper into the Postgress database I have tried toI am sorry but I am the co-author of that book and I can tell you the only thing in that
find whatever I can to learn more. I have found an Oreilly book out there, but
the TOC reads almost the exact same as the online documentation. I ask myself -
have they lifted the documentation and are now trying to sell me it bound in
book form?
book that reads like the documentation is the reference chapter and the appendixes.
Not to mention that PostgreSQL.Org has some of the most complete documentation
of any software out there.
There are also several books on PostgreSQL including the O'Reilly one, the Addison
Wesley one, the Sams one... and I think even a PTR one.
MySQL marketing has done much to help the average database user out there feelMySQL has what 19 million in the bank?
like they are getting a powerful and feature-rich database. The average user
out there is doing nothing more than address books and recipe books. They,
This is very true. Perception is the key.I have ranted about this for a point. It is not what the seasoned 20 year UNIX veteran knows about a database/OS that really matters in terms of adoption - it is what the general mass of people __THINKS__ matters. They are becoming ever present in high levels of decision making functions. Perception is the key.
Sincerely,
Joshua D. Drake
My $0.02.
Quoting Dustin Sallings <[EMAIL PROTECTED]>:
On Jan 14, 2004, at 0:08, [EMAIL PROTECTED] wrote:
around. To make PG known there should be more and more products thatThis is very insightful. mySQL is not popular in the enterprise because it's known to solve big problems, but because it's known to solve little ones. It seems so wrong, but makes so much sense.
relay on PG. And this should be not Banking or other mission critical
projects. It should be a simple forums, picture bases i do not know
-- Dustin Sallings
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
