This still does not work for me. I am using FME Workbench 2021.2
FME(R) 2021.2.2.0 (20220106 - Build 21806 - WIN64)
The instructions of the exercise, Quickly Create a Conversion Workflow
(https://safe.my.trailhead.com/content/safe/modules/transform-data/quickly-create-a-conversion-workflow?trail_id=integrate-data-with-the-fme-platform) , are to generate a workspace using Generate Workspace and a postGIS reader.
I have tried to replicate your solution using a postgresql reader with the same or similar result. Perhaps my IT security group is stopping this connection?
My Error Log as follows:
Creating reader for format: PostgreSQL
Trying to find a DYNAMIC plugin for reader named `POSTGRES'
Loaded module 'POSTGRES' from file 'C:\\Program Files\\FME\\plugins/POSTGIS.dll'
FME API version of module 'POSTGRES' matches current internal version (3.8 20210302)
Creating reader for format: PostgreSQL
Trying to find a DYNAMIC plugin for reader named `POSTGRES'
FME API version of module 'POSTGRES' matches current internal version (3.8 20210302)
Opening POSTGRES reader for dataset 'fmedata'
'
Is the server running on host "postgis.train.safe.com" (54.214.172.21) and accepting
TCP/IP connections on port 5432?
'
Successfully closed POSTGRES database reader
UniversalReader -- readSchema resulted in 0 schema features being returned
Reader Parameter(0) = >fmedata<
Reader Parameter(1) = >HOST<
Reader Parameter(1) = >postgis.train.safe.com<
Reader Parameter(3) = >PORT<
Reader Parameter(3) = >5432<
Reader Parameter(5) = >USER_NAME<
Reader Parameter(5) = >fmedata<
Reader Parameter(7) = >PASSWORD<
Reader Parameter(7) = >********<
Reader Parameter(9) = >SSL_OPTIONS<
Reader Parameter(9) = ><
Reader Parameter(11) = >SSLMODE<
Reader Parameter(11) = >prefer<
Reader Parameter(13) = >CA_CERTIFICATE<
Reader Parameter(13) = ><
Reader Parameter(15) = >CLIENT_CERTIFICATE<
Reader Parameter(15) = ><
Reader Parameter(17) = >CLIENT_PRIV_KEY<
Reader Parameter(17) = ><
Reader Parameter(19) = >SSL_PASSWORD<
Reader Parameter(19) = >********<
Reader Parameter(21) = >RETRIEVE_ALL_TABLE_NAMES<
Reader Parameter(21) = >YES<
Reader Directive(0) = >HOST<
Reader Directive(1) = >postgis.train.safe.com<
Reader Directive(2) = >PORT<
Reader Directive(3) = >5432<
Reader Directive(4) = >USER_NAME<
Reader Directive(5) = >fmedata<
Reader Directive(6) = >PASSWORD<
Reader Directive(7) = >********<
Reader Directive(8) = >SSL_OPTIONS<
Reader Directive(9) = ><
Reader Directive(10) = >SSLMODE<
Reader Directive(11) = >prefer<
Reader Directive(12) = >CA_CERTIFICATE<
Reader Directive(13) = ><
Reader Directive(14) = >CLIENT_CERTIFICATE<
Reader Directive(15) = ><
Reader Directive(16) = >CLIENT_PRIV_KEY<
Reader Directive(17) = ><
Reader Directive(18) = >SSL_PASSWORD<
Reader Directive(19) = >********<
Reader Directive(20) = >RETRIEVE_ALL_TABLE_NAMES<
Reader Directive(21) = >YES<
UniversalReader -- readSchema resulted in 0 schema features being returned
POSTGRES reader: Reader failed in open() call
Hello, am also experiencing the same problem not being able to connect to postgis.x.x.x etc
Check if you are using a VPN, and try rebooting your machine. I've found that some VPNs can cause an issue, and disconnecting and/or rebooting my machine resolved the issue.