Skip to main content
  • EN
Hi,

 

Having some problem using SQLExecuter and SQLCreator with a Postgre/Postgre.

 

 

Error connecting to PostgreSQL database(host='**.***.**.***', port='5432', dbname='*******', user=postgre, password='***'): 'FATAL:  password authentication failed for user "postgre"

 

 

Its not really a authentication error since both the postgre and postgis reader and writer works fine with the same credentials. I can connect to the tables in the SQL transformers but when I hit run I get "authentication failed"

 

 

Anyone have an clue?

 

 

cheers

 

Henrik Rinne

 

 

 

Hi,

 

 

your question is strangely similar to the one below about SQL Server...

 

 

I just tested this with FME 2014 SP1 and postgresql 9.0 on Windows 7, and I had no problems using the SQLExecutor using the same connexion parameters as for the Postresql reader.

 

 

David

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
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.