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 по дате отправления