Re: Optimal Flexible Architecture or Optimal Configuration Layout for Postgres

["Mark Lehmann" <mark.lehmann@xxxxxxxxx>]

I'm up to the challenge.  I'll be adding a wiki page and slowly adding to it.  Thanks for the suggestion.

-- Sent from my Palm Pre

512 689-7705

---

Emanuel Calvo Franco wrote:

2009/6/25 Mark Lehmann : > I have been looking for a best practices layout for Postgres. > > The Centos and Debian distros configure the files for Postgres in different > places.  Neither of them seem to put the files in ideal locations for > multiple instance administration on the same or different machines.  Has > someone already created a best practice for placing pg_xlogs, regular logs, > data, indexes, binary code, and configuration files onto the filesystem? > I like Centos configuration. :) Honestly i didn't see something like you describe, but it'll very cool write a kind of 'best admin practices'. In the wiki i found some of tuning (is the most similar that i found). Want to add a page on the wiki and we add things little by little? Just sugestion, what do you think? -- Emanuel Calvo Franco ArPUG [www.arpug.com.ar] / AOSUG Member www.emanuelcalvofranco.com.ar