Q: How to Reset Wiki Database - Or connect to Wiki Database
I've successfully installed OS X Lion Server 10.7.3 with all services & SSL but I forgot to make a backup.
Unfortunately I was messing around with the wiki web creator & changed/removed owners mid save from a non admin profile (doh!), now I have front web links to 4 wikis that have no back end & return server errors when trying to access them from the website.
As you can imagine I'd like to remove them.
The Wiki functionality is fine other & I have since been able to make another Wiki etc.
I don't have anything meaningful in there so a wipe script to reset the Wiki db would work or download & reinstall a new db, personally I like these option over digging through SQL tables for db entries & ID's.
I have been trying to connect to postgre with pgadmin3 to run a select query but I seem to be connecting to the wrong psql & don't know how to connect to the right one for the Wiki content. I'm not exaclty a db admin but I can follow instructions & use terminal, text editors, etc.
Any idea's?
Mac mini, Mac OS X (10.7.3), Lion Server
Posted on Feb 9, 2012 10:58 PM
I found this which enabled me to execute SQL from terminal
http://krypted.com/iphone/working-with-postgres-from-the-command-line-in-lion-se rver/
But then found this & connected successfully with a 30 day trial of Navicat
http://www.mactasia.co.uk/revisited-using-postgresql-in-lion-server
I searched my Collab wiki database & removed all UID entries for my corrupted wikis & then deleted the corrupted wikis themselves.
Everything is running perfectly now
Posted on Feb 18, 2012 10:12 AM