Failed to create database when connecting to external DB

Hi I'm a developer at company where we are trying to connect multiple people that are not in same network to same shared postgresSQL database. I've done extensive research but still struggle with this task.

Editors are using Davinci Resolve v16 so I'm installing postgresSQL 9.5.4.

We've managed to set up postgres DB on AWS. Davinci Resolve can make connection but when it starts creating the database it get's to about 17% on progress bar and then error

Failed to create datatabase: EROROR: current transaction is aborted, commands ignored until end of transaction block (25PO2) QPSQL: Unable to create query

If I connect database with from database client I see that given database was created with tables

Code: Select all

BtClipProcParams,BtPathInfo,BtPathInfo_Folder_T,BtThumnail,database_upgrade_log,Folder_T,Folder_T_MatteMap,FontRenderItem,FontRenderItem_FontRenderItemVec,FontRenderItemVec,Gallery::GyGallery,Gallery::GyGallery_Gallery::GyView,Gallery::GyMemView,Gallery::GyMemView_Gallery::GyStillRef,Gallery::GyStill,Gallery::GyStill_trashbin,Gallery::GyStillRef,Gallery::GyStillRef_Gallery::GyView,Gallery::GyView,ListMgt::LmVersion,ListMgt::LmVersion_ListMgt::LmVersionTable,ListMgt::LmVersionTable,ListMgt::LmVersionTable_ListMgt::LmVersionTable,SM_AudioSettings,SM_BlankingPresets,SM_Clip,SM_Clip_FilterEffects,SM_Clip_SM_VideoTrack,SM_Clip_SmRevivalTask,SM_Config,SM_ConformConfig,SM_DeliverableSetup,SM_Effect,SM_Group,SM_Group_SM_GroupList,SM_GroupList,SM_ImpresarioScheme,SM_Log,SM_PanelSensitivity,SM_PanelSetup,SM_Project,SM_Project_FolderMap,SM_Project_SM_Session,SM_Project_SmClipPathOption,SM_Ptzr,SM_SafeAreaPresets,SM_Session,SM_Session_SM_VideoTrack,SM_Setup,SM_TransitionItem,SM_TransitionItem_SM_VideoTrack,SM_User,SM_UserSetup,SM_VideoTrack,SM_VideoTrack_MatteClips,SM_VTRConfiguration,SM_VTRInputSettings,SM_VTROutputSettings,SmClipPathOption,SmPreset,SmProjPTZRPresetMgr,SmProjPTZRPresetMgr_IDPresetPtrMap,SmProjTZRPresetKey,SmPTZRPresetList,SmPTZRPresetList_SmPreset,SmRevivalTask,SmSpeedProfile,SyConfig,SyRecordInfo

but any attempt to connect to it from DR ends with

New database cannot be created. Database "ips_test" is in use

I know there is option to use Davince Resolve Project Server software but given our requirements I'd much rather skip that. But to me it seems that Project Server does some sort of necessary setup.

Any help/guidence appreciated.

trying to connect multiple people that are not in same network

I'm definitely not the export here, but...that may be the problem.

To the best of my knowledge, this was designed to work with everyone using the same version of Resolve on the same LAN.

trying to connect multiple people that are not in same network

I'm definitely not the export here, but...that may be the problem.

To the best of my knowledge, this was designed to work with everyone using the same version of Resolve on the same LAN.

From technical point of view it's the same thing. There is no difference if you connect to database locally or external IP. The reason it's meant for LAN is the latency which could make working with DR very bad experience. At least that's how i get it so far. There are plenty of cases online where people install Project Server in LAN, then exposes port 5432 through firewall for specific IP and use VPN to connect from home from that IP. So it's possible.

What I'm interested is debuging particular error so I could continue with setup. If Project Server does some sort of database initialisation that DR can't then I'd need those steps to do them on my DB. (Again from this same forum I've concluded that Project Server is just sugar to make things easier but technically manually installed postgresSQL instance can be used. But then the question - how does Project Server "makes it easier"? Cause it's super easy to create postgresSQL instance an connect to it.)

Hi Kārlis,

I know this is a VERY long shot, but you can take a look at this thread: https://forum.blackmagicdesign.com/viewtopic.php?f=36&t=131547
I know that it does not make any sense to solve your problem, but... Who knows - give it a try.