Training postGIS database down? Cannot connect to sample postGIS database (postgis.safe.train.com) to complete FME Academy Trail Integrate Data with the FME Platform.

Hi @dwinvegas​ 

I created this connection without error here in my note.

Please, could you check it todat in your FME?

Thanks in Advance,

Danilo

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

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

Experiencing the same problem

Hello, am also experiencing the same problem not being able to connect to postgis.x.x.x etc