Jump to content


Photo

[Solved] remote access for PostgreSQL


  • This topic is locked This topic is locked
5 replies to this topic

#1 burnie

burnie

    Newbie

  • Members
  • 5 posts

Posted 08 December 2019 - 01:27 PM

Hello everybody,

 

a while ago I asked for a remote access for my Postgres database...

 

https://www.helionet...for-postgresql/

This works great. But now I created another database, hopefully the last one for the near future, and I need remote access for that one as well...

 

database: burnie_gems_of_war

 

users that needs remote access: "burnie", "burnie_guest" and "burnie_user"

 

Thanks a lot!

 



#2 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 2,445 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 08 December 2019 - 02:43 PM

This support request is being escalated to our root admin.
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#3 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 20,593 posts
  • Gender:Male

Posted 09 December 2019 - 12:26 AM

Remote access enabled.

#4 burnie

burnie

    Newbie

  • Members
  • 5 posts

Posted 11 December 2019 - 02:23 PM

Thanks a lot! Everything works like expected :)

 

But I have another question. What is the best way to get access to the logfiles of the database? I want to insert a bunch of data next using SQL files and I want to log this all. I noticed that the logfiles of the database are stored in a directory that I can't access.



#5 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 20,593 posts
  • Gender:Male

Posted 12 December 2019 - 12:54 AM

You'll need to log your sql queries on your own. The reason you can't access the logs is because they may contain sensitive information of other users.

#6 burnie

burnie

    Newbie

  • Members
  • 5 posts

Posted 12 December 2019 - 07:57 AM

Hi Krydos,

 

thanks for your answer! I'm doing it that way now that I simulate everything on my localhost. That's OK for now.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users