Re: [SQL] Postgres as backend to Backup System

2004-04-27 Thread Kent L. Nasveschuk
Michael, Thanks for responding. On Tue, 2004-04-27 at 10:38, Michael Satterwhite wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Tuesday 27 April 2004 03:39, Kent L. Nasveschuk wrote: > > Hello, > > I don't know if this is the forum for this but here

Re: [SQL] Postgres as backend to Backup System

2004-04-27 Thread Kent L. Nasveschuk
ted in this project. I am setting up > a job tracking system (postgresql as the backend) for > an ad agency and I have been looking at archiving the > work files. (All Mac OS X) How are you talking to the > tape juke box? > > Postgresql would be great for your project. > >

[SQL] Postgres as backend to Backup System

2004-04-27 Thread Kent L. Nasveschuk
totalbytes int8 not null, totalfiles int8, archivestartdir varchar(100), fromserver varchar(20), datewritten date, constraint archiveid_pk primary key(archiveid) ); -- Kent L. Nasveschuk <[EMAIL PROTECTED]> ---(end of broadcas

[SQL] Postgres backend to backup system

2004-04-26 Thread Kent L. Nasveschuk
many types of servers the database should be able to store which server, archive number a file or directory is in. If you were to search in the database for a file or directory, it would return a list that gave you the tape(s), date(s), archive(s) number on tape, etc. Any suggestions would be ap