[ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

[QNAP_Stephane]

Source : http://www.postgresql.org/

https://www.qnapclub.eu/fr/qpkg/239

Note :

Before install, please create a 'postgres' user via QTS

create DB and config on first launch inside /share/CACHEDEV1_DATA/.POSTGRESQL_DB (HAL Firmware with LVM) or /share/MD0_DATA/.POSTGRESQL_DB (for Legacy ones)

About :

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.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.
Limit Value
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 - 1600 depending on column types
Maximum Indexes per Table Unlimited

PostgreSQL has won praise from its users and industry recognition, including the Linux New Media Award for Best Database System and five time winner of the The Linux Journal Editors' Choice Award for best DBMS.

[rob-farrell]

Any chance you could generate a package for PostgreSQL server 9.5 or above?

Thanks!

[QNAP_Stephane]

done

quickly tested on TBS-453A

[rob-farrell]

Apologies for the additional ask.
Can you generate a x86_64 qpkg also?

Thank you QNAP_Stephanie!

[QNAP_Stephane]

updated

[bogdanvasiliu]

Bonjour "QNAP_Stephane", You can generate a package for PostgreSQL server 9.5 for my TS421 as well?

[QNAP_Stephane]

Bonjour "QNAP_Stephane", You can generate a package for PostgreSQL server 9.5 for my TS421 as well?

dont think.. my version are based on the installer from PGSQL website version...

your should need a cross compilation from source, not sure the gcc version can support it

[QNAP_Stephane]

updated

[rscholly]

Hi Stephane,

Bit new to installing PostgreSQL and dont understand if I am just missing something.

In App Centre I have found that I can install PostgreSQL 9.6.0.1. Once installed I can open the phpPgAdmin by clicking "Open" on the installed app in App Centre. All seems to work.

If I uninstall the app and install your package you have supplied (9.5.4) then even though I see the "Open" button, nothing happen when I am clicking on it. Am I missing something or should I manually be opening the phpPgAdmin?

Eager to learn and understand.

Thanks
Raymond

[QNAP_Stephane]

there is no phpPgAdmin.. PDO are not installed within the Qnap Webserver..

you can probaly user PGWeb instead : http://www.qnapclub.eu/index.php?act=detail&qpkg_id=397

or installed phpPGAdmin within Qapache

[aleksandar]

Hi Stephane,

I've installed PostGIS using Web interface but I couldn't log in into PostGIS server. I tried default credentials, created postgres user as you said, but unsuccessfully.
Also, I can't install this qpkg because there is no app that can run it (when using web terminal interface).

I'm very new to QNAP NAS, and this is probably very trivial, but I would really appreciate if you help me with this. This is very crucial step in my firm, so I hope you could help me.

Thanks in advance!
Alexandar

[krzysieq]

Hi, any chance that this package could work after latest firmware upgrade to qts 4.3.3? The upgrade didn't say anything and I clicked ok thinking it would go as smooth as ever, and I'm so wrong and so in trouble...

[Trexx]

Hi, any chance that this package could work after latest firmware upgrade to qts 4.3.3? The upgrade didn't say anything and I clicked ok thinking it would go as smooth as ever, and I'm so wrong and so in trouble...

install this version
64 version : http://www.positiv-it.fr/QNAP/APP/QPost ... 4.qpkg.zip (no management UI) [ FW 4.3 ]

IF you were using QNAP's package in 4.2.x for Postgres, this won't upgrade that version in place as they are "Different" apps (vendor vs. community). You will need to do an export from your 4.2, to then import into 4.3.

[psycho_asylum]

I installed the qpkg fine, but cannot seem to connect to it using the postgres user I created. I'm trying pgAdmin to connect and it says "Connection Refused." Any ideas?

edit: I can see the socket: /tmp/.s.PGSQL.5432=

edit2: It seems I can connect to it using PGWeb. Not sure why I can't connect outside localhost. I tried setting the listen address on the postgresql.conf but the socket never gets created.

[jeroenho]

Can anyone build a version for ARM for QTS 4.3.3?
Today I received my TS-1635, and I hoped the package from 4.2 would run, but all I get is segmentation fault.
Preferably with phpPGAdmin

I really like to replace my TS-412!