How do you install PostgreSQL
mlolya
Posts: 36
I got a new computer and installed the latest version of Daz and moved my library over. All of my files are in the Content Library but not in the Smart Library. I've been told to install PostgreSQL, but I have no idea what that is, where to find it or how to install it. Any suggestions?
Daz 3D is part of 
Connect
DAZ Productions, Inc.
7533 S Center View Ct #4664
West Jordan, UT 84084
Licensing Agreement | Terms of Service | Privacy Policy | EULA
© 2026 Daz Productions Inc. All Rights Reserved.
Comments
You can install PostgreSQL the same way you installed D/S. [via DIM, DC or Manually]
It's part of the D/S bundle and has its page in your Product Library here: https://www.daz3d.com/downloader/customer/files#prod_18869
If downloading manually, the .exe is for Windows, the zip is for Mac.
You can do a search in each of DIM or your content library in your account, depending on how you are installing your content.
How did you move your library over? If you just copied the files and folders than that would not have restored the Smart Content. PostresSQL is usually installed alongside Daz Studio and so there is a chance that you do have it installed - indeed I believe that you would get an error message on Daz Studio startup if PostresSQL was either uninstalled or was not auto-launched.
If that is the case you may just need to re-import the metadata which is easily done via the Content Manager and "Re-import Metadata". Note: once you get past the window with all your products and checkboxes the actual import can take over 10 minutes depending on your hardware and amount of products.
Thank you all for your help!
I have tried to follow every one of the answers on the web and on this site. I still can't get the postgreSQL to work. This has been a problem with DAZ for years. Why can't they fix it. OK - asking for step by help in human terms - please.
I downloaded the PostgreSQL.exe file from DAZ. I installed it and it installed in the C:/program directory. So, I evidently have it on my machine. It does not show up as a running program in my Task Manager.
I now bring up DAZ3D. In the Edit/Preferences/CMS setttings tab, it shows a field for the location of the PostgreSQL, but nothing can be typed in there, so I can't let the program know where the PostgreSQL files are. There is a field under that, called Cluster, that has the correct location. Over to the right is a button called Start. I started it.
Now, I bring up DAZ and in the Smart Content window IT says Start CMS. I click it. Nothing. I still don't have my smart content.
My installation of MY Daz3d Library is on the E: disk, but as I understand it, that shouldn't matter. The files for all my Daz content are too much for the C: disk.
Can anyone help? So far, every "help" sends me to places that don't exist on the latest version or now have a different name. I have version 4.24 (the latest). If anyone has that version (everyone should) and can guide me step-through-sep on how to set up the PostgreSQL, I would be in forever gratitude. It shouldn't be this hard.
In general it is working and there is nothing for Daz to fix, the issues are usually security software/settings or other system-speicific issues (such as folder permissions)
It is a back ground process, when DS (or DIM) is running. You canb show it in Task manager, but you need to enable the More Details option at bottom-left.
The field is for the database, which you populate using the ... button - ContentCluster is what postgreSQL calls its database location.
If PostgreSQL was started using the button in preferences I would expect it to be showing as started in the Smart Content pane, with the button saying Stop.
If it is working now, but PostgreSQL wasn't installed when you installed the content, or if you installed manually, then the details won't have been entered into the database. You can reimport metadata to fix this - right-click on the Content Library or Smart Content pane tab and select Content DB Maintenance, check Reimport Metadata and click Accept, then in the next diualogue seelct all products using the master checkbox, click Accept, and let it run.
As the second post suggests, install PostgreSQL the same way you installed DAZ Studio. If you used DIM for Studio, use DIM for PostgreSQL. There might be some configuration info needed to operate together, but there is no reason they should be different. PostgreSQL should start up when starting Studio and/or DIM, not by itself, and shuts down all running instances once both Studio and DIM are closed.
The Preferences tab for CMS settings allows you to enter a path to the database by clicking the ellipsis at the right, between the down arrow and the Stop button. The location should be (for Windows) "C:/Users/[username]/AppData/Roaming/DAZ 3D/cms", and the default port 17237.
I tried all of the above (before NorthOf45's post) and followed it all to the letter. None of it worked. But NorthOf45's post led me to the following:
1. I went to Preferences/CMS settings and, using the elipsis to the right of the Cluster field, I typed in C:/Users/[username]/AppData/Roaming/DAZ 3D/cms as NorthOf45 instructed.
2. I closed out Daz Studio.
3. I opened DIM and left clicked on the system gear (upper right corner) Selected Basic settings.
4. That brought up the window of the basic locations:
5. I selected the option for Content Database Base and entered the same location as in preferences: C:/Users/[username]/AppData/Roaming/DAZ 3D/cms. and accept.
6. I then found PostgreSQL in the Installed list and left clicked on the elipsis to the right. That brought up options.
7. I selected the option: Reinstall the "PostgreSQL CMS (Win 64-bit)" Package and gave it time to reinstall them (about 3 minutes)
8. I closed out DIM.
9. I then brought Studeo back up again.
10. I right clicked on the Smart Content tab and selected Content DB mantenance, then the Reimport metadata option and hit the accept button.
I now have a working CMS
Many thanks to NorthOf45 for the information that actually worked. Many, many, many gold stars to you.
Great! I had made a few assumptions there, and I totally overlooked the CMS settings in DIM, also. The rest you figured out for yourself. Well done.