[ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
-
- New here
- Posts: 6
- Joined: Tue Apr 05, 2011 2:45 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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.
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.
-
- Starting out
- Posts: 15
- Joined: Thu Jan 03, 2019 2:22 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
what is the password for the postgres uwer ?
-
- First post
- Posts: 1
- Joined: Tue Mar 08, 2016 3:48 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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.
/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
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.
Both are in the same location, so maybe i have to somewhat link the HTDOCS of the QAPACHE?Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
/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
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
no idea... but this package is only x64, not x86
user postgres is set on qpkg start with pass postgres
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
----------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
-
- Experience counts
- Posts: 1374
- Joined: Mon Nov 21, 2016 12:55 am
- Location: Orlando, FL.
- Contact:
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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
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
http://www.bobzelin.com
- OneCD
- Guru
- Posts: 12038
- Joined: Sun Aug 21, 2016 10:48 am
- Location: "... there, behind that sofa!"
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
Hey Bob.
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'.
-
- Experience counts
- Posts: 1374
- Joined: Mon Nov 21, 2016 12:55 am
- Location: Orlando, FL.
- Contact:
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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
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
http://www.bobzelin.com
-
- Experience counts
- Posts: 1374
- Joined: Mon Nov 21, 2016 12:55 am
- Location: Orlando, FL.
- Contact:
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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
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
http://www.bobzelin.com
- OneCD
- Guru
- Posts: 12038
- Joined: Sun Aug 21, 2016 10:48 am
- Location: "... there, behind that sofa!"
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
Sorry Bob, I've never used this package. Maybe someone who has can advise further?
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
I will check if i can provide this
anyway pgadmin can be installed seperately, within Qapache (not sure actual php has nativ pdo extension)
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
----------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
-
- Experience counts
- Posts: 1374
- Joined: Mon Nov 21, 2016 12:55 am
- Location: Orlando, FL.
- Contact:
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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
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
http://www.bobzelin.com
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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
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
----------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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 ...
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
----------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
-
- New here
- Posts: 2
- Joined: Fri Nov 18, 2016 11:07 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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!
-
- First post
- Posts: 1
- Joined: Sat Jul 20, 2019 3:09 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
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.
It have to be PostgreSQL, because I'm migrating a current postgres db from main server to nas.