(CC-ing the list) Hmm, that should just work. Are there any special characters in the username, password or host (non-ascii, URL unsafe characters) ? You could try the explicit init form P3Client new host: 'host'; user: 'user'; password: 'password'; database: 'database'; yourself.
On 18 May 2021, at 19:47, Bernhard Pieber <bernhard@pieber.com> wrote:
Hi Sven,
Thank you for the fast response.
Yes, I can connect using the psql client using this command line: C:\PostgreSQL\12\bin\psql.exe -h host -U user -d database -p 5432
I have to enter the password in the command prompt.
The driver URL in SQuirreL is: jdbc:postgresql://host:5432/database
User name and password are separate text fields.
pgAdmin also works, by the way.
In P3 I use the long form: P3Client new url: 'psql://user:password@host:5432/database'.
Cheers, Bernhard
Am 18.05.2021 um 19:16 schrieb Sven Van Caekenberghe <sven@stfx.eu>:
Hi Bernard,
On 18 May 2021, at 18:40, Bernhard Pieber <bernhard@pieber.com> wrote:
Hi,
I have a PostgreSQL database on a remote host which I want to access using P3. I do have a username and a password and can connect via SQuirreL and DBeaver. Both use a JDBC driver. However, when I try to access it via Pharo and P3 I get the infamous "no pg_hba.conf entry for host <my IP address>â error. The thing is that I cannot change the pg_hba.conf file as the server does not belong to me. I wonder why the JDBC driver does not run into this problem when connecting from my IP address? It must do something differently.
As I have just started playing with P3 (and PostgreSQL to be honest) I may be missing something fundamental. Using #setSSL did not help, by the way. Any other ideas I could try?
Cheers, Bernhard
This is an interesting problem: to do a remote, over the network, connection this has to be enabled in PostegreSQL in the pg_hba.conf. But since other clients can connect, it would help if you could give me more details regarding their connection settings. I know this could include confidential information, so be careful what you post.
You could also try to connect using the command line psql client, from your machine.
Sven