PostgreSQL Database 3rd-party App

maxani · Post by **maxani** » Wed Feb 27, 2013 10:54 pm

Hi everyone.

It would me nice if we could have PostgreSQL Database installed in our Asustor NAS.
Indeed it's a very good relational database and even more now like for instance NoSQL capabilities.
I prefer it to MySQL.

Of course PHP extension would be necessarry.

I'm not skilled enough to build an APK. So could someone or Asustor Staff do it for the community?

Thanks.

mariowinco · Post by **mariowinco** » Mon Dec 16, 2013 4:10 am

I also will want to install this database on my Asustor server … the language has better support of some important characteristics of SQL than MySQL and I'm doing some custom development into it ...

maxani · Post by **maxani** » Tue Dec 17, 2013 4:13 pm

Hi mariowinco.

I made a package for my 602. It works great but has not been approved by Asustor yet.
I'm updating it and hope it will be available for everyone soon.

App Central.png

What Asustor Nas have you got? My package is only for X86-64 OS. That's why I can run it on my 602.

Best regards.

maxani · Post by **maxani** » Wed Dec 18, 2013 4:15 pm

EDIT: doesn't work on 3 Series. Sorry. Working on it.

Hi.

So here's a package of PostgreSQL 9.3.2 flawessly running on my 602.

I've included i386 binaries so that it works on 3 Series but I could'nt test it so I'm not sure it's OK.

Please give me feedback.

default user: "admin"
default password: "postgres"
default database: "postgres"

Don't forget that by default only local connections are allowed. Use phpPgAdmin to test. If you wish to connect from outside the NAS you have to:
- stop PostgreSQL in AppCentral.
- then edit postgresql.conf in "/volume1/PostgreSQL" and add the line listen_addresses = '*'.
- then launch PostgreSQL in AppCentral again.
- then use you favorite database tool.

EDIT: doesn't work on 3 Series. Sorry. Working on it.

mariowinco · Post by **mariowinco** » Wed Dec 18, 2013 11:00 pm

Well, tx for the testing, I've tried to download but was not able to download it.

As soon as is released -> I'm waiting to use it.

maxani · Post by **maxani** » Fri Dec 20, 2013 3:47 pm

Hi y'all.

Finally PostgreSQL is available on all our Asustor units.
Check the App Central.

Best regards.

mariowinco · Post by **mariowinco** » Mon Dec 30, 2013 7:10 pm

Max

installed app & (I believe) is running.

1- how should I connect directly?

using pgAdmin3 I did a "new server" with host http://192.168.0.xxx:5432 and get this error

"error connecting to the server: could not translate host name "http://192.168.0.xxx" to address:node name nor servname provided"

2- how should I connect using JDBC? I'm running BIRT and it uses JDBC for connection.

Regards
Luis

maxani · Post by **maxani** » Mon Dec 30, 2013 7:34 pm

Hi MarioWinco.

Just put the IP Address for the host information (without "http://" and "5432")

But you have to know that PostgreSQL is by default only accessible locally (localhost). Try to install http://phppgadmin.sourceforge.net/doku.php to test.

If you want to connect from other location:
- Stop PostgreSQL in the AppCentral

- edit the postgresql.conf file located in /volume1/PostgreSQL/ by adding the line:

Code: Select all

listen_addresses = '*'

to be able to connect from anywhere. You can list IPs too.

- edit the pg_hba.conf file also in /volume1/PostgreSQL/ by adding or modifying to something like that:

Code: Select all

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4 local connections:
host    all             all             all            			md5
# IPv6 local connections:
host    all             all             all            			md5

- Run PostgreSQL in the AppCentral

Now you should be able to connect to your PostgreSQL server with default credentials => user: "admin" - password: "postgres" - database: "postgres"

Best regards.

mariowinco · Post by **mariowinco** » Tue Dec 31, 2013 6:26 am

Max

I've followed your advice, changing the configuration file on the Asustor

1. Connection from pgAdmin3, from my MAC, does not work. I go to "new server registration", use x.x.x.x as server, 5432 as port, empty service, postgres, admin on Properties tab. Nothing indicated in SSL/SSH tunnel or advanced

I receive this message:

Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused Is the server running on host "x.x.x.x" and accepting TCP/IP connections on port 5432?
If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?

2. I have to install yet phppgadmin in the asustor, trying to install on my computer but still not working. Question: any specific directory/installation I should be doing?

3. Do you know what flavor of linux ADM 2.0 is based on?

tx a lot and happy new year!!!

maxani · Post by **maxani** » Tue Dec 31, 2013 6:37 am

Did you edit the TWO files in the /volume1/PostgreSQL folder?

PhpPgAdmin has to be installed in the Web folder. It´s a php web app running on your Asustor unit's web server.

Can you tell me what is there in your /volume1/PostgreSQL folder by the way?

ASUSTOR Community Forum