Yogesh Mahajan 2025년 8월 22일 관계형 데이터베이스, 특히 PostgreSQL을 관리할 때 직관적이고 사용하기 쉬운 인터페이스는 관리 및 개발 업무를 크게 단순화할 수 있습니다. pgAdmin 4는 PostgreSQL 및 EnterpriseDB의 EDB Advanced Server 같은 파생 데이터베이스를 위한 강력한 무료 오픈소스 그래픽 관리 도구입니다. pgAdmin은 다음 두 가지 주요 모드로 설치할 수 있습니다. 데스크톱 모드: 독립 실행형 애플리케이션으로 구동 서버 모드: 웹 브라우저를 통한 원격 접근 지원 서버 모드에서는 Apache2 또는 Nginx 같은 웹 서버 뒤에 배치할 수 있어 팀과 프로덕션 환경에서도 확장 가능한 솔루션을 제공합니다. 이 글에서는 Windows IIS...

When managing relational databases, especially PostgreSQL, having a user-friendly interface can significantly streamline administration and development tasks. pgAdmin 4 is a powerful, free, open-source graphical management tool designed for PostgreSQL and derivative databases like EnterpriseDB’s EDB Advanced Server. pgadmin can be installed in two primary modes: Desktop mode, which runs as a...

This blog explains and provides a walkthrough of the process of creating a Google Cloud SQL PostgreSQL database from pgAdmin 4 and registering it with pgAdmin.

This blog explains and provides a walkthrough of the pgAdmin AWS RDS deployment wizard which can be used to deploy a new PostgreSQL database in the Amazon AWS cloud and register it with pgAdmin so you can begin working with it immediately.

This blog explains pgAdmin 4 architecture and the technologies used. The blog provides high-level information about how pgAdmin 4 supports third party authentication and consuming cloud provider services, to deploy Postgres instances on cloud.

pgAdmin 4 is the most popular and the most feature rich Open Source administration and development platform for PostgreSQL. pgAdmin can be run either in desktop mode (single user) or server mode (multi user). In server mode, pgAdmin can be accessed using a browser on a local operating system. pgAdmin follows an Agile development process with an iterative and incremental approach to development...

This blog will guide you to reverse proxy to pgAdmin using Nginx and uWSGI on Debian or Ubuntu Linux. The process is the same on other Linux distributions, but file, directory, and service names may differ.

Yogesh Mahajan guides you through the process of setting up the apache2 webserver authentication with HTTP BASIC auth in pgAdmin 4, on Debian or Ubuntu Linux.