[QPKG] PostgreSQL v8.2.13d

[Silas Mariusz]

[Name]
PostgreSQL

[Description]
PostgreSQL is a powerful, enterprise-level, yet 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.

Features:
- Immunity to over-deployment
- Better support than the proprietary vendors
- Significant saving on staffing costs
- Legendary reliability and stability
- Extensible
- Cross platform
- Designed for high volume environments
- GUI database design and administration tools
- Technical Features:

** Fully ACID compliant.
** ANSI SQL compliant.
** Referential Integrity.
** Replication (non-commercial and commercial solutions) allowing the duplication of the master database to multiple slave machines.
** Native interfaces for ODBC, JDBC, .Net, C, C++, PHP, Perl, TCL, ECPG, Python, and Ruby.
** Rules.
** Views.
** Triggers.
** Unicode.
** Sequences.
** Inheritance.
** Outer Joins.
** Sub-selects.
** An open API.
** Stored Procedures.
** Native SSL support.
** Procedural languages.
** Hot stand-by (commercial solutions).
** Better than row-level locking.
** Functional and Partial indexes.
** Native Kerberos authentication.
** Support for UNION, UNION ALL and EXCEPT queries.
** Loadable extensions offering SHA1, MD5, XML, and other functionality.
** Tools for generating portable SQL to share with other SQL-compliant systems.
** Extensible data type system providing for custom, user-defined datatypes and rapid development of new datatypes.
** Cross-database compatibility functions for easing the transition from other, less SQL-compliant RDBMS.

[Version]
8.2.13

[Release note]
Changelog

2010/08/21   v8.2.13d  workaround to avoid php.ini issue
2010/03/23   v8.2.13c   Remove the phpPgAdmin for security breach issue
2010/03/03   v8.2.13b   Add model detection - support for x10 & x59 series
2010/02/26   v8.2.13a   Initial release x19 & x39

[Maintainer]
AdNovea

[Resource]
Official documentation | FAQ

[Download]


[Remarks]
Installation

• You will have to install Optware QPKG prior to install PostgreSQL QPKG
• PhpPgAdmin was removed for security reasons, however it can still be installed manually if needed.

[Plugins]
N/A

[COMMENTS]
I have seen and be reported with complaints about the difficulty to make PostGreSQL working.

Actually this is due to the fact that 3 majors tricks combine when dealing with PostGreSQL:

• 1- IPKG does not automatically restart AFTER reboot (despite it shows ENABLE)
  => Disable and Enable the Optware QPKG from the NAS Admin interface
  .
• 2- /etc/init.d/Qthttpd.sh does not allow to have multiple "extension" statements in the php.ini file
  Restart Apache server (Web server can also be restarted from the NAS Admin page):
  

   # /etc/init.d/Qthttpd.sh restart

  => Disable and Enable the PostGreSQL QPKG from the NAS Admin interface
  IMPORTANT: this erases the symblink to the web folder (see #3)
  .
• 3- I have been asked for security reason to not symblink the phpPgAdmin web interface to the NAS Web folder automatically
  => Manually create the symblink to the Web folder AND change the default A/C for security reason
  

  # ln -sf /share/xxx_DATA/.qpkg/PostgreSQL/phpPgAdmin /share/Qweb/phpPgAdmin
  
  	WARNING:  "xxx_DATA" depend of your NAS configuration
               "Qweb" may be named "Web" on your NAS

[PostGreSQL Re-installation]

• Disable and Enable the Optware QPKG from the NAS Admin interface
• Remove the PostGreSQL QPKG from the NAS Admin interface (this does not remove the database BUT first backup your data if any)
• Restart Apache server (Web server can also be restarted from the NAS Admin page):
  

  # /etc/init.d/Qthttpd.sh restart

• Install the new PostGreSQL QPKG from the QNAP forum.
• Enable the PostGreSQL QPKG from the NAS Admin interface
• Manually create the symblink to the Web folder

[AFTER a REBOOT] your MUST execute the following operations in this order :

• Disable and Enable the Optware QPKG from the NAS Admin interface
• Disable and Enable the PostGreSQL QPKG from the NAS Admin interface
• Manually create the symblink to the Web folder

[Troubleshooting]

Q- I got "404 page not found" when I try to connect to the PostGreSQl web interface
A- By default during the installation or after a re-enable of the PostGreSQl QPKG, the link is REMOVED. Please manually recreate the link

Q- I got "Vous n'avez pas compilé correctement le support de la base de données dans votre installation de PHP." or in english a message that says something like "you have not compiled the PHP support"
A- Please START the PostGreSQl QPKg from the NAS Admin interface BEFORE connecting to the Web interface

Q- I got problem with messages about specific package (IPKG)
A- Upgrade the corresponding package (ipkg upgrade <package>)


[Download]
PostgreSQL v8.2.13 [Warning: this is still under test]
Right click the link and choose Save as...
ARM (x10/x19 series) [TS-119/ 219/ 219P / 419 / 419U | TS-110 / 210 / 410]
Intel (x39/x59 series) [TS-239/ 439/ 509/ 639/ 809/ 809U-RP/ 839/ SS-439/ 839 | TS-259 TS-459 TS-659 TS-859]

These QPKGs have been respectively successfully tested on a TS-219 pro and a TS-639 Pro.

Hope the previously tricks will be fixed in the near future and this post will help you to get PostGreSQL working on your NAS.
Many thanks for your kind patience