Hi! On 2010/10/20, at 14:15, Kieran Kelleher wrote:
> Q mentioned that PostgreSQL has a bit of a learning curve ...... so what are > the top few things to take care of, or gotchas, for an initial setup that is > exclusively used for WebObjects (if that makes any difference) > > What is (are) your favorite reference website(s) for PostgreSQL? The manual. :) <http://www.postgresql.org/docs/> PostgreSQL has really good documentation. And if that is not enough, you have a lot of mailing lists in <http://www.postgresql.org/community/lists/>. > What about platform-independent database dumps - does it have sth similar to > mysqldump that makes a SQL file that can recreate the entire server on > another machine and newer version? <http://www.postgresql.org/docs/9/static/app-pg-dumpall.html> > Is replication setup as easy as mysql? Dunnow, replication was introduced on version 9 (the most recent one). But I've read the docs, and it seems fairly simple. > Is replication over SSL supported (for remote repl/backup) Not sure either, but I guess you could solve that using some kind of tunneling. > How do you install? binaries, build it form source (because the binaries do > not have essential options for example)? I always build from source. Don't ask me why, I just do. :) It builds cleanly on Mac OS X, without needing any extra libs. You have to follow the installation steps tough, to create a system user for PostgreSQL and creating the initial cluster. Regards, Miguel Arroz _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
