[ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

This is the best place for community developers to publish their genius work. Your Apps enrich the QNAP Turbo NAS.
lokocool
New here
Posts: 6
Joined: Tue Apr 05, 2011 2:45 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by lokocool »

Hi, today I install PostgreSQL 9.3.13 from AppCentre on my Qnap TS-253Be. If there is any chance to update package to the newest PostgreSQL ?
As I see on PostgreSQL website the current version are: 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25.
BelgianNoise
Starting out
Posts: 15
Joined: Thu Jan 03, 2019 2:22 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by BelgianNoise »

what is the password for the postgres uwer ?
dmimagine
First post
Posts: 1
Joined: Tue Mar 08, 2016 3:48 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by dmimagine »

Hi @QNAP_Stephane,

I just installed postgres SQL9.6 and from the standard QPKG repository.
My purpose is to setup Nextcloud in the following setup
I am running a Qapache_2.4.25.1_x86 on a TS-239 PROII(last FW available 4.2.6), and it seeems to be running smooth with PHP7.1.1 separately than the one the NAS uses PHP 5.5.3.8.
I want to keep the NExtcloud setup highly independent so that this time i want to set-it up with POSTGRES not MariaDB.

BUT, i have an issue when trying to reach phpPgAdmin, which is indeed using the APACHE of the NAS itself (respectiveley PHP5.x), not the QAPACHE i installed.
Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
Both are in the same location, so maybe i have to somewhat link the HTDOCS of the QAPACHE?
/share/MD0_DATA/.qpkg/PostgreSQL96
/share/MD0_DATA/.qpkg/Qapache

Can you please be so kind to help me out with a step-by-step of how to be able to use POSTGRES with the PHP7.1.1 running on the Qapache ?
Please take into account i haven't worked/installed before PostgreSQL.
Best regards
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by QNAP_Stephane »

no idea... but this package is only x64, not x86

user postgres is set on qpkg start with pass postgres
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Bob Zelin
Experience counts
Posts: 1374
Joined: Mon Nov 21, 2016 12:55 am
Location: Orlando, FL.
Contact:

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by Bob Zelin »

I don't understand
How do you get PostgreSQL 9.6 on the QNAP.
I desperately need at least PostgreSQL 9.5, and the lastest version as of QTS 4.3.6 is PostgreSQL 9.3.x
Where exactly are you getting PostgreSQL 9.6
I am writing this on 2/1/2019

Bob Zelin
Bob Zelin / Rescue 1, Inc.
http://www.bobzelin.com
User avatar
OneCD
Guru
Posts: 12038
Joined: Sun Aug 21, 2016 10:48 am
Location: "... there, behind that sofa!"

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by OneCD »

Bob Zelin wrote: Sat Feb 02, 2019 8:53 am How do you get PostgreSQL 9.6 on the QNAP.
I desperately need at least PostgreSQL 9.5, and the lastest version as of QTS 4.3.6 is PostgreSQL 9.3.x
Hey Bob. :geek:

You can install Stephane's QPKG from the Qnapclub Store, which will get you to 10.4.1

But if you want an older release like 9.6.1 or 9.5.4, click on the link for 'old versions'.

ImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImage
Bob Zelin
Experience counts
Posts: 1374
Joined: Mon Nov 21, 2016 12:55 am
Location: Orlando, FL.
Contact:

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by Bob Zelin »

thank you OneCD -
to be clear - is this a normal install, like a manual App store install in the QNAP GUI, or is this for a VM installation with Windows on the QNAP ?
I am hoping, it's just like a normal App store install for QTS 4.3.6.

Thanks -
Bob Zelin
Bob Zelin / Rescue 1, Inc.
http://www.bobzelin.com
Bob Zelin
Experience counts
Posts: 1374
Joined: Mon Nov 21, 2016 12:55 am
Location: Orlando, FL.
Contact:

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by Bob Zelin »

Hello OneCD -
thank you for pointing me to Qnapclub Store. I see than I can download later versions of PostgreSQL, like 10.4.1, or specific versions that I need like 9.5.4.
What I am surprised about, is that once it installs, you can't open it to use the PostgreSQL user interface, like you can on the 9.3 version from the QNAP App Store.
It's running - I can see it when I ssh in, and I can modify files, but there is no user interface that opens to see the databases from the Qnapclub Store versions.
I am greatful that it exists on the Qnapclub Store website, but am disappointed that I can't open the web GUI user interface like in version 9.3 supplied by QNAP.

Thanks -
Bob Zelin
Bob Zelin / Rescue 1, Inc.
http://www.bobzelin.com
User avatar
OneCD
Guru
Posts: 12038
Joined: Sun Aug 21, 2016 10:48 am
Location: "... there, behind that sofa!"

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by OneCD »

Sorry Bob, I've never used this package. Maybe someone who has can advise further?

ImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImage
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by QNAP_Stephane »

I will check if i can provide this

anyway pgadmin can be installed seperately, within Qapache (not sure actual php has nativ pdo extension)
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Bob Zelin
Experience counts
Posts: 1374
Joined: Mon Nov 21, 2016 12:55 am
Location: Orlando, FL.
Contact:

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by Bob Zelin »

Hi Stephane,
I am very grateful for your replies. PGAdmin does not launch a Web GUI for PostgreSQL that you have on your website (like the native PostgreSQL 9.3 that QNAP provides on the QNAP App Store).
I have no idea of how you make money from QNAPClub - I think it's amazing that you are doing this. But it's my humble opinion that you should be charging SOME money for these applications - however, it's also my opinion that these applications should be fully tested, and function identically to the way that we expect a QNAP App Store App to function. Of course, for free, I expect nothing. But your wonderful efforts should be financially rewarded - but only if they work 100% as expected.

For your reference, PostgreSQL is the database that is used by Blackmagic Design DaVinci Resolve, which is a very popular application in the professional video market for both Mac and PC platforms. When you do "Google" searches on this, you will see many people asking about PostgreSQL database for DaVinci Resolve. And because many professional video users use QNAP, this is where my inquiry came from. Again, I am very grateful for all you are doing.

Bob Zelin
Bob Zelin / Rescue 1, Inc.
http://www.bobzelin.com
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by QNAP_Stephane »

basically i built it for Odoo project binding...
I will investigate to bring you a management UI and update to 10.6 the core

did you try PGWeb : https://www.qnapclub.eu/fr/qpkg/397
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by QNAP_Stephane »

just built the 10.6.1 but it is a big headach to provide ui management since local php in NAS do not have postgresql extension embedded

thinking more and more to built a separate package with Qapache as Dependency ... that could allow all armv7 arm64 and x64 (Intel) have a postgresql instance running on NAS...
Qapache has all necessary libs and binary to run and manage PostgreSQL

i tested phppgadmin on Qapache running flawlessly ...
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
carl1234
New here
Posts: 2
Joined: Fri Nov 18, 2016 11:07 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by carl1234 »

Anyone know of a way to use PostGIS with this installation? Thinking I'll probably have to switch to virtual machine but figured I'd ask in case anyone knows something I haven't been able to find. Also, thanks Stephane for everything that you do! You are appreciated!
racortesl
First post
Posts: 1
Joined: Sat Jul 20, 2019 3:09 am

Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server

Post by racortesl »

Hello there. I have a QNAP TS-431XeU and I would like to use it to host a PostgreSQL Server. I've searched the entire internet and the only solution I've found is use this app, which isn't compatible. Is there any way I can do this?

It have to be PostgreSQL, because I'm migrating a current postgres db from main server to nas.
Post Reply

Return to “Community Apps”