Re: Problem with backing up a large database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mael Rimbault <mael(dot)rimbault(at)gmail(dot)com>
Cc: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>, Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com>, Luca Ferrari <fluca1978(at)infinito(dot)it>, "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 19:30:24
Message-ID: 11693.1377027024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mael Rimbault <mael(dot)rimbault(at)gmail(dot)com> writes:
> 2013/8/20 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> I think it would be '[^z]*'.

> Agreed that the notation is not regex, and that the star is required,
> but '[^z]*' does not seem to address Athanasios need to me :
> $ pg_dump -s -T '[^z]*' pgbench | grep "^CREATE TABLE" | cut -d" " -f3

Ah, I was thinking of using the pattern with -t. If you want to use -T
then yeah, you'd invert the sense.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message carlosinfl . 2013-08-21 19:22:00 PostgreSQL 9.2 Log Help
Previous Message Mael Rimbault 2013-08-20 17:47:03 Re: Problem with backing up a large database