Re: [GENERAL] Postgres + CentOS

2005-11-02 Thread Apu Islam
Just installed and tuned 8.0. tested with 100 connections and a 7.5 GB database, works like a champ. new pl/perl is a beauty to write triggers on 8.0, check it out. On 11/2/05, Steve Wampler [EMAIL PROTECTED] wrote: Hugo wrote: Hi, is anybody using psql and CentOS, I just wanted to know your

[GENERAL] scheduled backup

2005-10-21 Thread Apu Islam
I need suggestion to backup my postgresql server. The database is growing 1/2 Gb a day and I am looking for a solution that would push the data off to the backup server periodically with minimal amount of load to the server (I am trying to avoid table locking). I am thinking to use rsync to sync

Re: [GENERAL] scheduled backup

2005-10-21 Thread Apu Islam
/21/05, Scott Marlowe [EMAIL PROTECTED] wrote: On Fri, 2005-10-21 at 13:38, Scott Marlowe wrote: On Fri, 2005-10-21 at 12:22, Apu Islam wrote: I need suggestion to backup my postgresql server. The database is growing 1/2 Gb a day and I am looking for a solution that would push the data off

[GENERAL] trigger question

2005-08-16 Thread Apu Islam
I have a trigger which is not working properly. The error I get is parse error at $1. I am putting the code here for someone to see and comment on. (p/s the double quotes are actually two single quotes) best regards, -apu CREATE FUNCTION cust_call_update() RETURNS TRIGGER AS ' DECLARE