Re: Validade dump file

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Willy-Bas Loos" <willybas(at)gmail(dot)com>, "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>
Cc: <gibon(at)comexsystem(dot)com(dot)br>, "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Validade dump file
Date: 2010-10-05 15:35:18
Message-ID: 4CAAFF660200002500036525@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> any idea for the number of tuples?

Your best bet would be to use whatever scripting language you like
which has decent support for regular expressions. Expect to tweak
your expressions a bit as you discover the corner cases where you're
not getting the count you expect.

> on a side note: what's the difference between the admin list and
> the general list?

This thread is OK on admin -- which is targeted toward operational
issues. If in doubt, general can include just about anything. It
gets traffic about equal to all the more specific lists combined, so
it's a bit much for some of us to follow. Some people (like me) who
can't absorb the volume of traffic on general follow a few more
specialized lists where we feel we're best able to help. If
discussion on one list dies out without a satisfactory resolution,
it's OK to try another likely-looking list -- particularly if
there's no further repsonse on the initial list for a few days.
While there's a fair amount of overlap, you will get a somewhat
different set of people tracking each list.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kieren Scott 2010-10-05 15:56:55 Re: vacuum full table - internals in 8.3
Previous Message Kevin Grittner 2010-10-05 15:24:26 Re: vacuum full table - internals in 8.3