Search found 77 matches

by gcurrie
11 Feb 19 22:21
Forum: Photo Supreme
Topic: [resolved] Backup problems PostgreSQL 10
Replies: 3
Views: 142

Re: [resolved] Backup problems PostgreSQL 10

Any possibility you could tell us all and help someone avoid a similar situation?
by gcurrie
11 Feb 19 22:19
Forum: Photo Supreme
Topic: Postgres11 - thoughts?
Replies: 2
Views: 134

Re: Postgres11 - thoughts?

I'm still on 9.6 with Photo Supreme. I was wondering if 10 had any advantage. Now there is 11???
by gcurrie
06 Feb 18 21:41
Forum: Photo Supreme
Topic: Version 4 - Oh Dear.
Replies: 10
Views: 1840

Re: Version 4 - Oh Dear.

Other than an aversion to 32 bit, what's the problem here?
by gcurrie
11 Aug 17 6:46
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

Re: How to use DataExchange tool properly?

Well second time was a charm. V3 and PostgreSQL result in a welcome speed boost and robust feeling.
by gcurrie
11 Aug 17 2:01
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

Re: How to use DataExchange tool properly?

After 2 hours, error: An error occurred while applying the updates in a record: TPostgreSQLConnection: Execution of query failed (PostgreSQL:ERROR out of memory DETAIL: Failed on request of size 122880. Severity: ERROR SQL State: 53200 Primary Error: out of memory Error Detail: Failed on request of ...
by gcurrie
10 Aug 17 23:32
Forum: Photo Supreme
Topic: Changes to PostgreSQL install guide needed
Replies: 0
Views: 1814

Changes to PostgreSQL install guide needed

The QuickInstall guide for PSU PostgreSQL (http://www.idimager.com/trial/QuickInstall-PostgreSQL9-PhotoSupreme.pdf) is a little out of date. It describes using pg_admin III, but that program is no longer available. The new one (pg_admin 4) no longer offers the ability to edit settings in the conf fi...
by gcurrie
10 Aug 17 23:28
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

Re: How to use DataExchange tool properly?

Reading your reply, it looks like you said exactly what I am doing.

So as soon as it is done upgrading to v3, I will run the data exchange tool again.
by gcurrie
10 Aug 17 23:12
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

Re: How to use DataExchange tool properly?

Ah. I think I get it. I have PSU SQL Server v2 and PSU PostgreSQL v3. So, if I understand correctly, I need to: 1. Update my existing client apps to PSU SQL Server v3. 2. Connect a client to the database to upgrade it to v3. 3. Now run data migration tool to convert database from SQL Server to Posgr...
by gcurrie
10 Aug 17 22:27
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

Re: How to use DataExchange tool properly?

I went ahead and installed PhotoSupreme PostgreSQL, created an initial database (catalog) on the server called photosupreme (default behavior). However, PhotoSupreme prompted me to select the version of PostgreSQL. The choices only went as high as 9.5, which I selected. My server install is 9.6.4. N...
by gcurrie
10 Aug 17 22:03
Forum: Photo Supreme
Topic: How to use DataExchange tool properly?
Replies: 6
Views: 1825

How to use DataExchange tool properly?

I'm migrating a SQL Server Express 2012 based install (client/server) to a PostgreSQL 9.6 install (client/server). It appears the PhotoSupremeDataExchange tool will somehow convert the database. However, I have not found any documentation. Obviously I already have the photosupreme database on SQL Se...
by gcurrie
15 Aug 14 23:04
Forum: Photo Supreme
Topic: Any reasons to move from SQL Server to PostgreSQL?
Replies: 1
Views: 1104

Any reasons to move from SQL Server to PostgreSQL?

I've been running on the multi-user SQL Server version of IDI and now Photo Supreme. It's great to be able to access the catalog with different users and machines. (I actually run it on a Windows server - not locally.) Although I'm somewhat comfortable with SQL Server, the free Express edition has a...
by gcurrie
01 Aug 14 18:49
Forum: Photo Supreme
Topic: Multiple catalogs with PhotoSupreme SQL
Replies: 4
Views: 2268

Re: Multiple catalogs with PhotoSupreme SQL

Sweet! :D

Thanks for answering this, Hert. I guess this is something few people are doing right now.

P.S. Now get back to work on v3! :twisted: Looking forward to even more goodness.
by gcurrie
01 Aug 14 4:18
Forum: Photo Supreme
Topic: Newb: Suggested workflow with separate Raw converter
Replies: 3
Views: 2250

Re: Newb: Suggested workflow with separate Raw converter

I would add another option for your workflow, depending on how often you go back and process your RAW files. When I used the predecessor to PS (IdImager Pro), I ingested the original RAW file (processed with Canon Digital Photo Pro), a TIFF file created from the processed RAW file, and then created ...
by gcurrie
26 Mar 14 1:59
Forum: Photo Supreme
Topic: SQL version-How to reduce size of thumbs db?
Replies: 4
Views: 2103

Re: SQL version-How to reduce size of thumbs db?

Michael: Thanks for the suggestions, but they did not help. Hert: FYI, the script to clear the thumbnail db did nothing. SQL Server Express seems to basically ignore any command for a database that is over the limit. However, I was able to get into SQL Server Management Studio and once there, I was ...
by gcurrie
25 Mar 14 6:17
Forum: Photo Supreme
Topic: SQL version-How to reduce size of thumbs db?
Replies: 4
Views: 2103

SQL version-How to reduce size of thumbs db?

I have 30,000 images, and with versions I have 65000 files in Photo Supreme SQL Server. I was looking in my SQL 2012 Management Studio app, and noticed that the thumbs database was over 10 GB. The limit for SQL Server Express is 10 GB. I looked in the server logs and found this: Could not allocate s...