Maybe this one here helps, too, although it is basically the same what TJ
said:
https://devops.profitbricks.com/tutorials/install-postgresql-on-centos-7/
Markus
On Sat, Feb 25, 2017 at 11:29 PM, TJ O'Donnell <t...@acm.org> wrote:
> The server itself must be told to allow remote connections.
> You might check these two things.
> 1. You can edit the postgresql.conf file (not sure where that is on your
> system).
> https://www.postgresql.org/docs/9.2/static/runtime-
> config-connection.html
> Uncomment or add the line listen_addresses='*'. You can
> tailor that to be more specific, but try this first.
>
> 2. The file pg_hba.conf also controls access. Look at this:
> https://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html
>
> Be sure to restart the server after you make changes to these files.
>
> Hope this helps,
> TJ O'Donnell
>
>
> On Sat, Feb 25, 2017 at 12:34 PM, <nbell8...@yahoo.com> wrote:
>
>> Hi,
>> I've installed rdkit on a CentOS machine using anaconda python and set up
>> a postgresql compound database in the rdkit environment. It works great on
>> the machine's console.
>> I now want to access it remotely and I'm trying to set up a jdbc postgres
>> driver to access it from a windows client but this is not working. If I
>> test the driver on the server it tells me that the connection is refused
>> and I should check that the machine is accepting TCP requests.
>>
>> I have opened the standard port that postgres uses
>> -A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT
>>
>> iptables -L returns
>> ACCEPT tcp -- anywhere anywhere state NEW
>> tcp dpt:postgres
>>
>> this is where I don't know what to check next. A few things that might be
>> relevant. If I "ps -eaf | grep post" I see four postgres processes running
>> under my username (not postgres), so I think there is a server working.
>> There is also a "system" postgresql (version 9.2) which I have connected to
>> previously a long time ago. This connection no longer works either and I
>> don't really care about that but could be an interfering factor.
>>
>> If anyone has suggestions about what to check next or solve this I'd be
>> grateful
>>
>> thanks,
>> Neil
>>
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Rdkit-discuss mailing list
>> Rdkit-discuss@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
>>
>>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Rdkit-discuss mailing list
> Rdkit-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Rdkit-discuss mailing list
Rdkit-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
