Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Egon Reetz
I used Exabyte tapes for severeal years, very reliable. Sometimes there were problems with media from different vendors. I usually used 2 tapes for parallel backup/recover sessions and for fault tolerance. I would backup to harddisks only in rare cases and I don't user CDs etc. for backups. Egon

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Curt Sampson
On 17 Jul 2002, Nathan Mueller wrote: > I know it's hard to believe, but we're actually saving money dumping to > disk. We needed a new system and the decision of tape vs disk was made > based on cost alone. It's easy to believe you're saving money; the question is, how far are your backup disk

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Nathan Mueller
> I advise against hard disk based backups: Don't write off disk backups yet. I would have (and did) a year ago, but in the last six months things have gotten a lot cheaper. > It's not cheap, sure, a tape drive is expensive, but the tapes are quite > cheap. > > The cheapness of the tapes allow

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Jeremy Buchmann
On Wednesday, July 17, 2002, at 03:54 PM, Tony Reina wrote: > Yes, I'm a little wary of hard disk based systems as my sole backup. I > prefer something that allows me to have at least 2-3 different media > backups (e.g. one this week, one last week, and one the week before > last). Also, I li

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Tony Reina
Yes, I'm a little wary of hard disk based systems as my sole backup. I prefer something that allows me to have at least 2-3 different media backups (e.g. one this week, one last week, and one the week before last). Also, I like to be able to take a copy of the media home just because I'm paran

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Chad R. Larson
At 01:20 PM 7/17/02 , Tony Reina wrote: >I was thinking that some sort of DVD writing system would be good for >accessing one or two files in the backup quickly. It would probably also >complete backups faster. However, I think DVD's only hold a few Gigs on >them. Are there systems like with t

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread strange
On Wed, Jul 17, 2002 at 04:48:10PM -0500, Nathan Mueller wrote: > > Are there > > systems like with these features that could handle say 20 Gigs per > > media? > > Where I work we just started using a new disk based backup system that > we wrote in-house. Disk is a little bit cheaper then tape -

[ADMIN] Dia-->SQL Conversion (tedia2sql 1.2.1)

2002-07-17 Thread Tim Ellis
Hello, lists, As promised, I've kept quiet for a few days about my hectic release schedule for this tool. But some significant functionality has been added... so here it is. tedia2sql is a GPL'd Perl script that turns Dia UML diagrams into SQL DDL. Homepage is at http://tedia2sql.tigris.org. Ad

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Joe Conway
Nathan Mueller wrote: >>Can anyone make suggestions on backup systems? I was thinking that >>some sort of DVD writing system would be good for accessing one or two >>files in the backup quickly. It would probably also complete backups >>faster. However, I think DVD's only hold a few Gigs on them.

Re: [ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Nathan Mueller
> Can anyone make suggestions on backup systems? I was thinking that > some sort of DVD writing system would be good for accessing one or two > files in the backup quickly. It would probably also complete backups > faster. However, I think DVD's only hold a few Gigs on them. Are there > systems l

[ADMIN] Tape/DVD Backup Suggestions?

2002-07-17 Thread Tony Reina
I'm looking into new ways of backing up the data in our lab, including the PostgreSQL database. Currently, we have a single DDS-2 tape drive capable of holding 8Gig compressed. However, it is slow (i.e. takes a day to backup about 40 Gig of information), spans multiple tapes, and makes it hard to

[ADMIN] Help - pg_dump - Basic

2002-07-17 Thread Robson
            Hello.       Execute command:               [martins@tlmk martins]$ pg_dump -c televendas | gzip > televendas.db.dz               show error: WARNING: owner of type 'capitais' appears to be invalid             WARNING: owner of table 'zstbldiccampos' appear

Re: [ADMIN] Database size

2002-07-17 Thread Bruce Momjian
Elielson Fontanezi wrote: > Hello folks! > > Is there any way to know the database size of a postgres 7.2 db? Yes, use contrib/oid2name and 'du', or contrib/dblink. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000

[ADMIN] Database size

2002-07-17 Thread Elielson Fontanezi
Hello folks! Is there any way to know the database size of a postgres 7.2 db? Thanks! Elielson, ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

Re: [ADMIN] Problem compiling PostgreSQL 7.2.1 on RedHat 7.2

2002-07-17 Thread Luca Zancan
Never mind, I've found it at http://jdbc.postgresql.org/download.html I'll test it and then post the results bye Luca Luca Zancan wrote: > Thank you very much for the clarification (I've discovered something similar looking >at > "http://archives.postgresql.org"; after posting my message to

Re: [ADMIN] Problem compiling PostgreSQL 7.2.1 on RedHat 7.2

2002-07-17 Thread Luca Zancan
Thank you very much for the clarification (I've discovered something similar looking at "http://archives.postgresql.org"; after posting my message to this newsgroup...) Only another question: is there the possibility of downloading a "precompiled" version (a "jar" file) of "jdbc for postgressql"

[ADMIN] SQL date calculation problem

2002-07-17 Thread Aaron Spiteri
Title: SQL date calculation problem Hi all, I using postgresql 7.1.3 on RH 7.2 server. I am having trouble with TIMEDATE calculation using the pgplsql procedural language the logic is has follows: FOR r IN SELECT time_span FROM t WHERE name = ''NEW'' LOOP NEW.end_date := r.time_span + n

Re: [ADMIN] User's managing

2002-07-17 Thread Fouad Fezzi
Hi Cyrill According to postgresql doc there is no future for that .So you have to do that for all tables in you database with grant. In 7.2 any user can create table in your database so you have nothing to do this hole future do it for you. Perhaps in 7.3 this future will be included. Fouad -