Re: Problem with backing up a large database

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem with backing up a large database
Date: 2013-08-20 11:05:36
Message-ID: CAKoxK+7h5mG7BRFF83H31wHvUXcUv8Y9sbiZ1d_yNAa+3y+5Jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

2013/8/20 Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com>:
> Dear all,
>
> I am trying to dump a large (appx 200Gb) database and exclude certain tables
> from it. The command I am using is the following (with IP/Port and DBname
> masked for obvious reasons:)
>
> pg_dump -h XXX.XXX.XXX.XXX -p XXX -U postgres -T feedimport_log -T
> error_item -T '^z*' -Fc some_large_db

Works for me on 9.2.4.
I'm not sure the regular expression is correct, so I would try only
with 'z*' (as it is I read it as something that matches any z).

Luca

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Athanasios Kostopoulos 2013-08-20 11:47:33 Re: Problem with backing up a large database
Previous Message Athanasios Kostopoulos 2013-08-20 08:04:11 Problem with backing up a large database