Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

In response to


pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group