PostgreSQL Database

  1. Installation and Basic Management
    1. Installing PostgreSQL
      1. Package Manager Installation
        1. APT Package Manager
          1. YUM Package Manager
            1. Homebrew
            2. Platform-Specific Installation
              1. Linux Installation
                1. Windows Installation
                  1. macOS Installation
                  2. Docker Installation
                    1. Source Compilation
                    2. Initial Server Setup
                      1. Database Cluster Initialization
                        1. initdb Command
                          1. Data Directory Initialization
                            1. Locale and Encoding Settings
                            2. Server Configuration Files
                              1. postgresql.conf
                                1. Location and Structure
                                  1. Key Parameters
                                  2. pg_hba.conf
                                    1. Authentication Rules
                                      1. Connection Types
                                      2. pg_ident.conf
                                        1. User Mapping
                                    2. Starting and Stopping the Server
                                      1. pg_ctl Command
                                        1. System Services
                                          1. systemd
                                            1. service Command
                                            2. Checking Server Status
                                              1. Restarting and Reloading Configuration
                                              2. Command-Line Tools
                                                1. psql Interactive Terminal
                                                  1. Connecting to Databases
                                                    1. Running SQL Commands
                                                      1. Meta-commands
                                                      2. pg_ctl Server Control
                                                        1. Start Operations
                                                          1. Stop Operations
                                                            1. Restart Operations
                                                              1. Reload Operations
                                                              2. Database Management Commands
                                                                1. createdb
                                                                  1. dropdb
                                                                  2. User Management Commands
                                                                    1. createuser
                                                                      1. dropuser
                                                                    2. Graphical User Interface Tools
                                                                      1. pgAdmin
                                                                        1. Features and Usage
                                                                        2. DBeaver
                                                                          1. Features and Usage
                                                                          2. Other GUI Tools

                                                                        Previous

                                                                        1. Introduction to PostgreSQL

                                                                        Go to top

                                                                        Next

                                                                        3. SQL Fundamentals in PostgreSQL