Docker Container - Backup/Restore container images or databases only?

Docker Container方便建立系統備份，隨時可以啟動服務，來demo完整系統。甚至可以在一部機器 (多核心CPU + 大量記憶體) 執行多個輕量化虛擬化系統服務。但是container執行幾周後 (e.g. crawl web pages and extract metadata)，系統會記錄logs導致container image過大。

Original image size = 648.5 MB

QNAP/Linux - Python Programming 05 (Learn by Doing: Scan and Parse Files: Part 1)

Many Apps for NAS systems need to process file data within local file systems or from remote file servers. This "Learn by Doing" sets the problem:

• Scan files (local or remote) 
• Store metadata folders and files into database
• Extract metadata and text information from specific file types, such as PDF, Office, images, etc.

User manual of fscan.py

QNAP/Linux Tool - PostgreSQL from 9.2.1.0 Beta to 9.3.4.1

在更新重要軟體系統之前，要記得一件事：「先備份」。
QNAP/Linux Tool - PostgreSQL Database Backup and Restore

QNAP App Center: PostgreSQL has update version (2015/03/17)

QNAP/Linux Tool - PostgreSQL Database Backup and Restore

PostgreSQL support installations on major OS platforms: Windows, Mac and Unix. That is I can backup my databases/services running on QNAP to my Windows machines. First, install PostgreSQL 9.4 (the newest version) on Windows 8.1.

PostgreSQL 9.4 program group in Window 8.1 MetroUI

QNAP - PHP/PostgreSQL連線問題

在停電之後，QNAP重新啟動，沒想到發現以下問題：

Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.

這時，大部分會想到的解法就是「QNAP App Center重裝PostgreSQL」，這會導致原來建立的使用者帳號和資料庫都消失！

QNAP/Linux Tool - Access PostgreSQL from SSMS (SQL Server Management Studio)

If you are familiar to use Microsoft SQL Server, you should be appreciated by the easy access among servers and cross database provided by SQL Server. Especially access all servers' databases through SSMS (SQL Server Management Studio) environment. Fortunately, accessing PostgreSQL from SSMS is simple and convenient.

QNAP/Linux Tool - PostgreSQL / phpPgAdmin

In QNAP/Linux Tool - Create PostgreSQL Account and Database, we have create an user account "nas" and a database "testdb" through commands. Sometimes you just want to take a glimpse on the status of PostgreSQL, phpPgAdmin is an useful Web tool.

Login PostgreSQL through phpPgAdmin Web UI with account "postgres"

QNAP/Linux Tool - Create PostgreSQL Account and Database

Since several developers share the same QNAP machine to write PHP and PostgreSQL programs, you should obey following steps to create individual db account. From now on, each programmer uses your own db account to develop PHP/DB Apps.

QNAP/Linux Tool - Setting PostgreSQL and PHP Environment

To make your PHP easily connect to PostgreSQL installed in QNAP, you can use ipkg (install Optware IPKG) command to install PHP-PostgreSQL interface (php-pgsql).
[~] # ipkg install php-pgsqlInstalling php-pgsql (5.2.17-2) to root...Downloading http://ipkg.nslu2-linux.org/feeds/optware/cs08q1armel/cross/unstable/php-pgsql_5.2.17-2_arm.ipk
Installing php (5.2.17-2) to root...

QNAP/Linux Tool - PostgreSQL

QNAP has packaged the widely-used DBMS, PostgreSQL, from Linux open source. The supported version is newer than that packaged in OptIPKG. As for why choosing PostgreSQL, please see Ubuntu Programming Lesson 01 - Install PostgreSQL (Why PostgreSQL).

PostgreSQL is available on QNAP App Center

Ubuntu Programming Lesson 02 - pgAdmin connect to PostgreSQL

要由pgAdmin管理界面連接PostgreSQL還頗麻煩！當然，麻煩點才不會像MSSQL那樣，裝好後一堆sa無密碼，等這被駭！！

裝好PostgreSQL 9.3.後，由System Monitor就可以看到執行中的postgres程序

Ubuntu Programming Lesson 01 - Install PostgreSQL (Why PostgreSQL)

在開發一個好的系統服務的前提，要先選一個好的DBMS (DataBase Management System)，但是在Linux系統中，應改用哪一個DBMS呢？大部分的人一定說：MySQL! 但是 ... ... ...

選擇大象的記憶和容量