[ADMIN] Monitoring database for changes - backup purposes

2005-10-14 Thread Chris Jewell
Hi, I have a query about a backup policy that I wish to implement. Currently, we are running a PostgreSQL server with a very large database on it. The database consists of a core of read-only tables, with tables created by the users going by default into the user's own schemas. For backup

Re: [ADMIN] Monitoring database for changes - backup purposes

2005-10-14 Thread Darcy Buskermolen
On Friday 14 October 2005 06:19, Chris Jewell wrote: > Hi, > > I have a query about a backup policy that I wish to implement. > Currently, we are running a PostgreSQL server with a very large database > on it. The database consists of a core of read-only tables, with tables > created by the users

Re: [ADMIN] Monitoring database for changes - backup purposes

2005-10-14 Thread Chris Jewell
Hi, Yes, diff would work and is my current plan, but it requires me to perform the backup first. What I needed really was a system by which a backup would only be run if there was something that needed backing up. Thanks anyway, Chris -- Chris Jewell, BSc(Hons), BVSc, MRCVS Dept of Maths a

Re: [ADMIN] Monitoring database for changes - backup purposes

2005-10-14 Thread Jim C. Nasby
On Fri, Oct 14, 2005 at 07:29:31PM +0100, Chris Jewell wrote: > Hi, > > Yes, diff would work and is my current plan, but it requires me to > perform the backup first. What I needed really was a system by which a > backup would only be run if there was something that needed backing up. I believ

Re: [ADMIN] Monitoring database for changes - backup purposes

2005-10-24 Thread sualeh . fatehi
Chris, If you have a JDBC driver for pgsql, you can use SchemaCrawler. https://sourceforge.net/project/showfiles.php?group_id=148383 SchemaCrawler is a free, open source tool that can produce database schema metadata and/ or data output in a diff-able format. Sualeh. Chris Jewell wrote: > Hi,