[Info-Ingres] compress BEFORE tar

DATABASE

Re: [Info-Ingres] compress BEFORE tar

Postby Karl & Betty Schendel » Sat, 19 Jan 2008 12:17:14 GMT





I don't know why you would want to do that, but let's take that
as a given for the moment.


That would be a bad idea.  You'll be compressing the
data files in-place!

You could do something along the lines of:

WSDD: cd %D; for i in * ; do compress <$i >$i.Z ; done ; /bin/tar cf - *.Z | dd of=%A ; rm -f *.Z

WRDD: cd %D; dd if=%A | tar xf - ; uncompress *.Z

(warning, totally untried)

You run some slight risk with the *'s, if you have many many
tables you might exceed arglist limits.  The "right" way to do
it is with xargs.

Note that you can always write a shellscript and call it from
cktmpl.def, there's no rule that it has to be in-line.
Of course, you would then have to pass params like %D.

As for %B, I think that is just for table level checkpoints.
I'd have to look at the manual and/or code.

Karl

Similar Threads:

1.[Info-ingres] Tar does not look like a tar archive

Trying to install ingres on virgin machine, redhat 9 with all patches

$tar -tvf ingres-3.0.2-105-pc-linux-i386.tar
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Archive contains obsolescent base-64 headers
tar: Error exit delayed from previous errors
$

Ls -l ingres-3.0.2-105-pc-linux-i386.tar gives a size of 109852511

-- 
Nick 
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly 

2.compress BEFORE tar

in the chktmp.def - the "universe" of values that can be substituted
for %B - how can it be known?
in the chktmpl.def (inherited) we have:
PSDD:   /bin/echo executing checkpoint to disk
WSDD:   cd %D; /bin/tar cf - * | compress | dd of=%A

I want to compress/pack/gzip before the TAR command, so,
WSDD: cd %D; compress * ; /bin/tar cf - * | dd of=%A
should be fine
The concern is around the restore ...
PRDD:   /bin/echo executing restore to disk %C of %N locations
WRDD:   cd %D; dd if=%A | uncompress | /bin/tar xf -

change to :
WRDD: cd %D ; dd if=%A | tar xf - ; uncompress *

3.[Info-ingres] Checkpoint Fail: tar: The file aaajpnid.t00 is to large

4.[Info-ingres] Checkpoint Fail: tar: The file aaajpnid.t00 is to large

5.[Info-ingres] Checkpoint Fail: tar: The file aaajpnid.t00 is to large

6. [Info-ingres] VMS Compressed Checkpoints

7. [Info-ingres] VMS Compressed Checkpoints

8. [Info-Ingres] Compressed Checkpoints



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 34 guest