Connection to Dedicated PostgresQL Database-3 - How to connect and browse the PostgresSQL database

Video Transcription

Video Summary

This video tutorial explains how to connect to a dedicated PostgreSQL database using connection information provided on a page. It introduces PG Admin, an industry-standard tool for managing PostgreSQL databases. Users can download PG Admin to connect and explore their specific database schema. The tutorial emphasizes that connection strings are read-only and unique to each user, restricting access strictly to their assigned databases. It also clarifies the presence of multiple databases on the server, but users can only access their designated ones. Each tenant receives two databases ("full" and "five year") for data access and synchronization purposes.

Keywords

PostgreSQL

PG Admin

database connection

connection string

multi-tenant databases

KGConcept: Database Connection Details (10)

KGConcept: Third-Party Tools (7)

KGConcept: Custom Applications (7)

KGConcept: Analytics Products (6)

KGConcept: Synchronization Products (6)

KGConcept: PostgreSQL Database (10)

KGConcept: pgAdmin (9)

KGConcept: Host (8)

KGConcept: Port (8)

KGConcept: Username (8)

KGConcept: Password (8)

KGConcept: Database Name (8)

KGConcept: Credentials (9)

KGConcept: Example Credentials (6)

KGConcept: Read-Only Account (10)

KGConcept: Database Permissions (8)

KGConcept: Tenant (7)

KGConcept: Database (6)