Search found 78 matches

by gcurrie
05 Apr 19 2:12
Forum: Photo Supreme
Topic: PostgreSQL upgrade in place?
Replies: 1
Views: 131

PostgreSQL upgrade in place?

When I first installed PostgreSQL (in order to run PSU Server edition), I chose version 9.6 as that was the latest that PSU worked with. Now I see version 10 available for some time, and 11 has been released (but PSU doesn't yet work with it). Is there any way to UPDATE the version of PostgreSQL run...
by gcurrie
11 Feb 19 22:21
Forum: Photo Supreme
Topic: [resolved] Backup problems PostgreSQL 10
Replies: 3
Views: 214

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: 168

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: 1971

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: 1868

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: 1868

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: 1850

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: 1868

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: 1868

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: 1868

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: 1868

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: 1123

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: 2295

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: 2289

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: 2136

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 ...