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.

100 % new to FME and FME Academy. As a new user I have started my first trail, Integrate Data with the FME Platform. The third Module, Transform Data, has the student connect to a postGIS database, called fmedata at: I have tried this as documented, but get no response. A ping to this returns: Pinging ec2-54-214-172-21.us-west-2.compute.amazonaws.com [54.214.172.21] with 32 bytes of data:

Request timed out.

Is the database available?

Page 1 / 1

Hi @dwinvegas

I created this connection without error here in my note.

Connection

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

Hi @dwinvegas

I created this connection without error here in my note.

Connection

Please, could you check it todat in your FME?

Thanks in Advance,

Danilo

Good Morning,

I have tried to do just as you show. I had another failure.

I replied in the forum with full details and my error log.

I suspect that my IT security group has some policy that is blocking the connection.

Thanks
Dave

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

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

It's very strange. Mayb we can do a meeting online to try to see the error.

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

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

When I encountered the error on my system last year, a reboot fixed it. Please try rebooting your system and see if that resolves the issue. If not, please let me know if you are using a VPN.

Experiencing the same problem

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.

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded