[ADMIN] triggers

2005-11-20 Thread Enzo D'addario
Hi, I originally implemented a number of triggers in our production DB using 'plpgsql' and they have been running flawlessly for many years. It has now become necessary to split up our main DB into a number of separate DB's. My question is: Is it possible for a table insert/update(via trigger)

[ADMIN] On-line backup and point-in-time recovery (PITR)

2005-08-18 Thread Enzo D'addario
between the SELECT pg_start_backup() and the end of the tar? They would be already logged in the WAL files and already applied in the tarball, do they then get duplicated during log replay in the recover process? Thanks In Advance Enzo D'Addario... pieNETWORK&

[ADMIN] vacuum taking longer over time

2005-06-27 Thread Enzo D'addario
blem? Any ideas would be greatly appreciated. Thanks in advance. Enzo D'Addario ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] vacuum taking longer over time

2005-06-27 Thread Enzo D'addario
Will upgrading to postgres 8.0 resolve this problem? Any ideas would be greatly appreciated. Thanks in advance. Enzo D'Addario ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscri