The user will initiate an SSH Session using an SSH Client, authenticating either using an Access Token copied from the Luminate User Portal or via a Luminate RSA Key (also issued via a Luminate User Portal). Schematically, the work session will look like the below: The end-user experience of accessing hosts inside corporate data center via SSH for end-users (in this case, Database Administrators) is explained in this article. In order to configure such access, please have a Luminate administrator refer to this article. Luminate supports native SSH access to hosts inside the corporate data center.

)Ĭommand-line tools for managing PostgreSQL databases require direct direct network access using P ostgreSQL frontend/backend protocol (TCP Port 5432), therefore the recommended approach is to deploy these tools on a machine inside the corporate data center (for example, on an SSH Bastion Server in the diagram above, or on another dedicated SSH machine, accessible via Luminate directly or by a Bastion server). Managing using command-line tools (psql, jpgAgent. The basic assumption is that there is no network connectivity between the DBA's PC and the corporate datacenter and that the access is being done via Luminate Security. The below diagram depicts the components of the system: This article explains how use any of the above (or similar) tools. Applications for Microsoft Windows, Mac OS X or Linux, such as pgAdminor sqlMaestro.Command-line tools, such as psql, or jpgAgent.PostgreSQL Databases can be managed using different types of tools: This article will explain the required configuration steps and the resulting end-user experience. Luminate allows Database Administrators to connect to PostgreSQL databases hosted in company data centers using various methods. For basic explanation about Luminate and how it works, please refer to this article. Luminate Security offers a Software-as-a-Service application access platform that allows users to connect to any kind of application hosted on any datacenter platform without the need to have a direct network connection.

Psql ssh tunnel