Consultor Eletrônico



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.