Forgot a Postgres datbase name, can I search for all DBs?

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

Phil O'Dea

  • Posts: 18
  • Joined: Sun May 29, 2016 9:29 am
  • Location: London

Forgot a Postgres datbase name, can I search for all DBs?

PostThu May 31, 2018 1:57 pm

I disconnected for my Postgres database in Resolve 14 & started using disk database for a while. Now I'd like to go back & find my old Postgres database from before but I can't remember the exact name. Is there any way of searching for all the disconnected Postgres databases on my system?


Phil
Offline

Reynaud Venter

  • Posts: 6445
  • Joined: Sun May 28, 2017 9:34 am

Re: Forgot a Postgres datbase name, can I search for all DBs

PostThu May 31, 2018 2:14 pm

On OS X or Linux, use the Terminal to list all the current databases.

All databases should be listed unless you have previously specifically dropped any.
Last edited by Reynaud Venter on Sat Jun 02, 2018 9:35 pm, edited 1 time in total.
Offline

Phil O'Dea

  • Posts: 18
  • Joined: Sun May 29, 2016 9:29 am
  • Location: London

Re: Forgot a Postgres datbase name, can I search for all DBs

PostThu May 31, 2018 3:08 pm

Thanks for that but do you know how to find on Windows 10?


Sent from my iPhone using Tapatalk
Offline

Nathan Morgan

  • Posts: 608
  • Joined: Wed May 20, 2015 3:02 pm

Re: Forgot a Postgres datbase name, can I search for all DBs

PostThu May 31, 2018 3:18 pm

There is a program we run at my work, I think it is called pgadmin. It allows you to log into the DB and see all of the contents. We use it on Mac but I think there is a Windows version avalible too.

Also doesnt resolve ship with a database manager now too?

Sent from my Pixel 2 using Tapatalk
PC: Resolve 18.0.1, WINDOWS 10, GTX 3090
Desktop Video 12.0
(All bug reports etc. are PC unless specified.)
Mac: Mac Studio M1 Ultra, Resolve 18.0.1, 12.4
Offline

Phil O'Dea

  • Posts: 18
  • Joined: Sun May 29, 2016 9:29 am
  • Location: London

Re: Forgot a Postgres datbase name, can I search for all DBs

PostThu May 31, 2018 3:59 pm

Excellent!!

It actually was already installed when I loaded the project server software. Just had didn't know what it was for. Now I can see all my databases. Thanks Nathan, top man!

Cheers
Phil

Return to DaVinci Resolve

Who is online

Users browsing this forum: Google [Bot], id4alexey, RedRider14, ToyboxNick and 181 guests