Re: PostgreSQL [Off-topic]
Re: PostgreSQL [Off-topic]
- Subject: Re: PostgreSQL [Off-topic]
- From: Theodore Petrosky <email@hidden>
- Date: Wed, 20 Oct 2010 07:49:27 -0700 (PDT)
>
> Message: 2
> Date: Wed, 20 Oct 2010 09:15:59 -0400
> From: Kieran Kelleher <email@hidden>
> Subject: PostgreSQL [Off-topic]
> To: WebObjects-Dev Mailing List List <email@hidden>
> Cc: Miguel Arroz <email@hidden>
> Message-ID: <email@hidden>
> 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden