Thanks to both. that conf file change worked.
On Sunday, 26 February 2017, 0:07, Markus Sitzmann
<markus.sitzm...@gmail.com> wrote:
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 returnsACCEPT 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.sourceforg e.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
------------------------------------------------------------------------------
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