Thread: New to postgres -' how to' tips needed

Hi,

I'm completely new to postgres. My main job will be to install and configure it properly and I'm not sure how much I can rely on the default values.

Are there any good articles howto  install and configure postgres? I have found the online documentation but need something simple.

Any suggestions comments are welcome.

Thanks,
-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------
Nina Markova,
Database Analyst                    / Analyst de base de données
(613) 992-3753       facsimile      / télécopieur (613) 992-8836
nmarkova@nrcan.gc.ca

Geological Survey of Canada         / Commission géologique du Canada
Natural Resources Canada            / Ressources naturelles Canada
Government of Canada                / Gouvernement du Canada
-----'\/\/\/`v^v^v^v^v^v^v----------------------------------------------------------------------------

On Thursday 21 August 2008, "Markova, Nina" <nmarkova@nrcan.gc.ca> wrote:
> Hi,
>
>
> I'm completely new to postgres. My main job will be to install and
> configure it properly and I'm not sure how much I can rely on the default
> values.
>
> Are there any good articles howto  install and configure postgres? I have
> found the online documentation but need something simple.

"install and configure it properly" and "simple" are mutually exclusive
requirements.

However, for the most part, if you configure it to match your real memory
availability (especially shared_buffers and work_mem) you'll usually get
decent performance (assuming whoever bought the server specced it
appropriately for the intended workload). The default settings are far too
conservative.

--
Alan

On Thursday 21 August 2008 15:16:29 Markova, Nina wrote:
> Hi,
>
>
> I'm completely new to postgres. My main job will be to install and
> configure it properly and I'm not sure how much I can rely on the default
> values.
>
> Are there any good articles howto  install and configure postgres? I have
> found the online documentation but need something simple.
>
> Any suggestions comments are welcome.
>

to get better help, you'll need to have far more specific questions. ie. some
might say "apt-get install postgres" is enough for anybody, but that might be
completly irrelevant in your environment.

that said, if you can get it installed (and really, try to get 8.3.3 if you
can), i'd recommend looking at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server for some
configuration hints.

If you have specific questions beyond that, please post them in the list, and
be sure to include your OS and version information. HTH :-)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL