Skip to main content
Question

PostgreSQL Gateway 2.0

  • February 6, 2025
  • 4 replies
  • 84 views

Forum|alt.badge.img+1

Hi Team, 

I am trying to Setup PostgreSQL Gateway 2.0 for loading data to CDF through Alteryx tool. But while following the steps provided on below link I am  facing below error. Is this something you can help ? 

https://docs.cognite.com/cdf/integration/guides/interfaces/postgres_gateway/

 

 

4 replies

  • Practitioner
  • February 6, 2025

Hi. In order to configure the postgres gateway you need the “postgresgateway:read” and “postgresgateway:write” ACLs. You should contact your administrator and have them grant you access to this through the Fusion UI.

 

See https://docs.cognite.com/cdf/access/guides/capabilities


Forum|alt.badge.img+1

Thanks, I will check this and get back to you. 


Forum|alt.badge.img+1

@Einar Omang  ​@Mithila Jayalath  After making changes as you suggested I am getting below error. 

{

    "error": {

        "code": 400,

        "message": "Failed to bind session: Nonce has expired or session has been revoked"

    }

}

 

What should I pass in the place of <SESSION NONCE>. Below is the Postman Body I am using. 

{
"items": [
{
"credentials": {
"nonce": "<SESSION NONCE>"
}
}
]
}


Mithila Jayalath
Seasoned Practitioner
Forum|alt.badge.img+8
  • Seasoned Practitioner
  • February 11, 2025

@Rajendra Pasupuleti try using the nonce string that gets returned when you create a session. Please refer to the documentation here.