Search Postgresql Archives

Re: How to do pg_dump + pg_restore within Perl script?

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

 



Kynn Jones <kynnjo@xxxxxxxxx> writes:
> Actually, that was a mistake on my part.  That should have been "-Ft" rather
> than "-Z9 -Fc", since I *don't* want compression (most of the data being
> transmitted consists of highly incompressible blobs anyway).  Regarding SSH,
> my understanding is that to get compression one needs to pass to it the -C
> flag at the time of creating the tunnel.  But my grasp of these details is
> tenuous as best.

Actually, I'd suggest -Fc -Z0, or maybe plain text dump, if your
motivation is to avoid compression.  -Ft has its own issues that
make it a less-than-desirable choice; you shouldn't pick it unless
you really specifically need a tar-compatible dump format.

			regards, tom lane

-- 
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