Downloads - PostgreSQL
WEBPostgreSQL Downloads. PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself.
Documentation - PostgreSQL
WEBSep 5, 2024 · Documentation . View the manual. Manuals . You can view the manual for an older version or download a PDF of a manual from the below table.
Windows installers - PostgreSQL
WEBSep 5, 2024 · Windows installers Interactive installer by EDB. Download the installer certified by EDB for all supported PostgreSQL versions.. Note! This installer is hosted by EDB and not on the PostgreSQL community servers.
PostgreSQL: The world's most advanced open source database
WEBPostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. There is a wealth of information to be found describing how to install and use PostgreSQL through the official documentation.
PostgreSQL: Documentation: 16: psql
WEBBoth the system-wide startup file and the user's personal startup file can be made psql -version-specific by appending a dash and the PostgreSQL major or minor release identifier to the file name, for example ~/.psqlrc-16 or ~/.psqlrc-16.4.
About - PostgreSQL
WEBSep 5, 2024 · PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of …
PostgreSQL: Documentation: 16: 26.1. SQL Dump
WEBpg_dump dumps only a single database at a time, and it does not dump information about roles or tablespaces (because those are cluster-wide rather than per-database). To support convenient dumping of the entire contents of a database cluster, the pg_dumpall program is provided. pg_dumpall backs up each database in a given cluster, and also preserves cluster-wide data such as role and ...
Chapter 26. Backup and Restore - PostgreSQL
WEBWhile the procedure is essentially simple, it is important to have a clear understanding of the underlying techniques and assumptions. There are three fundamentally different approaches to backing up PostgreSQL data: Each has its own strengths and weaknesses; each is discussed in turn in the following sections. 25.3. Log File Maintenance.
PostgreSQL: Documentation: 16: 8.1. Numeric Types
WEBThe type numeric can store numbers with a very large number of digits. It is especially recommended for storing monetary amounts and other quantities where exactness is required. Calculations with numeric values yield exact results where possible, e.g., addition, subtraction, multiplication. However, calculations on numeric values are very slow compared to the integer types, or to the floating ...
PostgreSQL: Documentation: 16: 1.1. Installation
WEB1.1. Installation. Chapter 1. Getting Started. 1.1. Installation #. Before you can use PostgreSQL you need to install it, of course. It is possible that PostgreSQL is already installed at your site, either because it was included in your operating system distribution or because the system administrator already installed it. If that is the case ...
Skip to content