[Solved] PostgreSQL remote access

[closer]

Hi team,

 

I need remote access to the postgresql database from any ip. 

 

Server: tommy.heliohost.org

Postgresql user: "ducquang_main"

Postgresql database: "ducquang_crowdworks"

 

Thank you in advance

 

[wolstech]

Let's have Krydos set this up for you.

[closer]

  On 7/25/2018 at 2:42 AM, wolstech said:

Let's have Krydos set this up for you.

Thanks you!

[Krydos]

Remote access enabled.

[closer]

  On 7/25/2018 at 3:06 AM, Krydos said:

Remote access enabled.

Thanks you so much !

[closer]

  On 7/25/2018 at 3:06 AM, Krydos said:

Remote access enabled.

Hi Krydos,

I have an error insert data with id type serial:

"ERROR:  permission denied for sequence users_id_seq

SQL state: 42501"

please help me.

Thank you in advance

[Krydos]

Did you synchronize grants?

[closer]

  On 7/25/2018 at 12:43 PM, Krydos said:

Did you synchronize grants?

Yes, I synchronized grants but not working

[Krydos]

Which postgresql user are your trying with?

[closer]

  On 7/25/2018 at 2:43 PM, Krydos said:

Which postgresql user are your trying with?

user : ducquang_main

Only when I execute query use phppgadmin on cpanel it's fine. Run on others, it not working

[Krydos]

Try changing the password of ducquang_main. I deleted that user and recreated it and reassigned it to the database, but obviously I don't know what the password was.

[closer]

  On 7/25/2018 at 5:08 PM, Krydos said:

Krydos, on 26 Jul 2018 - 12:08 AM, said:

 

Try changing the password of ducquang_main. I deleted that user and recreated it and reassigned it to the database, but obviously I don't know what the password was.

thank you so much! it working