Skip to main content
Solved

FME 2014 Postgre. authentication failed when query with SQL

  • May 15, 2014
  • 1 reply
  • 14 views
H
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

 

 

 

Best answer by david_r

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
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • May 15, 2014
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

Helpful Members This Week

Community Stats

31,378
Posts
119,008
Replies
39,008
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.