To backup a database I do:
nice -n +19 pg_dump -Fc database | nice -n +19 gzip --rsyncable -nc >
database.dump
If -Fc option is compressed by default I dont need gzip the backup,
but I need pass --rsyncable and -n options.
How can I pass gzip options to compress in pg_dump?
if
if you have ssh access to the client, you can do :
ssh user@client_host "cat /path_to/large_file.csv" | psql -d database
On Fri, Oct 5, 2018 at 9:06 AM Ravi Krishna wrote:
>
> We are doing a POC of using Datastage with PG using ODBC.
>
> Problem to solve: How to load a large CSV file
Is safe to upgrade from pg 9.3 to pg 10 directly using pg_upgrade or
is better upgrade, with pg_upgrade, from 9.3 -> 9.4 ->9.5 -> 9.6 -> 10.
--
.
On Thu, Apr 19, 2018 at 1:33 PM, Andreas Kretschmer <andr...@a-kretschmer.de
> wrote:
>
>
> Am 19.04.2018 um 19:57 schrieb Edmundo Robles:
>
>> I will use replication as simple backup.
>>
>
> please keep in mind, replication is not a backup. All logical error
I have several versions of postgres 9.4.5, 9.4.4, 9.4.15 (3), 9.5.3
in different versions of Debian 7.6, 7.8, 7.11, 8.5 and 8.6.
I need to replicate the databases and I have clear that I must update all
to one version.
My main question is, Do you recommended me update to 9.6 or better update
to