Search Postgresql Archives

Re: Need help on how to backup a table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



am  Fri, dem 28.03.2008, um  3:01:43 -0700 mailte ajcity folgendes:
> 
> 
> 
> 
> Local file systems, and the user postgres needs write-access. I'm using
> /tmp/... for such. 
> And yes: COPY from a select works only for 8.2 up, not for 8.1. Create a
> table via 'create table as select ...' and COPY this table.
> 
> 
>  
> I'm trying to avoid exporting to the local machine before uploading to the
> remote machine; I wanna just run it from the remote machine and have the
> data on the remote machine once its done. Is there a way to do this?

Without quote-sign it's hard to understand, who has written what.

Okay, you can mount the remote-filesystem over the network on the
server, is this a option for you?


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux