Setting Up ZFS NAS

Post Reply
Dismayed
Posts: 16
Joined: 22 Sep 09 21:42
Location: Boston, MA

Setting Up ZFS NAS

Post by Dismayed » 02 Jan 21 16:06

I'm setting up a ZFS NAS to store my photos. I plan to access the data by mapping the storage pool into my Windows machine, so I'm assuming that installing Photo Supreme for windows on my desktop machine should work fine. I'd like my wife and sons to have access to the cataloged images, so I'll need to place the catalog on the NAS, too. So do I purchase an individual license for each person that I'd like to grant access? Or should I run the server edition from my own desktop (I never shut it down).
“There are three kinds of men. The ones that learn by readin’. The few who learn by observation.
The rest of them have to pee on the electric fence for themselves.”
~ Will Rogers

Hert
Posts: 6564
Joined: 13 Sep 03 7:24

Re: Setting Up ZFS NAS

Post by Hert » 04 Jan 21 14:36

You could use the Server Edition by installing Postgresql on the NAS. Keep in mind that running a Postgresql database from the NAS requires sufficient NAS-specs: 8GB internal RAM, a multi core processor, and preferrably a SSD to hold the PostgreSQL database files.

You mention being able to install on the desktop. In that case you will have a very powerful configuration for the Server Edition. And best part if that the Server Edition is multi user capable (where a SQLite database is not and can't be used with multiple users). If you'd share a SQLite database then you'd need to mirror the SQLite database files, which can be a drag.

I recommend that you play with the beta also:
viewtopic.php?f=82&t=28103

It is multi user (no database file copying required) and works with your Server Edition's database.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Dismayed
Posts: 16
Joined: 22 Sep 09 21:42
Location: Boston, MA

Re: Setting Up ZFS NAS

Post by Dismayed » 06 Jan 21 6:03

My NAS has a 6 core Xeon processor and 32 GB of RAM, so placing the DB on the NAS may be an option. I'll need to test it a bit, but next week.
“There are three kinds of men. The ones that learn by readin’. The few who learn by observation.
The rest of them have to pee on the electric fence for themselves.”
~ Will Rogers

Hert
Posts: 6564
Joined: 13 Sep 03 7:24

Re: Setting Up ZFS NAS

Post by Hert » 06 Jan 21 10:30

That sounds like a very impressive NAS! That should be able to run a PostgreSQL database with ease.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Dismayed
Posts: 16
Joined: 22 Sep 09 21:42
Location: Boston, MA

Re: Setting Up ZFS NAS

Post by Dismayed » 11 Jan 21 4:26

I just installed the server version of Photo Supreme on my Windows 10 desktop. Import from the NAS went well, and I like the clean interface. I'm running TrueNAS Core which is built on FreeBSD. There will be a new version soon, though, that will run on Linux. So I'll test installing PostgreSQL on my NAS in the future. For now, I'll test locating the catalog on the NAS. Then I'll try to figure out how best to catalog my photos.

Nice software, by the way!
“There are three kinds of men. The ones that learn by readin’. The few who learn by observation.
The rest of them have to pee on the electric fence for themselves.”
~ Will Rogers

Dismayed
Posts: 16
Joined: 22 Sep 09 21:42
Location: Boston, MA

Re: Setting Up ZFS NAS

Post by Dismayed » 11 Jan 21 18:21

I've done a bit of tagging now, and I have to say that the software is excellent. PostgreSQL feels industrial grade - ingestions are fast and the database has been completely stable. And with the online viewer it looks as if it will meet my needs.
“There are three kinds of men. The ones that learn by readin’. The few who learn by observation.
The rest of them have to pee on the electric fence for themselves.”
~ Will Rogers

Hert
Posts: 6564
Joined: 13 Sep 03 7:24

Re: Setting Up ZFS NAS

Post by Hert » 12 Jan 21 10:41

PostgreSQL is indeed a high grade database that is up for professional tasks. Very robust, and fast
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply