Re: Problem with backing up a large database

2013/8/20 Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.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