× NETGEAR will be terminating ReadyCLOUD service by July 1st, 2023. For more details click here.
Orbi WiFi 7 RBE973
Reply

Postgresql on ReadyNAS Ultra 2 ?

john_in_maldon
Aspirant

Postgresql on ReadyNAS Ultra 2 ?

Is there a way to install PostGreSQL on my Ultra 2?

(Or MySQL?)

Thanks
Message 1 of 6
fastfwd
Virtuoso

Re: Postgresql on ReadyNAS Ultra 2 ?

john_in_maldon wrote:
(Or MySQL?)

MySQL is already installed on your NAS. To enable it, install Super-Poussin's MySQLOn addon:

https://www.readynas.com/forum/viewtopic.php?t=22853
Message 2 of 6
john_in_maldon
Aspirant

Re: Postgresql on ReadyNAS Ultra 2 ?

fastfwd wrote:
john_in_maldon wrote:
(Or MySQL?)

MySQL is already installed on your NAS. To enable it, install Super-Poussin's MySQLOn addon:
]


That looks handy, but is an "Ultra" a "Pro"?

Having MySQL would be something, although I'd rather postgresql.
Message 3 of 6
StephenB
Guru

Re: Postgresql on ReadyNAS Ultra 2 ?

john_in_maldon wrote:
...is an "Ultra" a "Pro"?...
No. But both run 4.2.x firmware, and the x86 platform add-ons will will run on both.
Message 4 of 6
fastfwd
Virtuoso

Re: Postgresql on ReadyNAS Ultra 2 ?

john_in_maldon wrote:
is an "Ultra" a "Pro"?

The "Pro" in the name and description of the addon reflects the fact that Super-Poussin created it before the Ultra was released, when the Pro was the only x86-based ReadyNAS. The addon will work on both the Pro and the Ultra.
john_in_maldon wrote:
Having MySQL would be something, although I'd rather postgresql.

I haven't installed postgresql on my NAS, but it appears to be available from the debian etch and etch-backports repository archives. To get it, install the EnableRootSSH addon and SSH in to your NAS (username "root", password the same as your Frontview admin password), then add the debian etch repositories to your /etc/apt/sources.list. My sources.list looks like this:
deb http://www.readynas.com/packages 4.2.25/
deb http://www.readynas.com/packages readynas-x86/

deb http://archive.debian.org/debian-security etch/updates main contrib non-free
deb http://archive.debian.org/backports.org etch-backports main contrib non-free
deb http://archive.debian.org/debian etch main contrib non-free

Then install the postgresql package:
apt-get update
apt-get install postgresql

I haven't checked to see whether there are any dependencies or conflicts that would cause problems, and of course all the usual caveats and warnings about root command-line access to your NAS (including the fact that Netgear does not support the SSH addon and will deny support for problems caused by using it) apply. Having a full backup is, as always, recommended.
Message 5 of 6
john_in_maldon
Aspirant

Re: Postgresql on ReadyNAS Ultra 2 ?

fastfwd wrote:

I haven't checked to see whether there are any dependencies or conflicts that would cause problems, and of course all the usual caveats and warnings about root command-line access to your NAS (including the fact that Netgear does not support the SSH addon and will deny support for problems caused by using it) apply. Having a full backup is, as always, recommended.



Thanks for all that useful information!

(And thanks to StephenB as well!)
Message 6 of 6
Top Contributors
Discussion stats
  • 5 replies
  • 1917 views
  • 0 kudos
  • 3 in conversation
Announcements