Re: PostgreSQL [Off-topic]
Re: PostgreSQL [Off-topic]
- Subject: Re: PostgreSQL [Off-topic]
- From: Q <email@hidden>
- Date: Thu, 21 Oct 2010 00:11:23 +1000
On 20/10/2010, at 11:15 PM, Kieran Kelleher wrote:
> [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)
You can get up and running with postgresql knowing very little at all about it. However to get the most out of it you must spend some time learning a bit about how it works and how to configure it for your environment. The second phase of the learning curve is becoming familiar with all the features and functionality it provides and how and when to use them.
The default config for PostgreSQL uses very little shared memory, so just like MySQL you will want to review and edit the default config (postgresql.conf) to ensure you obtain optimal utilisation of available resources.
pgAdmin is a very useful tool (albeit an annoyingly non mac like app) for administering your databases.
> What is (are) your favorite reference website(s) for PostgreSQL?
The official documentation is excellent.
http://www.postgresql.org/
http://www.enterprisedb.com/
> 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?
There are a couple of different ways and output formats you can use to dump the database, and yes they are platform independent.
The two command line tools are:
pg_dumpall
pg_dump
> Is replication setup as easy as mysql?
I do not use mysql replication nor have I tested the replication support recently added in PostgreSQL 9 so cannot yet answer that question.
In versions prior to 9 replication has not been a standard feature so the answer would be NO for those versions.
> Is replication over SSL supported (for remote repl/backup)
I don't know if it specifically supports SSL as I have not yet used it.
> How do you install? binaries, build it form source (because the binaries do not have essential options for example)?
You can do either. I use the prebuilt version on OSX, other systems it varies.
http://www.postgresql.org/download/
--
Seeya...Q
Quinton Dolan - email@hidden
Gold Coast, QLD, Australia (GMT+10)
_______________________________________________
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