Configuring PostgreSQL v9.3 on Synology NAS

weidmic
moderator
Posts: 2854
Joined: 04 Dec 06 22:21

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by weidmic » 23 Feb 15 15:04

Thanks for the suggestion, but that did not help.
Are you having the latest version of the DSM?
PSUServer 4.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

we_are_borg
Posts: 4
Joined: 21 Feb 15 15:37

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by we_are_borg » 25 Feb 15 15:21

I have no idea why that is and i dont have phppgadmin voor windows but if its being tunneled trough port 22 that should be fine because 22 has tunnel on.

weidmic
moderator
Posts: 2854
Joined: 04 Dec 06 22:21

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by weidmic » 25 Feb 15 16:24

I can connect to the DB via phppgadmin when I tunnel through port 22.
PSU does not use the tunnel

One of my close friends who is kind of a "geek" isn't able to get in either.
Postgres is listening to 5432 (that's for sure); otherwise postgres would not tell me
PostgreSQL:FATAL:no pg_hba.conf entry for host "xxx.xxx.x.x".......

Would you mind to post your complete hg_hba.conf so I can verify mine with yours?

Thanks
Michael
PSUServer 4.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

HCS
Posts: 147
Joined: 19 Feb 14 22:08

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by HCS » 26 Feb 15 16:09

weidmic wrote:I can connect to the DB via phppgadmin when I tunnel through port 22.
PSU does not use the tunnel

One of my close friends who is kind of a "geek" isn't able to get in either.
Postgres is listening to 5432 (that's for sure); otherwise postgres would not tell me
PostgreSQL:FATAL:no pg_hba.conf entry for host "xxx.xxx.x.x".......

Would you mind to post your complete hg_hba.conf so I can verify mine with yours?

Thanks
Michael
Not sure you are asking me for the hg_hba.conf, but i can share mine. Have to dig it up (not on my server now). BTW, i'm running postgres on the mac, not on my nas.

weidmic
moderator
Posts: 2854
Joined: 04 Dec 06 22:21

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by weidmic » 26 Feb 15 17:14

HCS,
Since you are running it on your MAC I guess it is different.
The Problem is really with the Synology NAS, I guess...
Maybe we_are_borg can share his.

I figured out that there are at least 2 directories with the hg_hba conf onf the NAS and both look different.

Cheers,
Michael
PSUServer 4.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

we_are_borg
Posts: 4
Joined: 21 Feb 15 15:37

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by we_are_borg » 27 Feb 15 14:26

I have looked at pgAdmin 3 but connecting with SSH to the PostGreSQL is as it should you than have increased security on the box i would not let the PostGreSQL talk to the outside straight away.

HCS
Posts: 147
Joined: 19 Feb 14 22:08

Re: Configuring PostgreSQL v9.3 on Synology NAS

Post by HCS » 27 Feb 15 16:42

weidmic wrote:HCS,
Since you are running it on your MAC I guess it is different.
The Problem is really with the Synology NAS, I guess...
OK, no problem.

By the way, i wanted to implement on Synology NAS at first as well, but the daunting "instructions" around the net scared me away from the idea.

Post Reply