Skip to main content
  • EN

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?

 

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?

 

image 

 

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

(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?

 

image 

 

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

(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?

 

image 

 

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

Experiencing the same problem

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

 

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

31,788
Posts
120,757
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.