Author Topic: PostgreSQL configuration  (Read 3034 times)

0 Members and 1 Guest are viewing this topic.

jlarke

  • Member
  • **
  • Posts: 3
    • View Profile
PostgreSQL configuration
« on: 2013-09-18 16:45:29 »
Does anyone have v9 working with PostgreSQL? I've been unable to get it to work and Cerious haven't responded to my bug report since I submitted it on 6/30.

I can create the DB using the latest script on Cerious' web site, and the ODBC DSN test completes successfully, but ThumbsPlus always reports that it's not a ThumbsPlus database.

mschnell

  • Full Member
  • ***
  • Posts: 98
    • View Profile
PostgreSQL configuration
« Reply #1 on: 2013-10-13 07:53:52 »
I remember that I once did get TP working on a Postgres database (just for testing)

I needed to install a postgres plugin for handling a certain file type (AFAIK: string).

-Michael

jlarke

  • Member
  • **
  • Posts: 3
    • View Profile
PostgreSQL configuration
« Reply #2 on: 2013-10-13 11:35:37 »
Hrm. The scheme loads in PostgreSQL without any errors, so I don't think string is the current problems. The issues I've seen all relate to the fact that PG is case-sensitive and ThumbsPlus is not consistent in its capitalization. Do you remember anything else about what you did, and what the TP version was?

mschnell

  • Full Member
  • ***
  • Posts: 98
    • View Profile
PostgreSQL configuration
« Reply #3 on: 2013-10-13 17:57:51 »
It was TP7.

(I do have TP9, as well, but I will (some day) first convert to a C/S database and then to TP9. )

AFAIR;:

I tried to run the script provided by Cerious, but faile due to the said issue.

I installed the plugin.

I successfully ran the script.

After this it did work as expected.

-Michael