I downloaded and installed a Greenplum 5.0.0 VM from your site. It is up and running but when I try to connect remotely from a java program with a postgres jdbc, I get password authentication failed for user 'gpadmin' I can't seem to get past this.

[tom conrad]

It is a test machine so not worried about security. I used pivotal as the database password. Please help. Thanks in advance!!

[tom conrad]

Any idea's on this? Still haven't solved it. Thanks.

[Shawn Yan]

Hi Tom,

If you haven't verified the pg_hba.conf file for this connection, I would suggest take a look at below document:

https://gpdb.docs.pivotal.io/590/admin_guide/client_auth.html

 

If you are sure the pg_hba.conf file is correctly setup, then provide the complete error message may help check further. (You can find the complete error message) from master log. $MASTER_DATA_DIRECTORY/pg_log/

[tom conrad]

Hi Shawn, Thank you for getting back to me. I am pretty sure that pg_hba.conf is set up correctly. Here is the error from the log.I also can't seem to use psql. Here is the error I am getting from it.

The server looks like it up but hard to tell.

Thanks,

Tom

[Shawn Yan]

Hi Tom,

Here are a few items to check:

1. did you run " source /usr/local/greenplum-db-5.0.0/greenplum_path.sh" before running psql?
2. for gpdb 5.0 vm, did you use the 5.0 sandbox, or a binary file to install and init a new cluster on your VM ?
3. can you provide the output of " env |grep PG"

[tom conrad]

Hi Shawn,

 

Running greenplum_path.sh was the answer. Once I ran that, I could run psql and change the gpadmin password. Now I can access and test the database remotely.

 

Thanks for all the help,

Tom