PostgreSQL and Carrara
ncamp
Posts: 345
The new version of Studio has PostgreSQL to replace the old CMS database. My assumption is that Carrara users should not install this, since there is not an updated Carrara release to support the new database.
I've not seen anything in the other threads, have any of you heard / seen anything about it?
ncamp
Comments
I was going to ask the same question. Keep in mind it is Friday in the US, and we have a holiday coming up Monday, so it's a "long weekend"....I don't think I'll touch the new version until next week, just in case ;-P
Thanks for alerting me to this issue. I will avoid until the database issue is clarified.
Yeah, that also sounds like a don't-fail-to-miss for people who might already have PostgreSQL on their computers and don't want Daz's install to break something.
I already have installed the new Studio package - and there are (up to now) no problems with Carrara 8.5 P
I assume the new PostgreSQL substitutes the Content Manager for Studio but do not extinguish the old one for Carrara.
Hi ncamp,
I installed the updated CMS and Studio yesterday. I had a couple of issues afterwards, as I tried "to update database" which was on option in Studio under the CMS settings, thinking it would convert the old version to the new version. It spit out an error, so I wiped out the DB, and had it rebuilt. Once I did that, I launched Carrara 8.5, and it showed an error message in the Smart Content tab... so I rebooted, and now everything seems fine. PostgresSQL is just the database format and engine, and not the "interface" to Carrara (or Studio for that matter), as long as DAZ kept the CMS interface the same (which it looks like they did), the upgrade should be seamless to any application. I am thinking had I not blown away my db, and started and stopped the CMS while initially updating it, Carrara would have been fine. It is fine now thought... good luck!
Rich S.
Quoted over from another thread
Yes. Carrara 8.5 cannot communicate with the PostgreSQL CMS. If you use the smart content features in Carrara 8.5 that rely on metadata and the Valentina based CMS, you will want to hold off on installing this PostgreSQL package. When the PostgreSQL package is installed, Install Manager and DAZ Studio will both prefer to communicate with it... which means nothing you do in either application after installing PostgreSQL CMS will affect the Valentina CMS, and thus Carrara.
I know, the obvious next question. When? The answer to that question is... It isn't a simple undertaking and I will not "promise" a date, especially publicly, that I'm not absolutely positive we can/will meet - which would only be the development side of the equation anyway, and presumes that there are no major hiccups between now and then. We have a timeline that we are working against, but there is too much ground left to cover for me to be comfortable saying anything else at this point.
-Rob
Hmmm, I guess that means I am running both services. That sucks. I'll play around with it and post back here what I find. Looks like I may have to roll back to an older install....
Rich S.
Since Carrara hasn't been able to use the content database for months I don't feel bad about not seeing this and doing the update. Doubt it could break it any more. Funny: when I put in a ticket about the issue I was told the upcoming Daz Studio version would fix it.
Well, suspicion confirmed. I was running both the legacy CMS, and the new PostgresSQL one. Based on the above quote, I decided it was probably best to uninstall everything and reinstall. I thought that CMS was installed with Studio, so I used Add/Remove programs to remove both that, as well as Studio, and re-installed via Install Manager. This did NOT reinstall the CMS. In case anybody else does this, CMS is installed through Install Manager. So, remove the PostgresSQL CMS, Studio, and then Install Manager. Then download and reinstall Install Manager, and it will re-install the legacy CMS. If you don't use the Smart Content Pane anyway, doesn't matter either way. Thanks!
Rich S.
Well, suspicion confirmed. I was running both the legacy CMS, and the new PostgresSQL one. Based on the above quote, I decided it was probably best to uninstall everything and reinstall. I thought that CMS was installed with Studio, so I used Add/Remove programs to remove both that, as well as Studio, and re-installed via Install Manager. This did NOT reinstall the CMS. In case anybody else does this, CMS is installed through Install Manager. So, remove the PostgresSQL CMS, Studio, and then Install Manager. Then download and reinstall Install Manager, and it will re-install the legacy CMS. If you don't use the Smart Content Pane anyway, doesn't matter either way. Thanks!
Rich S.
Or you can just go to C:\Program Files (x86)\DAZ 3D\DAZ3DIM1\cms and run the installer there for the Valentina CMS.
I already whined about these databases in another thread and that was just using studio
looks like more fussing about coming my way :long:
trouble is it all affects .duf imports from studio too which is how I use genesis in carrara
I find myself using genesis less and less in carrara ( I do use it a lot in iClone)
and lately been using C8.1 a lot too!
I mostly use C8.5 just for FBX imports inc Genesis from iClone actually, unfortunately that route loses facial morphs or it would be my preferred option.
Via iClone it is simply a rigged mesh with no baggage
as a duf it has a whole lot of extra stuff with it such as all the morph/shaping options autofit info etc that carrara reads externally all which can cause an error any time
I know joint controlled morphs, facial expressions and things are lost but for simple animation not facial closeups I often find it so much easier as selecting it does not call up smart content which often freezes carrara or worse errors it for good, one reason I avoid that SMART content tab like the plague and otherwise import studio set up .duf's instead.
is a pity one cannot load just needed morphs the old way actually so they appear under general not parameters as this seems to be the issue, parameters references the database I think.
PostgreSQL...ugh!
Well, most of you know that I'm a Microsoft shill...SQL Express is free to bundle into applications and immensely powerful. :coolgrin:
Fortunately; I still refuse to use D|S. ;)
you do not need to install the new PostgreSQL
the new version of DS will work just fine with out it
so far Carrara is working just fine with the new DS
Grrr DAZ should learn to communicate better and upfront on such issues
And as every other microsoft product, it's Windows only.
I've been working with Databases since Reg800/ISAM800 in the mid 80's which later evolved into RegLisp and then mySQL (all written by Monthy), Sybase (before Microsoft spawned it's OEM version into MSSQL), Oracle, MySQL, OpenBase, PrimeBase, Valentina & Postgres and they all have pros and cons and postgres has a few very good pros, stability and data integrity.
Or you can just go to C:\Program Files (x86)\DAZ 3D\DAZ3DIM1\cms and run the installer there for the Valentina CMS.
Can someone please provide a step-by-step for uninstalling the new CMS and getting Valentina back? Or is it really that easy.
I take it the only downside to running two databases is that the old one will no longer be updated with newly added content. Is that correct? Any reason besides laziness not to uninstall PostgreSQL, if using both Studio & Carrara? I don't use Carrara often, but still. Two unsynchronized databases will confuse or frustrate me, eventually.
Can i just go back to the last version of Daz Studio that did not have the new SQL? I'm lost with out Carrara Pro. Nothing links or open now. I use it more the Poser.
All you need to do is to install the Valentina CMS and uninstall the postgres one as described above. DAZ Studio will use which one it finds.
Will do. Thank you!!
Daz not supporting it's own Pro app, say it ain't so :p
What I know it's just not fully implemented yet, in a stable fashion. As long as you keep the Valentina CMS until Carrara has support for it, which I think is not very far away you're all good to go.
Daz Soon ™ :smirk:
They will fix it. :) Just bad project timing on my part.