Search found 95 matches

by rdv4rjm
01 Jun 19 1:59
Forum: Photo Supreme
Topic: Postgresql not starting
Replies: 2
Views: 597

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

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

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: 10
Views: 2639

Re: Catalog Migration

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

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: 10
Views: 2639

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: 10
Views: 2639

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: 10
Views: 2639

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: 10
Views: 2639

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

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

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

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.
by rdv4rjm
05 Mar 19 8:10
Forum: Photo Supreme
Topic: 1 gbps
Replies: 4
Views: 715

1 gbps

I was asked today if PSU would actually work fluedly on a 1 gbps network, over a cat5e cable? Lets word it otherwise. On an ideal network system where server would be an HPE Dl-380, Switch an Aruba 5406r (idealy programmed by experimented IT) and storage a san Hpe MAS 2050 loaded with Ssd drives (no...
by rdv4rjm
14 Feb 19 9:36
Forum: Photo Supreme
Topic: Frequent freezes while doing folder management - Mac
Replies: 27
Views: 6660

Re: Frequent freezes while doing folder management - Mac

I had lots of freezing behaviour with Macpro 2009 until I upgraded from 32gb ram to 128gb. One day I saw all 32gb used up! I may have gone overboard, but it shows how fed up I was. Since I increased memory, PSU quit sending error messages. When PSU isn't responding, I know operation is undergoing in...
by rdv4rjm
14 Feb 19 9:19
Forum: Photo Supreme
Topic: [resolved] Backup problems PostgreSQL 10
Replies: 3
Views: 690

Re: [resolved] Backup problems PostgreSQL 10

It is working for me as well.
Hadn't been able to do a backup from within PSU since November.
Now it is running fine.
Thanks Hert!