On Oct 20, 2010, at 9:15 AM, Kieran Kelleher wrote: > So, for mysql, a new user needs to pay attention to a few things so as not to > fall on your face with dismal performance and problems with the default > install, such as: > > - Create a my.cnf (start with one of the example files and use the reference > guide to understand all the settings in the example file) > - Ensure innodb is default engine > - Pay special attention to innodb memory allocations
The one that's burned me before is max_connections, which is only like 100 by default. > > 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 itself is actually pretty helpful. http://www.postgresql.org/docs/8.4/static/index.html > > 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? Yes, in fact you usually have to do it to upgrade versions. http://www.postgresql.org/docs/8.4/static/backup-dump.html > How do you install? binaries, build it form source (because the binaries do > not have essential options for example)? I use the distribution from EnterpriseDB http://www.enterprisedb.com/products/download.do John _______________________________________________ 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]
