How can I reset/wipe/delete all my wiki content?

Question

I would like to start my Wiki again from emply blank content without having to reinstall the entire lion server.

jmacalister · Accepted Answer

I found this which enabled me to execute SQL from terminalhttp://krypted.com/iphone/working-with-postgres-from-the-command-line-in-lion-se rver/But then found this &amp; connected successfully with a 30 day trial of Navicathttp://www.mactasia.co.uk/revisited-using-postgresql-in-lion-serverI searched my Collab wiki database &amp; removed all UID entries for my corrupted wikis &amp; then deleted the corrupted wikis themselves.Everything is running perfectly now 🙂

Xavier Laville · Answer

Here is a set of TERMINAL commands that will reset our Mac OSX Lion Server Wiki. Take care, all posts will be deleted. You will restart with a clean wiki database:sudo serveradmin stop postgressudo mv /var/pgsql /var/pgsqloldsudo mkdir /var/pgsqlsudo chmod 700 /var/pgsqlsudo chown _postgres:_postgres /var/pgsqlsudo /System/Library/ServerSetup/CleanInstallExtras/01_PostgreSQLSetup.rbsudo serveradmin fullstatus postgressudo serveradmin start postgres

Steven Bytnar · Answer

Those terminal commands will wipe out all of the databases, not just the Wiki.bash-3.2# psql -l -U _postgres                                    List of databases       Name        |   Owner    | Encoding | Collation | Ctype |    Access privileges    -------------------+------------+----------+-----------+-------+------------------------- caldav            | caldav     | UTF8     | C         | C     |  collab            | collab     | UTF8     | C         | C     |  device_management | _devicemgr | UTF8     | C         | C     |  postgres          | _postgres  | UTF8     | C         | C     |  roundcubemail     | roundcube  | UTF8     | C         | C     |  template0         | _postgres  | UTF8     | C         | C     | &#x3D;c/_postgres           +                   |            |          |           |       | _postgres&#x3D;CTc/_postgres template1         | _postgres  | UTF8     | C         | C     | &#x3D;c/_postgres           +                   |            |          |           |       | _postgres&#x3D;CTc/_postgres(7 rows)Warning: I haven&#x27;t tried this, but doing something like this might reset only the Wiki:sudo -sserveradmin wiki stop/usr/bin/dropdb collab/System/Library/ServerSetup/CommonExtras/PostgreSQLExtras/CoreCollaborationPostgreSQLExtras.shserveradmin wiki start