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 going by default into the user's own schemas. For > backup purposes, I have a script that uses pg_dump to create dumps of > the individual user schemas. However, this is mainly a read-only > database and information is added or updated only rarely. What I really > need is a method of monitoring the database, such that my backup script > will only back any one schema up if it has changed since it was last > backed up. Is there any way to do this? Is there a checksum function > or something that I could use? No there is not, but would a diff -q be sufficient for your needs ? > > Thanks, > > Chris -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
