If you modify a printer in Mac OS X Server’s Profile Manager, the changes don’t always get updated in my experience. To get the updates, you need to remove the row in the database that references the old printer.<\/p>\n
In Terminal, load psql and select the correct database: To remove the offending entry, use the DELETE command: If you modify a printer in Mac OS X Server’s Profile Manager, the changes don’t always get updated in my experience. To get the updates, you need to remove the row in the database that references the old printer. In Terminal, load psql and select the correct database: sudo psql -U _devicemgr -d devicemgr_v2m0 -h … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,7,4],"tags":[],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-apple","category-mac-os-x","category-on-the-job"],"_links":{"self":[{"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":3,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/posts\/123\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/steveneppler.com\/blog\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nsudo psql -U _devicemgr -d devicemgr_v2m0 -h \/Library\/Server\/ProfileManager\/Config\/var\/PostgreSQL
\n<\/code>
\nFind printers with the ‘select’ SQL command:
\n
\nSELECT * FROM printers;
\n<\/code>
\nThis will select all printers. You can also use SQL’s ‘WHERE’ clause to filter the results down even more.<\/p>\n
\n
\nDELETE FROM printers where id=[the 'id' column obtained from the previous list]
\n<\/code>
\nAs soon as I did this, the new printer populated in Profile Manager.<\/p>\n","protected":false},"excerpt":{"rendered":"