> > Message: 2 > Date: Wed, 20 Oct 2010 09:15:59 -0400 > From: Kieran Kelleher <[email protected]> > Subject: PostgreSQL [Off-topic] > To: WebObjects-Dev Mailing List List <[email protected]> > Cc: Miguel Arroz <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > [Bringing this twitter discussion to the mailing list...] > > 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 > > > 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?
http://www.postgresql.org > > 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? > > Is replication setup as easy as mysql? > Is replication over SSL supported (for > remote repl/backup) > as said before new in 9 > How do you install? binaries, build it form source (because > the binaries do not have essential options for example)? always install from source (very simple compile). googling on "shmmax postgresql os x" gives a plethora of settings for shared memory. I only need to add a file: /etc/sysctl.conf kern.sysv.shmmax=536870912 kern.sysv.shmmin=1 kern.sysv.shmmni=8 kern.sysv.shmseg=32 kern.sysv.shmall=131072 and everything was beautiful > > -Kieran > _______________________________________________ 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]
