Search found 83 matches

by rdv4rjm
09 Jun 19 22:03
Forum: Photo Supreme
Topic: PostgreSQL versus Microsoft SQL Server
Replies: 0
Views: 38

PostgreSQL versus Microsoft SQL Server

Any one has experience as to which performs better on Windows Platform: PostgreSQL or Microsoft SQL Server. Facing heavy latency on Server running Windows, OS as well as Photos on SSDs. My only satisfying experience so far was with Macpro. Surprisingly, this High performance server is unable to outp...
by rdv4rjm
01 Jun 19 17:59
Forum: Photo Supreme
Topic: Windows / Postgresql
Replies: 1
Views: 62

Windows / Postgresql

Using PSU with Macpro since I started with it. Just about to migrate to Windows installation as server, PostgreSQL. Behaviour is different. Wondering if users running PSU server/Windows combination have same experience. On Mac, If a keyword if added or removed to some photos, status bar will show fi...
by rdv4rjm
01 Jun 19 9:14
Forum: Photo Supreme
Topic: New Catalog
Replies: 2
Views: 92

Re: New Catalog

Thanks Hert!
by rdv4rjm
01 Jun 19 1:59
Forum: Photo Supreme
Topic: Postgresql not starting
Replies: 2
Views: 95

Re: Postgresql not starting

Many reference to pg_restxlog which file is inexistant on this computer. Some pretend pg_restxlog has been changed to pg_resetwal; was not able to find its location. ---- Applied Time machine on: VAR folder POSTGRES folder Postgres App pgAdmin4 App Choose date 2 days earlier than when fault happened...
by rdv4rjm
31 May 19 1:45
Forum: Photo Supreme
Topic: New Catalog
Replies: 2
Views: 92

New Catalog

Lost contact with catalog server Uninstalled PostgreSQL, and PSU Reinstalled PostgreSQL 10 Now I want to create a new catalog. Reinstalled Photosupreme Once PSU installed once on a computer, by default, PSU only gives you choice to access an already created calalog. Option to create a new catalog is...
by rdv4rjm
30 May 19 18:25
Forum: Photo Supreme
Topic: Postgresql not starting
Replies: 2
Views: 95

Postgresql not starting

I messed up the database and had to restore with Timemachine. ( I am using a Macpro 2009). I backup up to the day I know everything was working fine. Now, Postgres10 doesn't start. I uploaded the log file. At one point a message made me stop, it said I could loose the database. Would anyone know how...
by rdv4rjm
17 May 19 21:00
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Re: Catalog Migration

Here they are
by rdv4rjm
17 May 19 21:00
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Re: Catalog Migration

This is how I proceeded based on my understanding of proposed method. 1- I backup up database with following command: pg_dump -U {user-name} {source_db} -f {dumpfilename.sql} pg_dump -U postgres photosupreme -f photosupreme.sql I suppose this backed up photosupreme and photosupreme_thumbs database a...
by rdv4rjm
17 May 19 16:42
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Re: Catalog Migration

Makes sens. Since I backed up using dumpall command, and now restoring to a specific database name, it's as if I am trying to include all postgres databases from source machine to a single database on destination machine. Backup: $ pg_dump -U {user-name} {source_db} -f {dumpfilename.sql} Restore: $ ...
by rdv4rjm
17 May 19 6:52
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Re: Catalog Migration

Thanks Hert! I want to simulate migrating the catalog. I am using VMs on which I tested PhotoSupreme. OS are Windows for server as well as for workstation. A first for me. As of now, server is operating on a Macpro. With checkpoints on VMs, testing is easy and quick. At any point in time we can make...
by rdv4rjm
15 May 19 21:21
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Re: Catalog Migration

Sorry for this.
I edited my post instead.
by rdv4rjm
15 May 19 18:46
Forum: Photo Supreme
Topic: Catalog Migration
Replies: 8
Views: 354

Catalog Migration

Soon, I'll be migrating my catalog from a Macpro to a HP Dl380. Is there a tool for such operation? I answered this question myself after trying different methods. There might be a better way, but here's how I ended up doing it my way. Might be helpful anyhow. 1) First I used the Catalog Database Re...
by rdv4rjm
08 May 19 7:15
Forum: Photo Supreme
Topic: PGADMIN 4
Replies: 1
Views: 107

Re: PGADMIN 4

I could have deleted previous post, but it might be useful to someone, some day. Installation was make upon Windows Server 2019 Desktop Experience, on a VM in Hyper-V 2019. So far this version is very stable, but when it comes to Postgres, it requires deeper configurations. I backed out of it and tr...
by rdv4rjm
08 May 19 5:42
Forum: Photo Supreme
Topic: PGADMIN 4
Replies: 1
Views: 107

PGADMIN 4

Hi, Installing PSU server edition, Windows version. PgAdmin keeps updating from year to year. It Seemed simpler to program before. Postgres 10.7 installed, PSU server edition installed Files: pg-hba_conf, and PostgreSQL.conf, configured as stated in instruction manual. Created database from PSU on l...
by rdv4rjm
10 Mar 19 8:02
Forum: Photo Supreme
Topic: 1 gbps
Replies: 4
Views: 242

Re: 1 gbps

Thank you, everyone, for your suggestions and for sharing your experience.
It confirms my opinion which I will share with my staff.