PostgreSQL behind the scenes big picture

sriesch

Can somebody provide a big picture overall view of where/how PostgreSQL / DAZ Studio stores database data? 

For example, if I uninstall PostgreSQL, then reinstall it, my data is still there.  So uninstallation doesn't remove or reset the actual database itself, and I'm assuming rather that just removes the software used to interface with the data.   Where are the actual data and the tables kept?

Does the option in DAZ Studio to reset the database just delete rows out of the various tables, while retaining the actual empty tables?

Is there another way to actually remove the database completely (short of a fresh Windows installation) to truly reset it to factory defaults in case something went horribly wrong with it, if resetting the database is not already this option?

If it matters, these questions pertain to DS 4.8.

 

namffuak

I think this works in 4.8 - Edit -> Preferences then select CMS Settings. The Cluster Directory is the path to the database, Shut down Studio and delete the directory. The next time you start either Studio or DIM the Postgres code will recreate the empty (for the most part) database. It does populate the base DAZ definitions but there will be NO content. Then you can re-populate by importing metadata from our installed products.

Richard Haseltine

Open the Content Library option menu (lined button in the top corner or right-click the tab), select Content DB Maintenance, and check the Reset Database option. You can then use the Reimport Metadata to reimport product data, and any user data you have exported (using the same dialogue). Note that user data (categroisation of your own scenes and presets) that hasn't been exported will be lost; also note that you will have to "reinstall" any items installed using Connect - in theory it should see the fiels and just add them to the database but when I tried that seemed hit-and-miss.