Get The Hostname Of Your PostgreSQL Deployment - ScaleGrid Docs

Getting Started

• Welcome to ScaleGrid Docs
• Getting Started with ScaleGrid
  • Dedicated Hosting Plans: ScaleGrid for PostgreSQL, Redis™, MySQL, and MongoDB®
  • Bring Your Own Cloud Plans: ScaleGrid for MongoDB, Redis™, MySQL, & PostgreSQL
• ScaleGrid Platform FAQ

Pricing

• ScaleGrid Pricing
• ScaleGrid Pricing FAQ
• Startup Program Overview
• Switching DBaaS Providers Overview

MongoDB

• Create a MongoDB® Cluster with ScaleGrid
  • New MongoDB® Cluster: Dedicated Hosting
  • New MongoDB® Cluster: Bring Your Own Cloud
• Connecting to MongoDB® Cluster with ScaleGrid
  • Connect Using Mongo Shell
  • Connect your Application to MongoDB® with ScaleGrid
  • MongoDB GUI® - Robo 3T Connection
• Create a Database User for MongoDB® with ScaleGrid
• Backups on ScaleGrid for MongoDB®
  • ScaleGrid for MongoDB® On-Demand Backups
  • ScaleGrid for MongoDB® Scheduled Backups
  • ScaleGrid for MongoDB® Selective Restore
  • Delete a MongoDB® Backup on ScaleGrid
• Restore for MongoDB® on ScaleGrid
• Features by Plan for MongoDB®
• MongoDB® - Data Centers
• Scalegrid Monitoring Console for MongoDB®
• Slow Query Analyzer for MongoDB®
• ScaleGrid Alerts & Rules for MongoDB®
  • Create MongoDB® Cluster Alert Rules
  • Create MongoDB® Account Alert Rules
• Migrations & Imports for MongoDB®
  • Import MongoDB® Data From a Remote Server
  • Import MongoDB® Data From an Existing ScaleGrid Cluster
  • Migrate Between Plans
  • MongoDB® Follower Clusters - Scheduled Sync
  • Live Migration for MongoDB®
• Dynamic Scaling for MongoDB®
• Scale MongoDB® Standalone to Replica Set
• Compact MongoDB®
• Setup MongoDB® Oplog Tailing
• CLI Tool for MongoDB® - Installation & Use
• Firewall Rules for MongoDB® with ScaleGrid
• Export Data Using mongodump
• Version Upgrades for MongoDB®

Redis™

• Create a Redis™ Deployment
  • New Redis™ Deployment: Dedicated Hosting
  • New Redis™ Deployment: Bring Your Own Cloud
• Connecting to Redis™
  • Connect to Redis™ via Command Line
  • Connect to Redis™ from Your Application
• Features For Redis™ By Plan
• Data Centers for Redis™
• Monitoring Console for Redis™
• Backups & Restores for Redis™
  • On-Demand Backups for Redis™
  • Scheduled Backups for Redis™
  • Restores for Redis™
  • Peek at Backup for Redis™
  • Delete a Backup for Redis™
• Alerts & Rules for Redis™
  • Create Cluster Alert Rules for Redis™
  • Create Account Alert Rules for Redis™
• Firewall Rules for Redis™
• Scaling Redis™
• OS Patching for Redis™
• Deleting a Redis™ Deployment
• Importing Redis™ Data From a Remote Server
• ScaleGrid CLI Tool for Redis™ Installation & Use

MySQL

• Create a MySQL Deployment
  • New MySQL Deployment: Dedicated Hosting
  • New MySQL Deployment: Bring Your Own Cloud
• Connecting to MySQL
  • Connect MySQL via Command Line
  • Connect To MySQL From Your Application
  • Get The Hostname of Your MySQL Deployment
  • WordPress 5 on Now ZEIT for MySQL
  • WordPress for MySQL
  • Prometheus and Grafana for MySQL
  • Node.js MySQL Connection
  • PHP MySQL Connection
  • Connect MySQL to PowerBI
  • Connect MySQL to Python application
  • Zapier - Creating new MySQL rows from Google Sheets rows
  • Zapier - Creating new Google Sheets rows from MySQL rows
• Connecting to a MySQL GUI
  • MySQL Workbench Connection
  • DBeaver MySQL Connection
  • TablePlus MySQL Connection
  • RazorSQL MySQL Connection
• MySQL - Data Centers
• MySQL Hosting Features by Plan
• Backups for MySQL
  • MySQL On-Demand Backups
  • MySQL Scheduled Backups
  • MySQL Selective Restores/Peek at Backup
  • Delete a MySQL Backup
• Restores for MySQL
• MySQL Firewalls
• MySQL Dynamic Scaling
• Scale MySQL Standalone to Replica Set
• Create a MySQL Database
• Create a MySQL Database User
• MySQL Alerts & Rules
  • Create MySQL Cluster Alert Rules
  • Create MySQL Account Alert Rules
• MySQL Slow Query Analyzer
• MySQL Monitoring Console
  • MySQL Overview Metrics
  • MySQL Operating System Metrics
  • MySQL InnoDB Metrics
  • MySQL Replication Metrics
• MySQL Configuration Settings
• MySQL Migrations
  • Importing MySQL Data From a Remote Server
  • Import a MySQL Database Using Command Line Tools
  • Export a MySQL Database Hosted on ScaleGrid
  • MySQL Follower Clusters - Scheduled Sync
  • Live Migration for MySQL

PostgreSQL

• Create a PostgreSQL Deployment
  • New PostgreSQL Deployment: Bring Your Own Cloud
  • New PostgreSQL Deployment: Dedicated Hosting
• Connecting to PostgreSQL
  • PostgreSQL Command Line Syntax
  • Get The Hostname of Your PostgreSQL Deployment
  • Node.js PostgreSQL Connection
  • Connecting PostgreSQL to PowerBI
• Connecting to a PostgreSQL GUI
  • DBeaver PostgreSQL Connection
  • TablePlus PostgreSQL Connection
  • RazorSQL PostgreSQL Connection
• Create a PostgreSQL User
• Backups for PostgreSQL
  • PostgreSQL On-Demand Backups
  • PostgreSQL Scheduled Backups
  • PostgreSQL Peek at Backup/Selective Restores
  • Delete a PostgreSQL Backup
  • PostgreSQL Backup Clone
• PostgreSQL Point In Time Recovery (PITR)
• Restores for PostgreSQL
• PostgreSQL Alerts & Rules
  • Create PostgreSQL Cluster Alert Rules
  • Create PostgreSQL Account Alert Rules
• PostgreSQL Firewalls
• PostgreSQL Slow Query Analyzer
• PostgreSQL Monitoring Console
• PostgreSQL Activity Stats
• PostgreSQL - Data Centers
• PostgreSQL Dynamic Scaling
• PostgreSQL Locale & Encoding FAQ
• PostgreSQL Supported Extensions
• Managing PgBouncer
• PostgreSQL OS Patching
• Deleting a PostgreSQL Deployment
• PostgreSQL Migrations & Imports
  • Importing PostgreSQL Data From a Remote Server
  • Import a PostgreSQL Database Using Command Line Tools
  • Export a PostgreSQL Database Hosted on ScaleGrid
  • PostgreSQL Follower Clusters - Scheduled Sync
• PostgreSQL CLI Tool Installation & Use

SQL Server

• SQL Server Gold Image Creation

Cloud Profiles

• What is a Cloud Profile?
• Setup an AWS EC2 Cloud Profile
  • Setup an AWS VPC Infrastructure for your Database Servers
  • Update AWS Cloud Profile Keys
• Setup an Azure (ARM) Cloud Profile
• Setup a GCP Cloud Profile
• Setup an Oracle Cloud Infrastructure (OCI) Cloud Profile
• Setup a DigitalOcean Cloud Profile
• Setup a Zadara Cloud Profile
  • Troubleshooting Zadara Cloud Profile Setup
• Setup a Akamai Linode Cloud Profile
  • Creating and Retrieving New StackScript
  • Getting Keys for Your Akamai Linode Cloud Profile

ScaleGrid Enterprise

• Quick Start Guide
• Prerequisites
• Controller Installation
• Controller Upgrade
• Support

ScaleGrid on VMware

• Deploying ScaleGrid vApp on your vCenter
• Prepare & Setup VMware vCenter for ScaleGrid Integration
• Setup a VMware Cloud Profile for PostgreSQL
• Setup a VMware Cloud Profile for SQL Server
• Restore ScaleGrid Controller

Billing and Accounts

• Team Accounts
• Change Password
• Two-Factor Authentication
• Firewall Rules
• Alert Rules
• Billing Info
• Invoices
• Update Credit Card
• Trial Accounts & Limitations
• Email Notifications
• Text Message Notifications
• PagerDuty Notifications
• Slack Notifications
• Opsgenie Notifications
• Resetting Admin User Credentials Provided by ScaleGrid
• SSO - SAML Setup
  • SSO - Azure AD SAML Configuration
  • SSO - Idaptive SAML Configuration
  • SSO - JumpCloud SAML Configuration
  • SSO - Okta SAML Configuration
• Projects & Maintenance Windows

Support

• Support Packages

ScaleGrid API

• The ScaleGrid API

Other

• Import ScaleGrid SSL certificate in Microsoft Windows
• Enabling Rsyslog

Powered by 

Want to connect your PostgreSQL deployment to your application and need to find your hostname? A hostname is a label or name that is assigned to a host connected to a computer network and that is used to identify the host in various forms of electronic communication.

Easily grab your host name through a few simple steps through your ScaleGrid account.

How to Find The Hostname of Your PostgreSQL Deployment

1. Log into the ScaleGrid console, or create a free 30-day trial.

🚧

Must have a PostgreSQL Deployment Setup

If you haven't already, you must first create a PostgreSQL deployment before you can grab your hostname.

2. Go to your PostgreSQL Cluster Details page and select the ‘Overview’ tab.
3. Find the Command Line Syntax section at the bottom of the page to copy the command that can be used to connect your PostgreSQL deployment through postgres client.

4. The server name following the ‘-h’ is the hostname of your PostgreSQL deployment, and in this particular case, it is ‘SG-help-1-master.devservers.scalegrid.io’.
5. Jot down your PostgreSQL hostname to use to connect to your website or application.

Updated 9 months ago

PostgreSQL Command Line SyntaxNode.js PostgreSQL ConnectionAsk AI