Knowledge Base/DAZ 3D Software/DAZ Studio

PostgreSQL FAQ

Cristina Galloway
posted this on June 19, 2014, 16:55

PostgreSQL CMS FAQ

What is CMS?
What's the difference between Valentina CMS and PostgreSQL CMS?
Why change from Valentina CMS to PostgreSQL CMS?
Do I have to switch?
Who should NOT install PostgreSQL CMS?
What are the benefits of PostgreSQL CMS?
What version of DAZ Studio is needed to use PostgreSQL?
What preparation is needed before installing PostgreSQL CMS?
What is PostgreSQL Conversion from Valentina CMS?
I didn't Export User Data before installing PostgreSQL! Is all my user data lost?
After installing PostgreSQL my Smart Content is messed up
What should I be careful of with the new PostgreSQL CMS?
What happens to Valentina CMS when I install PostgreSQL CMS?
How do I know if DIM/DS is using the PostgreSQL CMS or the Valentina CMS?

 

Q: What is CMS?
A: CMS stands for Content Management Service. It's a database which holds information about your content files. This allows DAZ Studio 4 and Carrara 8.5 to provide a number of added features to content, including:
--Smart Content, that knows what items work with other items, such as which figure clothing fits or what materials work on which items.
--Categories and Products, which lets you group content items differently without moving the actual files (which can cause content not to work if done incorrectly).
--Searching content
--Autofit between weight-mapped figures
--Labeling content as materials, shapes, actors, props, etc.
--Adding your own tags to content. 

Q: What's the difference between Valentina CMS and PostgreSQL CMS?
A: Valentina is the database server used by the original CMS. PostgreSQL is a different database server which was introduced in DAZ Studio 4.6.3.50.

Q: Why change from Valentina CMS to PostgreSQL CMS?
A: Over several years of use of Valentina by thousands of DS users, several issues have come up for many users. Database corruption has been a perennial problem for many users. Some users also dislike that Valentina CMS runs all the time, even when DIM (DAZ Install Manager), DS (DAZ Studio), and Carrara aren't running. After trying to solve these problems, DAZ 3D determined that switching to a different database server was the best solution.

Q: Do I have to switch?
A: No, you do not. If you don't install PostgreSQL CMS then DIM and DS will continue to use the Valentina CMS.

Q: Who should NOT install PostgreSQL CMS?
A: 2 groups of people should not install PostgreSQL CMS:
--Carrara 8.5 users: the current version of C 8.5 will only use the Valentina CMS.
--Zone Alarm users: Zone Alarm has a long history of not playing well with PostgreSQL, which has never been fixed.

Q: What are the benefits of PostgreSQL CMS?
A: PostgreSQL CMS has 3 advantages over Valentina CMS:
--It is far more stable.
--It only runs when DIM or DS is running.
--It is much faster if you have a 64-bit OS.

Q: What version of DAZ Studio is needed to use PostgreSQL?
A: 4.6.3.50 or higher

Q: What preparation is needed before installing PostgreSQL CMS?
A: If you have created any custom categories, metadata, or tags, and haven't Exported User Data yet, you should do so. If you only use the metadata that comes with DAZ products, you do not need to do this.

Q: What is PostgreSQL Conversion from Valentina CMS?
A: "Installing" this transfers the data from the Valentina CMS to the PostgreSQL CMS. It takes a while, as the "installation" is the actual transfer of the information. If it only takes a second, it probably didn't work. As noted, the biggest problem with the Valentina CMS was database corruption, which can cause the transfer to fail. This is why I recommended Exporting User Data before installing PostgreSQL.

Q: I didn't Export User Data before installing PostgreSQL! Is all my user data lost?
A: No, the Valentina database is left unchanged when you install PostgreSQL CMS. Just uninstall PostgreSQL CMS and you can launch DS, and it will use the Valentina CMS again so you can Export User Data.

Q: After installing PostgreSQL my Smart Content is messed up -- there's nothing there, or there's 2 of everything, or everything has a yellow triangle with an exclamation point and doesn't work.
A: These can all be caused by trying to convert a corrupt Valentina database. The easiest way to fix it is to reset the database and re-import metadata.
To Reset the Database Right click on the Content Library pane, choose Content DB Maintenance, tick Reset Database, click Accept.
To Reimport Metadata Right click on the Content Library pane, choose Content DB Maintenance, tick Re-Import Metadata, click Accept. Tick User Data and All Products and click Accept.

Q: What should I be careful of with the new PostgreSQL CMS?
A: Since PostgreSQL CMS only runs when DIM (DAZ Install Manager) or DS (DAZ Studio) is running, if either of them is running and you shut it down, it will tell PostgreSQL CMS to shut down also. If you start the other before that step is complete, it's possible for PostgreSQL to be shut down. You'll have no Smart Content and Categories and Products won't appear at all in the Content Library. If this happens, shut down DIM and DS and wait a minute to make sure the "stop PostgreSQL" step is complete.

Q: What happens to Valentina CMS when I install PostgreSQL CMS?
A: Valentina CMS will not be uninstalled and its database will be left untouched. This won't cause problems -- if PostgreSQL CMS is installed, DIM and DS will use it even if Valentina CMS is also running at the same time. Therefore any new content you install or new user data you create will be added to the PostgreSQL database and not to the Valentina database. If you wish to uninstall Valentina CMS you may do so, but it is not required.

Q: How do I know if DIM/DS is using the PostgreSQL CMS or the Valentina CMS?
A: In the log file for both DS and DIM there will be a line that says:
"Connected to CMS: PostgreSQL 9.3.4" if PostgreSQL is being used, or
"Connected to CMS: 4.8" if Valentina is being used.
To view the DAZ Studio log, go to Help -> Troubleshooting -> View Log
In addition, Windows Task Manager will show about 7 instances of postgres.exe under Processes when DIM or DS is running. 

-- Written by Michael Miller

 
Topic is closed for comments