[ADMIN] WAL high avail

2010-03-08 Thread Vitaly Burshteyn
Hi folks, I am setting up two fedora DB servers. One primary one warm standby via shipping of WAL files. Just curious to find what is the preferred method for shipping files. Vitaly Burshteyn Senior Network Engineer Broadway.com, Theatre Direct International 729 7th Avenue

[ADMIN] linux standard layout

2010-03-08 Thread Ben Kim
Dear list, I have about 20 postgresql databases, about 3-4 GB in total. We are moving them from Solaris/SPARC to a linux based virtual machine. I don't like the VMWare environment, but it's not my choice, and assuming the cpu load is ok, will there be any benefits if I put each database on se

Re: [ADMIN] linux standard layout

2010-03-08 Thread Scott Marlowe
On Mon, Mar 8, 2010 at 10:31 PM, Ben Kim wrote: > Dear list, > > I have about 20 postgresql databases, about 3-4 GB in total. > > We are moving them from Solaris/SPARC to a linux based virtual machine. > > I don't like the VMWare environment, but it's not my choice, and assuming > the cpu load is

Re: [ADMIN] linux standard layout

2010-03-08 Thread Daniel J. Summers
On 03/09/2010 05:31 AM, Ben Kim wrote: Also, how is using standard rpm, with its standard layout (/var/lib/pgsql, /usr/lib/pgsql, ...), generally regarded? ( vs. compiling everything ?) Does anyone think using the rpm is unprofessional or something that only beginners will do? I have someone

Re: [ADMIN] linux standard layout

2010-03-08 Thread Plugge, Joe R.
A word of caution for packages/rpms. Beware of admins who apply ALL updates that are available to a system. I have seen this happen taking Postgres from say vresion 8.3.X to 8.4.X, which as you can imagine, caused problems. From: pgsql-admin-ow...@postgresql.o

Re: [ADMIN] linux standard layout

2010-03-08 Thread Tom Lane
"Daniel J. Summers" writes: > On 03/09/2010 05:31 AM, Ben Kim wrote: >> I ask the question because sometimes I feel uneasy mixing rpms and >> source compilation. > Bingo. :) When I do have to compile, I compile AND create a package > (if possible), then install the package. +1. What's "unpr

Re: [ADMIN] linux standard layout

2010-03-08 Thread Scott Marlowe
On Mon, Mar 8, 2010 at 10:53 PM, Plugge, Joe R. wrote: > A word of caution for packages/rpms.  Beware of admins who apply ALL updates > that are available to a system.  I have seen this happen taking Postgres from > say vresion 8.3.X to 8.4.X, which as you can imagine, caused problems. I've nev

Re: [ADMIN] linux standard layout

2010-03-08 Thread Plugge, Joe R.
It has been a while ago Scott, I don't remember exactly. If it currently is not an issue then I will not be so resistant to using packages/rpms for postgres installs. One other item, and maybe it is just that I have never done it ... how would one install a package/rpm and change page size, XM

Re: [ADMIN] linux standard layout

2010-03-08 Thread Scott Marlowe
On Mon, Mar 8, 2010 at 11:21 PM, Plugge, Joe R. wrote: > It has been a while ago Scott, I don't remember exactly.  If it currently is > not an issue then I will not be so resistant to using packages/rpms for > postgres installs.  One other item, and maybe it is just that I have never > done it

Re: [ADMIN] linux standard layout

2010-03-08 Thread Plugge, Joe R.
makes sense ... thanks for the advice. From: Scott Marlowe [scott.marl...@gmail.com] Sent: Tuesday, March 09, 2010 12:29 AM To: Plugge, Joe R. Cc: Ben Kim; pgsql-admin@postgresql.org Subject: Re: [ADMIN] linux standard layout On Mon, Mar 8, 2010 at 11:21 PM, Plug