[ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
-
- New here
- Posts: 2
- Joined: Mon Jun 11, 2012 9:10 pm
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
@psycho_asylum: have you cheched postgresDB/pg_hba.conf?
-
- New here
- Posts: 2
- Joined: Sat Aug 12, 2017 11:40 pm
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
Has anybody gotten PostGreSQL 9.6.1 running on QNAP 4.3.3 and cares to share how to do that? Does that require a new QPKG?
-
- New here
- Posts: 2
- Joined: Sat Aug 12, 2017 11:40 pm
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
Found some tidbits of info here: viewtopic.php?f=45&t=83067&start=28
-
- New here
- Posts: 8
- Joined: Sun Oct 15, 2017 6:36 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
for solve it need to have linux command in console experiencepsycho_asylum wrote: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.
1. enable SSH access and connect via SSH console to ur nas
2. find file postgresql.conf i use command
Code: Select all
find / -name "postgresql.conf"
Code: Select all
vi /share/MD0_DATA/.qpkg/PostgreSQL/postgresDB/postgresql.conf
Code: Select all
listen_addresses = '0.0.0.0'
4. find file pg_hba.conf command
Code: Select all
find / -name "pg_hba.conf"
Code: Select all
vi /share/MD0_DATA/.qpkg/PostgreSQL/postgresDB/pg_hba.conf
Code: Select all
host all all 0.0.0.0/0 md5
Code: Select all
/share/MD0_DATA/.qpkg/PostgreSQL/PostgreSQL.sh restart
default login/password is postgres (if u cant login remotely then first set new password via web interface phpPgAdmin)
also log file here (or find it) /share/MD0_DATA/.qpkg/PostgreSQL/tmp/log
ETH 0xd8F2b22e50B200214303E4f0B95435c918ca9CcF
-
- First post
- Posts: 1
- Joined: Sat Oct 28, 2017 4:28 pm
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
This worked for me - I can now login remotely
Thanks!
Thanks!
-
- New here
- Posts: 4
- Joined: Wed Mar 14, 2018 9:26 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
I'm trying to create a Davinci Resolve 14 Server for my production house, so I installed a PGAdmin on our Qnap TVS-1282T3-i5. Alredy Modified the postgresql.conf (#listen_addresses = '*') and the pg_hba.conf (added on 1p4 connections: host all all 0.0.0.0/0 md5) but nothing seems to work. On PGAdmin4, installed on my macbook pro, I keep getting: "server is "not listening". I wonder if there's a kind of secret Firewall that prevents the Qnap to communicate with the external application. Also,alredy fowarded the 5432 port on my router.
Thanks for your valuable time!
Sincerely
Ricardo.
Thanks for your valuable time!
Sincerely
Ricardo.
-
- Know my way around
- Posts: 198
- Joined: Thu May 26, 2016 3:05 pm
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
Hi all
PostgreSQL is available in the app centre.
Is it worth installing this version instead?
Cheers
PostgreSQL is available in the app centre.
Is it worth installing this version instead?
Cheers
-
- Know my way around
- Posts: 164
- Joined: Mon Feb 08, 2016 9:45 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
Hi Stephane
I updated to the latest 10.4.1 and got the following error
I have created the the user postgres previously and was running fine prior to update.
Did I miss something out?
I updated to the latest 10.4.1 and got the following error
Code: Select all
psql.bin: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Did I miss something out?
TS451
TS453
TVS-682
TS453
TVS-682
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
strange i dont see why... it runs nicely on TS-253PRO and TVS-473
check if this file exists on the bin path /opt/QPostgreSQL/bin
check if this file exists on the bin path /opt/QPostgreSQL/bin
---------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
-
- Know my way around
- Posts: 164
- Joined: Mon Feb 08, 2016 9:45 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
yups /opt/QPostgreSQL/bin exists.
If I run ./psql -l the same error comes out again.
I thought it was strange too...
If I run ./psql -l the same error comes out again.
I thought it was strange too...
TS451
TS453
TVS-682
TS453
TVS-682
-
- Know my way around
- Posts: 164
- Joined: Mon Feb 08, 2016 9:45 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
ok found the problem.
how do I upgrade the database without losing any data?
running bin/pg_upgrade gave me
Code: Select all
The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.4.
running bin/pg_upgrade gave me
Code: Select all
pg_upgrade: cannot be run as root
Failure, exiting
TS451
TS453
TVS-682
TS453
TVS-682
- QNAP_Stephane
- Experience counts
- Posts: 4802
- Joined: Wed Mar 27, 2013 1:00 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
not expert on postgresql ... may be a dump possible but no idea
---------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------
-
- Know my way around
- Posts: 164
- Joined: Mon Feb 08, 2016 9:45 am
Re: [ QPostgreSQL ] [ 9.6.1 ] PostGreSQL Server
no prob! will roll back to ver 9.6QNAP_Stephane wrote:not expert on postgresql ... may be a dump possible but no idea
Luckily this i backed up before upgrading. Will wait for any postgresql experts to shed light.
I googled upgrading 9.6 to 10 but the linux methods didn't work out for qnap's modified linux.
Thanks Stephane! Your replies earlier on were very much appreciated!
TS451
TS453
TVS-682
TS453
TVS-682
-
- Getting the hang of things
- Posts: 86
- Joined: Tue Oct 19, 2010 5:41 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
Only the Odoo app runs with the QpostgreSQL . But there is no phpPgAdmin management possible. The PGWeb tool does not work on my NAS.
So if not being able to manage the QpostgreSQL DB with a professional admin tool stable version, this QPGSQL DB does not make any sense for me.
With the official PostgreSQL and the phpPgAdmin I can manage all DBs. Also tried the Odoo 12 win version running on any ClientPC and then
connecting with the QNAP NAS PostgreSQL as DB. Works fine and even fast. Of course the Odoo running files must be installed on the Clients, but 300MB for today's HDs
should not be any problem.
So maybe there is another point of view for a plus why QpostgreSQL should be used, and I only did not get it.
But on the other side, only one PostgreSQL can run on one NAS.
So if not being able to manage the QpostgreSQL DB with a professional admin tool stable version, this QPGSQL DB does not make any sense for me.
With the official PostgreSQL and the phpPgAdmin I can manage all DBs. Also tried the Odoo 12 win version running on any ClientPC and then
connecting with the QNAP NAS PostgreSQL as DB. Works fine and even fast. Of course the Odoo running files must be installed on the Clients, but 300MB for today's HDs
should not be any problem.
So maybe there is another point of view for a plus why QpostgreSQL should be used, and I only did not get it.
But on the other side, only one PostgreSQL can run on one NAS.
-
- First post
- Posts: 1
- Joined: Tue Nov 20, 2018 6:22 am
Re: [ QPostgreSQL ] [10.4.1 ] PostGreSQL Server
Hi Stephanie,
Is there a version of postgresSQL that runs on QNAP TS-1635? I can't seem to find it in my app center.
Is there a version of postgresSQL that runs on QNAP TS-1635? I can't seem to find it in my app center.