Search This Blog

12/6/18

How to use PostgreSQL on QNAP NAS ?


PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.



How to use PostgreSQL on QNAP NAS ?

1. download PostgreSQL  qpkg on QNAP app center 
https://www.qnap.com/en-us/app_center/

the PostgreSQL app release note 
https://www.qnap.com/en-us/app_releasenotes/list.php?app_choose=PostgreSQL

2.  QPostgreSQL
[ QPostgreSQL ] [10.4.1 ] PostgreSQL Server

in QNAP forum, you can download another version from qnapclub
https://forum.qnap.com/viewtopic.php?t=112074
https://www.qnapclub.eu/fr/qpkg/239

3. install PostgreSQL from dockerhub via Container Station 

https://hub.docker.com/r/sameersbn/postgresql/

Other reference:
QNAP Systems, Inc., headquartered in Taipei, Taiwan, provides a comprehensive range of cutting-edge Network-attached Storage (NAS) and video surveillance solutions based on the principles of usability, high security, and flexible scalability. QNAP offers quality NAS products for home and business users, providing solutions for storage, backup/snapshot, virtualization, teamwork, multimedia, and more. QNAP envisions NAS as being more than "simple storage", and has created many NAS-based innovations to encourage users to host and develop Internet of Things, artificial intelligence, and machine learning solutions on their QNAP NAS.


No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...