Search found 9 matches

by eqbridges
30 Jan 15 12:12
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

Hi Hert,

Just to clarify, I'm attempting to troubleshoot an issue where image thumbnails are not appearing when I host the catalog on an RDS instance of Postgres. The answers I'm getting thus far are getting me confused.


should 'idthumbs' be in the "photosupreme" database ("database" in an ...
by eqbridges
30 Jan 15 1:26
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

Hert, thanks for the reply. Can you please clarify the assumptions I'm making? You refer to a "thumbs database", however it is not clear what you mean by that.

The only reference I can find to something that can store thumbnail information is the abovementioned table "idthumbs"; however a sole ...
by eqbridges
29 Jan 15 12:05
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

I ran the following two scripts after creating the database instance:

/Applications/Photo Supreme.app/Contents/Resources/sqlscripts/postgresql9_ididb.sql
/Applications/Photo Supreme.app/Contents/Resources/sqlscripts/postgresql9_tmbdb.sql

I assume the second one (which creates the "idthumbs ...
by eqbridges
26 Jan 15 1:49
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

Hi Hert,

After having to work on some other stuff briefly, I got this all working (see the updated notes in the GitHub repo noted above) against my archive of 75k images.

PhotoSupreme starts up fine, and it lists all of the images across all of the folders in my archive. However, thumbnails are ...
by eqbridges
06 Jan 15 5:06
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

I followed these steps:

created a PostgreSQL RDS instance on Amazon (1)
created an idimager_main user manually with only the "CREATEDB" permission
ran the two scripts for building the schema (postgresql9_ididb.sql, postgresql9_tmbdb.sql -- obtained from "/Applications/Photo Supreme.app/Contents ...
by eqbridges
05 Jan 15 0:44
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

Re: PhotoSupreme Server using Amazon RDS PostgreSQL?

While I'm not a DBA, I've worked with PostgreSQL as a software developer on various projects since v7.2. I'd be glad to spend an hour or so tweaking the permissions to see what may work.

I dug around under resources, but couldn't find a script to create idimager_main -- it appears to be done in the ...
by eqbridges
04 Jan 15 21:44
Forum: Photo Supreme
Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
Replies: 15
Views: 11126

PhotoSupreme Server using Amazon RDS PostgreSQL?

Hi,

I would like to use Amazon's RDS PostgreSQL service for hosting Photo Supreme's catalog. But have run into this error:


Severity: ERROR
SQL State: 42501
Primary Error: must be superuser to create superusers


It appears that PhotoSupreme tries to create a user with 'superuser' privileges (I ...
by eqbridges
01 Jan 15 3:29
Forum: Photo Supreme
Topic: Photo Supreme background info?
Replies: 6
Views: 4096

Re: Photo Supreme background info?

Thanks for the warm welcome, all. It's much appreciated!

I am very impressed by the product, the long history and quality of the product is evident in the application itself. I found it really easy to get started with, and it is one of the few products that dealt easily with 75k images stored on a ...
by eqbridges
30 Dec 14 14:20
Forum: Photo Supreme
Topic: Photo Supreme background info?
Replies: 6
Views: 4096

Photo Supreme background info?

Hi,

I'm really excited to use Photo Supreme -- it's an application that I've been looking for over a long time!

I was curious about some of the background history of the application -- who makes it? where is it produced from? why was it created originally? I can't locate any info online about that ...