Removing a Public Facing User Page in OS X Server Wiki
OS X Server has some pretty neat tools that are easy to set up and use for a team collaboration. The problem is that some of these tools are a bit quirky, especially when it comes to removing users or making sure that no data is accessible from the outside world. For example, if you edit your user profile page, this change will be visible to the public world. There is no real way (that I can find) to hide it, so it is a little bit annoying. Even removing the user from the wiki does not fix this. After doing some digging, it looks like all of this is controlled by a PostgreSQL database which makes it nice to try to figure out how to get rid of these pages. You can log into the PostgreSQL database on OS X server by opening up a terminal and running sudo -u _postgres psql template1 You can list all of the available databases by running \listand you should see one called collab. Connect to collab so that you can view the data inside and make some changes by running \c collab You can see the entire scheme by running \dt and it will look something like this:
: List of relations Schema | Name | Type | Owner --------+-----------------------------+-------+-------- public | blog_entity | table | collab public | document_entity | table | collab public | entity | table | collab public | entity_acls | table | collab public | entity_acls_defaults | table | collab public | entity_attrs | table | collab public | entity_changesets | table | collab public | entity_comment | table | collab public | entity_lock | table | collab public | entity_preview | table | collab public | entity_private_attrs | table | collab public | entity_tag | table | collab public | entity_type | table | collab public | file_entity | table | collab public | filedata_entity | table | collab public | filename_reservation | table | collab public | global_settings | table | collab public | groups | table | collab public | migration_entity | table | collab public | migration_status | table | collab public | migrationplaceholder_entity | table | collab public | notification | table | collab public | page_entity | table | collab public | podcast_entity | table | collab public | podcast_episode_entity | table | collab public | preview_queue | table | collab public | project_entity | table | collab public | relationship | table | collab public | savedquery_entity | table | collab public | search_index | table | collab public | search_stat | table | collab public | session | table | collab public | subscription | table | collab
select * from entity where long_name like 'Lev%';
com.apple.entity.Page. You can grab the uid of this item from the first column and then run a simple update statement to mark the item as deleted.
update entity set is_deleted = 't' where uid = 'YOUR UID';
Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.
Check out some more stuff to read down below.
Most popular posts this month
- 2024
- Setting up ANTLR4 on Windows
- My Custom Miniflux CSS Theme
- SQLite DB Migrations with PRAGMA user_version
- Ten Years of Dreaming of San Francisco
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- Fedora Magazine: Contribute to Fedora 44 KDE and GNOME Test Days from Fedora People
- Pluralistic: bunnie's piggyback hack (09 Jan 2026) from Pluralistic: Daily links from Cory Doctorow
- Clicks Communicator from Chris Hannah
- A Year Of Vibes from Armin Ronacher's Thoughts and Writings
- Pluralistic: A perfect distillation of the social uselessness of finance (18 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
- Moving from WordPress to Substack from charity.wtf
- Grow, Like a Tree Not a Cancer from Jim Nielsen’s Blog
- Pluralistic: All the books I reviewed in 2025 (02 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
Articles from blogs I follow around the net
Announcing Live AI & Design Systems Jam Sessions!
Ian, TJ, and I are excited to announce live AI & Design Systems Jam Sessions with our AI & Design Systems course community! Our first jam session will be Thursday, February 26 at 10AM ET. In these recurring biweekly Zoom […]
via Blog – Brad Frost February 16, 2026I Sold Out for $20 a Month and All I Got Was This Perfectly Generated Terraform
Until recently the LLM tools I’ve tried have been, to be frank, worthless. Copilot was best at writing extremely verbose comments. Gemini would turn a 200 line script into a 700 line collection of gibberish. It was easy for me to, more or less, ignore LLM…
via matduggan.com February 16, 2026Pluralistic: The online community trilemma (16 Feb 2026)
Today's links The online community trilemma: Reach, community and information, pick two. Hey look at this: Delights to delectate. Object permanence: Bruces x Sony DRM; Eniac tell-all; HBO v PVRs; Fucking damselflies; Gil Scout Cookie wine-pairings; Bi…
via Pluralistic: Daily links from Cory Doctorow February 16, 2026Generated by openring