Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Achilleas Mantzios
On 28/11/2016 19:21, Melvin Davidson wrote: On Mon, Nov 28, 2016 at 10:50 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 11/28/2016 07:44 AM, Melvin Davidson wrote: *To clarify, you cannot dump the pg_catalog schema. It is the main control of how all othe

Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Melvin Davidson
On Mon, Nov 28, 2016 at 10:50 AM, Adrian Klaver wrote: > On 11/28/2016 07:44 AM, Melvin Davidson wrote: > >> >> > >> >> *To clarify, you cannot dump the pg_catalog schema. It is the main >> control of how all other objects are >> > > Actually you can. I would not of thought so, but tried Achillea

Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Adrian Klaver
On 11/28/2016 07:44 AM, Melvin Davidson wrote: *To clarify, you cannot dump the pg_catalog schema. It is the main control of how all other objects are Actually you can. I would not of thought so, but tried Achilleas's suggestion and it worked. Example: -- -- Name: pg_aggregate; Type: T

Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Melvin Davidson
On Mon, Nov 28, 2016 at 9:33 AM, Adrian Klaver wrote: > On 11/28/2016 03:40 AM, Juliano wrote: > >> I'm not knew that system catalogs could be saved as schema, thanks >> Achilleas. >> >> So, I would like to get the data and the schema of the system catalogs. >> How can I include the data in a dum

Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Adrian Klaver
On 11/28/2016 03:40 AM, Juliano wrote: I'm not knew that system catalogs could be saved as schema, thanks Achilleas. So, I would like to get the data and the schema of the system catalogs. How can I include the data in a dump file with system schemas? (The parameter -a makes sense together the p

Re: [GENERAL] pg_dump system catalog

2016-11-28 Thread Juliano
I'm not knew that system catalogs could be saved as schema, thanks Achilleas. So, I would like to get the data and the schema of the system catalogs. How can I include the data in a dump file with system schemas? (The parameter -a makes sense together the parameter --schema?) Regards, Juliano

Re: [GENERAL] pg_dump system catalog

2016-11-25 Thread Achilleas Mantzios
On 25/11/2016 13:11, Juliano wrote: Hi everyone, How can I *use pg_dump* to do a backup of *"system catalogs"* only? pg_dump --schema=pg_catalog Regards, Juliano -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

[GENERAL] pg_dump system catalog

2016-11-25 Thread Juliano
Hi everyone, How can I use pg_dump to do a backup of "system catalogs" only? Regards, Juliano