Kbase P62688: Support for named pipes in database administration
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  15/01/2004 |
|
Status: Unverified
GOAL:
Using named pipes in Progress database administration
GOAL:
Are named pipes supported with probkup and prorest?
FIX:
This was tested with 91D07 on HP-UX 11 machines -
1. mkdir pipetest
2. mkdir pipetest/backup
3. Start two emulator sessions running, one in pipetest, one in backup.
4. mkfifo /tmp/fifo
5. ls -l /tmp/fifo
prw-rw-rw- 1 usrname usrgrp 0 Jan 15 15:25 /tmp/fifo
6. In backup: cat /tmp/fifo
7. In pipetest: run script dateout to get date -
$PWD/dateout > /tmp/fifo
dateout:
#!/bin/sh
while sleep 3
do date
done
8. The date appears in backup. So the named pipe is working ok.
So how would this look using backups?
1. In pipetest: prodb sports sports
2. In backup: prorest testdb /tmp/fifo
3. In pipetest: probkup sports /tmp/fifo
The database testdb is created in backup. So this works, but is it supported and would there be any issues?
Generally, using named pipes like this is unsupported, but for a quick way to create or move databases around, it should be unproblematic. However, this method should not be used for making backups (and simultaneously restoring them) for your production database. The named pipe is volatile - unless the probkup (or os utility) is writing to it, then there is no data there, and thus you don't have a backup in any sense. Backups should still be done to file or tape.