[ADMIN] Problem in restore data

2005-08-11 Thread Ramesh Patel
Dear All My FC3 is cresh . but i copy my /usr/local/pgsql/data folder how to i use this folder for replace data. Please help me Ramesh Patel System Dept. Banasdairy, Palanpur(B.K.) E-Mail : [EMAIL PROTECTED] Mobile : 94263 91295 ---(end of broadcast

[ADMIN] Problem in date function

2006-02-28 Thread Ramesh Patel
dear All I am use Trigger in my database . In This trigger i want to add months in date. date and no of month come from insert query mean NEW.dt or NEW.months new date = NEW.dt + NEW.months I dont know how to add month in a date in trigger. Please help me Ramesh Patel System Dept

[ADMIN] problem backup

2003-12-05 Thread Ramesh PAtel
Hi ALL i have problem after backup i have three database on one server. when i backup is done complete. but after backup my pc's speed is very slow. it is requery to restart PC. please give some ans. Ramesh Patel ---(end of broadcast)---

[ADMIN] Add user on old database with password

2003-06-12 Thread Ramesh PAtel
Hi All i am new on Postgresql7.3. so please help. i have create one(ICPS) Database  with Postgre user and password is NULL. now i want to 1) create one user with password and all Grant on Database. it is a admin user 2) i want to add password to postgres user. Please Help Ramesh Patel

[ADMIN] Problem about Backup

2003-09-07 Thread Ramesh PAtel
data whoes INSERT, UPDATE, AND DELETE between two date. Please Help me Ramesh Patel ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster