On Fri, 2014-02-07 at 14:32 +0000, Rob Richardson wrote: > Greetings! > > I have been curious for several years: Why doesn't PGAdmin's backup screen > allow me to save data only or schema only in custom format? > > > I am trying to test a long-running application that uses a PostgreSQL > database. I occasionally need to change or add a database function or make > some other change that does not affect table structures. I also need to save > backups of the database at various times as the application runs so I can > restart the application from that point. In the past, if I changed a > database function, I needed to open all of the database copies I've been > using and apply the change to each one individually. > > It occurred to me recently that if I save the data and schema separately, > then I can create a database, load the latest version of the schema (with the > changed function) into it, and then choose which state of data to load > (beginning of the application, middle, near the end, or whatever). > > With PGAdmin's backup screen, I only get a choice of data only or schema only > if I select a plain format for my backup file. But then, if I use psql to > restore my data, all triggers are active, and the effects of the triggers > mean that the restored data is not the same as the data that was backed up. > psql does not have a disable triggers options. On the other hand, pg_restore > does have an option to disable triggers, ensuring that the restored data is > identical to the saved data. But pg_restore only works on custom format > files. PGAdmin's backup screen is merely a GUI wrapper around the pg_dump > program, and with pg_dump there's no problem saving schema only or data only > into custom-format files. So why doesn't PGAdmin let us do it? >
To be honest, I have no idea. And it doesn't make any sense to me. When I added the section options to pgAdmin, I allowed it to be used, even with binaries format. It isn't consistent. If noone objects, it would be good to allow schema and data only with binaries format. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
