Re: Database backup

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Alexandros Perdikomatis <menippos(at)otenet(dot)gr>
Cc: pgsql-help(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Database backup
Date: 2003-01-19 02:59:00
Message-ID: 200301182159.00497.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Redirecting to help list as it seems more appropriate.

On Saturday 18 January 2003 09:17, Alexandros Perdikomatis wrote:
> Question: Am I too stupid to use tar?

I'm sure not but you may misunderstand what tar does. Tar is for storing a
collection of files into an archive. It expects to find the list of files on
the command line in one form or another. If you don't write to a file first
then all you have is a stream of data, not a file.

> Some time I had no space on the filesystem to copy all the data in command
> mode (pg_dump) so I thought to pipe pg_dump to tar using a scsi tape
> archiver as output (/dev/rmt0).
> Why doesn't work?

What exactly was the problem? You may just have a device selection issue.
What system is this on?

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeroen T. Vermeulen 2003-01-19 14:17:14 Re: libpqxx: Cursors needed??!
Previous Message Key88 SF 2003-01-18 18:34:37 Re: libpq C library Client Interface - select()