pg_dump selectively ignores extension configuration tables

Поиск
Список
Период
Сортировка
Искать
От
Joe Conway
Тема
pg_dump selectively ignores extension configuration tables
Дата
Msg-id
513A613D.70803@joeconway.com
Список
Дерево обсуждения
pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
Re: pg_dump selectively ignores extension configuration tables Robert Haas <robertmhaas@gmail.com>
Re: pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
Re: pg_dump selectively ignores extension configuration tables Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
Re: pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
Re: pg_dump selectively ignores extension configuration tables Vibhor Kumar <vibhor.kumar@enterprisedb.com>
Re: pg_dump selectively ignores extension configuration tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump selectively ignores extension configuration tables Vibhor Kumar <vibhor.kumar@enterprisedb.com>
Re: pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
Re: pg_dump selectively ignores extension configuration tables Vibhor Kumar <vibhor.kumar@enterprisedb.com>
Re: pg_dump selectively ignores extension configuration tables Vibhor Kumar <vibhor.kumar@enterprisedb.com>
Re: pg_dump selectively ignores extension configuration tables Joe Conway <mail@joeconway.com>
(reposting" apparently I used a verboten word the firsttime around . Sorry for any duplicates)

The -t and -n options of pg_dump do not dump anything from an extension
configuration table, whereas normal pg_dump will dump the user data.

To see what I mean, in psql do (tested on pg9.2):
8<--------------------------
create extension postgis;
insert into spatial_ref_sys values(42,'test',42,'foo','bar');
8<--------------------------

Then in bash do:
8<--------------------------
pg_dump                    test|grep spatial_ref_sys
pg_dump -t spatial_ref_sys test|grep spatial_ref_sys
pg_dump -n public          test|grep spatial_ref_sys
8<--------------------------

Is this intentional, or oversight, or missing feature?


Thanks,

Joe

-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support



В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
Сообщение: Re: Duplicate JSON Object Keys
От: Josh Berkus
Дата:
Сообщение: Re: Duplicate JSON Object Keys
FAQ