Re: [ADMIN] finding dev rpms

2009-01-26 Thread Joshua D. Drake
On Mon, 2009-01-26 at 14:42 -0700, David Bear wrote: > I'm needing to installed psycopg2.. but I've hit a dependancy problem. > pscycopg2 needs libpq stuff -- which is the the developer rpms. > Trouble is I can only find developer rpms in yum repositories. So I > went to install yum and found that

[ADMIN] finding dev rpms

2009-01-26 Thread David Bear
I'm needing to installed psycopg2.. but I've hit a dependancy problem. pscycopg2 needs libpq stuff -- which is the the developer rpms. Trouble is I can only find developer rpms in yum repositories. So I went to install yum and found that since my red had is x86_64, yum croaks on importing cElement

Re: [ADMIN] postgresql and xfs filesystrem

2009-01-26 Thread Michael Monnerie
On Montag 26 Januar 2009 Ezra Taylor wrote: > What about XFS performance on databases larger than 1 TB.  We > are successful running postgres on zfs with x4500 but I'm interested >  using commodity hardware. See http://en.wikipedia.org/wiki/Xfs#Allocation_groups XFS was designed for big iron, whe

Re: [ADMIN] postgresql and xfs filesystrem

2009-01-26 Thread Jaume Sabater
On Mon, Jan 26, 2009 at 5:01 PM, Ezra Taylor wrote: >What about XFS performance on databases larger than 1 TB. We > are successful running postgres on zfs with x4500 but I'm interested using > commodity hardware. To be honest, I have never worked with databases that big :) --

[ADMIN] Recover with main/base files

2009-01-26 Thread Sylvain Avril
Hello, I use postgresql 8.1 on a debian server with a /var JFS filesystem. After a crash of this FS (due to hardware instability: PSU), the /var/lib/postgresql/8.1/main folder was missing and its files were found under /var/lost+found. We have a full daily backup of this DB but I try to recover da

Re: [ADMIN] postgresql and xfs filesystrem

2009-01-26 Thread Ezra Taylor
Jaume: What about XFS performance on databases larger than 1 TB. We are successful running postgres on zfs with x4500 but I'm interested using commodity hardware. On Mon, Jan 26, 2009 at 2:34 AM, Jaume Sabater wrote: > On Mon, Jan 26, 2009 at 1:14 AM, Michael Monnerie > wrote: