Setting Up ZFS NAS

Post Reply
Dismayed
Posts: 46
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: 6980
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. If you need product support then please send a message

Dismayed
Posts: 46
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: 6980
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. If you need product support then please send a message

Dismayed
Posts: 46
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: 46
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: 6980
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. If you need product support then please send a message

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

Re: Setting Up ZFS NAS

Post by Dismayed » 21 Feb 21 19:18

Just a quick update, in case anyone else is thinking of doing this.

I'm storing my files on a TrueNAS 12 CORE server and accessing the NAS over ethernet. My PostgreSQL database and PSU 6 are running on my mid-2010 Mac Pro (converted to 100% Windows 10) with 32 GB of RAM, stored on a local SSD. It's all running well. I did, however, have problems with copies from my Mac to the NAS when I was running OSX High Sierra, but there are no such issues with Win 10.
“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

Post Reply