Re: parsing pg_dump -l output

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: parsing pg_dump -l output
Дата
Msg-id 20130816211232.GD8961@momjian.us
обсуждение исходный текст
Ответ на parsing pg_dump -l output  (Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>)
Ответы Re: parsing pg_dump -l output  (Athanasios Kostopoulos <athanasios.kostopoulos@classmarkets.com>)
Список pgsql-novice
On Fri, Aug 16, 2013 at 11:02:47AM +0200, Athanasios Kostopoulos wrote:
> Dear list,
> I am trying to understand the format of pg_dump -l 's output
> specifically let's examine the following line
>  16118; 1262 5499023 DATABASE - vourtsis postgres
>
> I understand that 16118 is an index value and the rest is a FYI information
> comment
> I am not sure in my example what 1262 and 5499023 are
> I understand that DATABASE indicates the type of what has been backed up
> vourtsis is the name of the object and postgres the owner, but I still have no
> idea about the first 2 numbers once the comment starts. I am trying to
> programmatically get (and subsequently sort) the sizes of what is contained
> within the backup.

I don't see any -l option for pg_dump.  Do you mean pg_restore -l?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Birchall, Austen"
Дата:
Сообщение: Re: sudo/access to the postres OS user
Следующее
От: Athanasios Kostopoulos
Дата:
Сообщение: Re: parsing pg_dump -l output