[Solved] 17.2.2 and PostgreSQL: no connection possible

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

BartReynaard

  • Posts: 454
  • Joined: Thu Jul 08, 2021 8:31 pm
  • Real Name: Bart

[Solved] 17.2.2 and PostgreSQL: no connection possible

PostThu Jul 29, 2021 11:19 am

After having few failures with Postgres 13, and have seen some video about the same issue and have read some post here on this forum, I fully uninstalled DaVinci Studio 17.2.2 and reinstalled it to see if ever asks me to install Postgres.
No way out. No this choice

So I installed it again
Then I installed PostgreSQL 13 again.

I created a Database,n assigned the main user 'postgres'.
Address is localhost (being on the same PC)
password, is the one of the user postgres.

Postgres service is running

When I try to make talk DaVinci with Postgres: no way out.
Please you find the screenshot of the window.

System: Windows 10 Pro
postgreSQL: 13
DaVinci Studio: 17.2.2
Attachments
Capture.PNG
Isse while trying to connect PostgreSQL
Capture.PNG (10.46 KiB) Viewed 668 times
Last edited by BartReynaard on Fri Oct 22, 2021 6:36 pm, edited 2 times in total.
Bart
________
DaVinci Resolve Studio 18.6.5 on Windows 11 Pro 23H2

Prod. Machine: Ryzen 7 64GB 3.54 GHz
Video: MSI GeForce 4060Ti 16GB
Monitors: 1 x 3840x1440 widescreen, 2 x 1920 x 1080 16:9
Audio: Behringer UMC1820
Blackmagic Speed Editor
Offline

peterjackson

  • Posts: 1144
  • Joined: Sat Aug 18, 2018 7:12 pm
  • Real Name: Peter Jackson

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 12:05 pm

You need to create the user and pass Resolve expects. I don't remember what it is, DaVinci or something. Localhost may also not imply TCP, which I believe it needs. Go to some other machine where it works and do pg_dump_all -- globals to figure what it wants.
5950x, 3090, 128GB.
Offline

BartReynaard

  • Posts: 454
  • Joined: Thu Jul 08, 2021 8:31 pm
  • Real Name: Bart

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 12:11 pm

peterjackson wrote:You need to create the user and pass Resolve expects. I don't remember what it is, DaVinci or something. Localhost may also not imply TCP, which I believe it needs. Go to some other machine where it works and do pg_dump_all -- globals to figure what it wants.


Few minutes ago I also tried to create an user 'DaVinci' instead of 'postgres' and a banal password just to try 'DaVinci' which is the default.
I also tried to give '127.0.0.1' instead of 'localhost'.
(P.S. all without quotes of course)

I got the same window :-/
Bart
________
DaVinci Resolve Studio 18.6.5 on Windows 11 Pro 23H2

Prod. Machine: Ryzen 7 64GB 3.54 GHz
Video: MSI GeForce 4060Ti 16GB
Monitors: 1 x 3840x1440 widescreen, 2 x 1920 x 1080 16:9
Audio: Behringer UMC1820
Blackmagic Speed Editor
Offline

peterjackson

  • Posts: 1144
  • Joined: Sat Aug 18, 2018 7:12 pm
  • Real Name: Peter Jackson

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 1:25 pm

Search these forums for the credentials expected and/or set auth to trust in pg hba.conf
5950x, 3090, 128GB.
Offline

peterjackson

  • Posts: 1144
  • Joined: Sat Aug 18, 2018 7:12 pm
  • Real Name: Peter Jackson

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 1:30 pm

Seems it wants User postgres password DaVinci
5950x, 3090, 128GB.
Offline

BartReynaard

  • Posts: 454
  • Joined: Thu Jul 08, 2021 8:31 pm
  • Real Name: Bart

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 2:46 pm

peterjackson wrote:Seems it wants User postgres password DaVinci


Indeed I create an user

CREATE USER davinci WITH PASSWORD 'DaVinci';

Just to keep it simple

In the small DaVinci Resolve window I setup:

Name: newdatabase
Location: 127.0.0.1 (I tried also "localhost" but it doesn't change)
Username: davinci
Password: DaVinci


but nothing to do.
Bart
________
DaVinci Resolve Studio 18.6.5 on Windows 11 Pro 23H2

Prod. Machine: Ryzen 7 64GB 3.54 GHz
Video: MSI GeForce 4060Ti 16GB
Monitors: 1 x 3840x1440 widescreen, 2 x 1920 x 1080 16:9
Audio: Behringer UMC1820
Blackmagic Speed Editor
Offline

BartReynaard

  • Posts: 454
  • Joined: Thu Jul 08, 2021 8:31 pm
  • Real Name: Bart

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 4:40 pm

peterjackson wrote:Seems it wants User postgres password DaVinci


I found the solution
https://stackoverflow.com/questions/642 ... not-suppor

BUT now still opened the bug highlighted here (and never solved). here below the link to that post at the very end there is the screenshot of the issue I got right now.

https://forum.blackmagicdesign.com/viewtopic.php?f=21&t=123091

EDIT: here below the 2 windows appearing
Attachments
2.PNG
2nd window
2.PNG (16 KiB) Viewed 496 times
1.PNG
1st window
1.PNG (14.92 KiB) Viewed 496 times
Bart
________
DaVinci Resolve Studio 18.6.5 on Windows 11 Pro 23H2

Prod. Machine: Ryzen 7 64GB 3.54 GHz
Video: MSI GeForce 4060Ti 16GB
Monitors: 1 x 3840x1440 widescreen, 2 x 1920 x 1080 16:9
Audio: Behringer UMC1820
Blackmagic Speed Editor
Offline

BartReynaard

  • Posts: 454
  • Joined: Thu Jul 08, 2021 8:31 pm
  • Real Name: Bart

Re: DaVinci Studio 17.2.2 and POstgreSQL: no connection poss

PostThu Jul 29, 2021 5:56 pm

SOLVED:

the version of PostgreSQL. DaVinci is NOT compatible with versions higher than 11.12-2.

I could migrate the templates from the Sqlite 3 dB (standard files) to the postgreSQL just copying and paste them from the Project Manager. Great!
Bart
________
DaVinci Resolve Studio 18.6.5 on Windows 11 Pro 23H2

Prod. Machine: Ryzen 7 64GB 3.54 GHz
Video: MSI GeForce 4060Ti 16GB
Monitors: 1 x 3840x1440 widescreen, 2 x 1920 x 1080 16:9
Audio: Behringer UMC1820
Blackmagic Speed Editor

Return to DaVinci Resolve

Who is online

Users browsing this forum: 4EvrYng, Bing [Bot], cyberphile, doo.li_, peeceful and 156 guests