![]() Sudo -u _devicemgr psql -h /Library/Server/ProfileManager/Config/var/PostgreSQL devicemgr_v2m0 -c "Copy (Select * From app_configurations) To STDOUT With CSV HEADER DELIMITER ',' " > ~/pmexport/app_configurations.csv Sudo -u _devicemgr psql -h /Library/Server/ProfileManager/Config/var/PostgreSQL devicemgr_v2m0 -c "Copy (Select * From active_locales) To STDOUT With CSV HEADER DELIMITER ',' " > ~/pmexport/active_locales.csv Sudo -u _devicemgr psql -h /Library/Server/ProfileManager/Config/var/PostgreSQL devicemgr_v2m0 -c "Copy (Select * From abstract_asm_users) To STDOUT With CSV HEADER DELIMITER ',' " > ~/pmexport/abstract_asm_users.csv Sudo -u _devicemgr psql -h /Library/Server/ProfileManager/Config/var/PostgreSQL devicemgr_v2m0 -c "Copy (Select * From abstract_asm_library_items) To STDOUT With CSV HEADER DELIMITER ',' " > ~/pmexport/abstract_asm_library_items.csv The list of relations is much more lengthy, but if you parse it then you can then use a string of commands to dump the contents of each table into a stand-alone CSV file: Template1 | _devicemgr | UTF8 | C | C | =c/_devicemgr + Template0 | _devicemgr | UTF8 | C | C | =c/_devicemgr + ![]() Name | Owner | Encoding | Collate | Ctype | Access privileges Sudo -u _devicemgr psql -h /Library/Server/ProfileManager/Config/var/PostgreSQL devicemgr_v2m0 ![]() If you fire up a connection to Postgres on a Profile Manager server, you can see a list of all the databases and tables on the server, respectively: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |