AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Ubuntu configure postgresql12/12/2023 APT uses this GPG key to verify the repository package authenticity. The step2 adds the Postgres GPG (GNU Private Guard) key to the APT package manager. Step 2: Import the repository signing key $ sudo sh -c ‘echo “deb $(lsb_release -cs)-pgdg main” > /etc/apt//pgdg.list’ The pgdg.list stores the Postgres official repository as per your Ubuntu version. This step fetches the latest Postgres repository information using the following script. Step 1: Create a file repository configuration for the PostgreSQL You can use the following steps to install Postgres’s latest version on Ubuntu 20.04 LTS. The Apt Repository supports the following Ubuntu versions. The PostgreSQL Apt Repository lets users install the latest Postgres version on Ubuntu. Install PostgreSQL from PostgreSQL Apt Repository We will also cover basic setup tasks, such as setting the default password and creating a new user. In this tutorial, I will walk you through installing Postgres on Ubuntu 20.04.5 LTS. Native support for horizontal scaling with sharding and read replicas. Support for PL/pgSQL, Perl, Python, Tcl, Java, JavaScript (V8), R, Lua, JSON, and Rust Performance: PostgreSQL supports the following features optimized performance.ī-tree, Composite (Multi-column), Gist, GIN, BRIN, Covering indexesĪCID property (Atomicity, Consistency, Isolation, Durability) The PostgreSQL valuable features are as below:ĭata Types: It supports various data types such as Integer, Numeric, String, Boolean, Date/Time, Array, JSON, XML, Point, Line, Circle, Polygon, and Composite types. PostgreSQL, a popular relational database management system, emphasizes compliance and extensibility. This article covers the different methods to install Postgres on Ubuntu.
0 Comments
Read More
Leave a Reply. |