[ADMIN] long idle connections causing problems?

2005-08-18 Thread Kaolin Fire
che/2.0.51 Fedora Core 2, kernel 2.6.9 Any thoughts on what configuration I should be looking at, or if there's something I just dearly need to upgrade, ...? Thank you for your time. :) -kaolin fire -http://erif.org/code/detritus/ ---(e

Re: [ADMIN] Create Linux Script for PostgreSQL database backup

2004-09-01 Thread Kaolin Fire
For that matter: echo "1 3 * * * postgres /usr/local/bin/pg_dumpall > ~/backup.sql" >> /etc/crontab note to remember the two >>'s so you don't obliterate your crontab like I just did. :ulp: -kaolin tim hall wrote: Lawrence C, On Wednesday 01 September 2004 14:20, you went: Anyone

[ADMIN] identical queries performing differently?

2004-08-10 Thread kaolin fire
-> Index Scan using status_idx on status s2 (cost=0.00..304.33 rows=1 width=8) (actual time=72.42..72.42 rows=0 loops=960) Index Cond: ((s2.id > "outer".id) AND ("outer".objectid = s2.objec

Re: [ADMIN] binary fields

2004-04-07 Thread kaolin fire
The keyword you want is "large objects". -kaolin fire -http://erif.org/code/fallingup/ On Apr 7, 2004, at 2:42 PM, Jaime Casanova wrote: hi all, again. i can't find how can i store bynary fields (images, ¿¿pdfs?? is it possible?) in postgres. i'm using vb as frontend.

Re: [ADMIN] WAL logs and segment files

2004-02-20 Thread kaolin fire
If you know where I can get a 1.5e+11 terabyte drive, I'd love to hear it. ;) -kaolin fire -http://erif.org/code/fallingup/ On Feb 20, 2004, at 12:29 PM, Bruce Momjian wrote: Eduardo Leva wrote: Hi, guys... I'm reading the version 7.3.4 documentation and I found this: " "

[ADMIN] FATAL 2: (pg_clog ... no such file or directory)

2004-02-06 Thread kaolin fire
just looks like it goes from (May 14 2002) to 004F (Feb 6 2004, and counting). I'm running 7.2.4 -kaolin fire ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread kaolin fire
but figuring out what they touch could be prohibitive? kudos for any attempt, though, all around. :) -kaolin fire -postgresql novice -http://poemranker.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]