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 ...
Search found 9 matches
- 30 Jan 15 12:12
- Forum: Photo Supreme
- Topic: PhotoSupreme Server using Amazon RDS PostgreSQL?
- Replies: 15
- Views: 11126
- 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 ...
The only reference I can find to something that can store thumbnail information is the abovementioned table "idthumbs"; however a sole ...
- 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 ...
/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 ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
I dug around under resources, but couldn't find a script to create idimager_main -- it appears to be done in the ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
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 ...