{"id":1994,"date":"2024-06-27T12:53:06","date_gmt":"2024-06-27T12:53:06","guid":{"rendered":"https:\/\/www.w3computing.com\/articles\/?p=1994"},"modified":"2024-06-27T12:53:15","modified_gmt":"2024-06-27T12:53:15","slug":"how-to-set-up-a-postgresql-database-on-ubuntu","status":"publish","type":"post","link":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/","title":{"rendered":"How to Set Up a PostgreSQL Database on Ubuntu"},"content":{"rendered":"\n

Introduction<\/h3>\n\n\n\n

PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development. It boasts a strong reputation for reliability, feature robustness, and performance. This tutorial aims to provide a comprehensive guide for setting up a PostgreSQL database on Ubuntu, targeting users who have some experience with Linux systems and are familiar with database concepts.<\/p>\n\n\n\n

Prerequisites<\/h3>\n\n\n\n

Before we begin, ensure that you have the following:<\/p>\n\n\n\n

    \n
  1. An Ubuntu system (preferably the latest LTS version).<\/li>\n\n\n\n
  2. Root or sudo user privileges.<\/li>\n\n\n\n
  3. Basic understanding of Linux command line.<\/li>\n<\/ol>\n\n\n\n

    Step 1: Update the System<\/h3>\n\n\n\n

    First, it’s crucial to update your package lists to ensure you have the latest information on the newest versions of packages and their dependencies.<\/p>\n\n\n

    sudo apt update\nsudo apt upgrade -y<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 2: Install PostgreSQL<\/h3>\n\n\n\n
    Ubuntu includes PostgreSQL by default in its repositories, which makes the installation straightforward. Run the following command to install PostgreSQL and the contrib<\/code> package, which provides additional functionalities.<\/p>\n\n\n
    sudo apt install postgresql postgresql-contrib -y<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 3: Verify Installation<\/h3>\n\n\n\n
    After the installation, you can verify the PostgreSQL service status to ensure it is running correctly.<\/p>\n\n\n
    sudo systemctl status postgresql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    You should see output indicating that PostgreSQL is active and running.<\/p>\n\n\n\n
    Step 4: PostgreSQL Basic Configuration<\/h3>\n\n\n\n
    PostgreSQL operates with a default user called postgres<\/code>. To interact with the PostgreSQL database, you need to switch to this user.<\/p>\n\n\n
    sudo -i -u postgres<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Access PostgreSQL Prompt<\/h4>\n\n\n\n
    While logged in as the postgres<\/code> user, open the PostgreSQL prompt using the psql<\/code> command.<\/p>\n\n\n
    psql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    You should see the PostgreSQL prompt:<\/p>\n\n\n
    postgres=#<\/span><\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Create a New Role<\/h4>\n\n\n\n
    To create a new PostgreSQL role (user), use the following SQL command. Replace username<\/code> with your desired username.<\/p>\n\n\n
    CREATE<\/span> ROLE<\/span> username WITH<\/span> LOGIN PASSWORD<\/span> 'password'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Grant Superuser Privileges<\/h4>\n\n\n\n
    Optionally, you can grant this user superuser privileges:<\/p>\n\n\n
    ALTER<\/span> ROLE<\/span> username WITH<\/span> SUPERUSER;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Exit PostgreSQL Prompt<\/h4>\n\n\n\n
    To exit the PostgreSQL prompt, type:<\/p>\n\n\n
    \\q<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 5: Create a New Database<\/h3>\n\n\n\n
    Still logged in as the postgres<\/code> user, you can create a new database. Replace mydatabase<\/code> with your desired database name.<\/p>\n\n\n
    createdb mydatabase<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 6: Adjusting Authentication Methods<\/h3>\n\n\n\n
    PostgreSQL uses a file called pg_hba.conf<\/code> to control client authentication. By default, this file is located in the \/etc\/postgresql\/12\/main\/<\/code> directory (version number may vary).<\/p>\n\n\n
    sudo nano \/etc\/postgresql\/12\/main\/pg_hba.conf<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    In this file, you can adjust authentication methods for local connections. For example, to use MD5-encrypted passwords for all users, you might modify the following lines:<\/p>\n\n\n
    # Database administrative login by Unix domain socket\nlocal   all             postgres                                peer\n\n# TYPE  DATABASE        USER            ADDRESS                 METHOD\nlocal   all             all                                     md5<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Save and close the file (Ctrl + X, Y, Enter).<\/p>\n\n\n\n
    Step 7: Restart PostgreSQL Service<\/h3>\n\n\n\n
    After making changes to the configuration file, restart the PostgreSQL service to apply the changes.<\/p>\n\n\n
    sudo systemctl restart postgresql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 8: Connect to the PostgreSQL Database<\/h3>\n\n\n\n
    You can now connect to the newly created database using the new role. Exit the postgres<\/code> user if you haven’t already.<\/p>\n\n\n
    exit<\/span><\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Connect to your database:<\/p>\n\n\n
    psql -U username -d mydatabase -h 127.0.0.1 -W<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    You’ll be prompted to enter the password for the username<\/code> role.<\/p>\n\n\n\n
    Step 9: Basic PostgreSQL Operations<\/h3>\n\n\n\n
    Once connected to your database, you can perform basic operations. Here are a few examples:<\/p>\n\n\n\n
    Create a Table<\/h4>\n\n\n
    CREATE<\/span> TABLE<\/span> employees (\n    id<\/span> SERIAL<\/span> PRIMARY KEY<\/span>,\n    name<\/span> VARCHAR<\/span>(100<\/span>),\n    position<\/span> VARCHAR<\/span>(100<\/span>),\n    salary NUMERIC<\/span>\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Insert Data<\/h4>\n\n\n
    INSERT<\/span> INTO<\/span> employees (name<\/span>, position<\/span>, salary) VALUES<\/span> ('Alice'<\/span>, 'Engineer'<\/span>, 60000<\/span>);\nINSERT<\/span> INTO<\/span> employees (name<\/span>, position<\/span>, salary) VALUES<\/span> ('Bob'<\/span>, 'Manager'<\/span>, 80000<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Query Data<\/h4>\n\n\n
    SELECT<\/span> * FROM<\/span> employees;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Update Data<\/h4>\n\n\n
    UPDATE<\/span> employees SET<\/span> salary = 65000<\/span> WHERE<\/span> name<\/span> = 'Alice'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Delete Data<\/h4>\n\n\n
    DELETE<\/span> FROM<\/span> employees WHERE<\/span> name<\/span> = 'Bob'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 10: Backup and Restore<\/h3>\n\n\n\n
    Backing up and restoring your PostgreSQL database is crucial for data safety.<\/p>\n\n\n\n
    Backup a Database<\/h4>\n\n\n\n
    You can use the pg_dump<\/code> tool to back up a database. Run the following command, replacing mydatabase<\/code> and backup.sql<\/code> with your database name and desired backup file name.<\/p>\n\n\n
    pg_dump -U username -d mydatabase -F c -f backup.sql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Restore a Database<\/h4>\n\n\n\n
    To restore a database, use the pg_restore<\/code> tool. First, create a new database to restore the data into:<\/p>\n\n\n
    createdb newdatabase<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Then, restore the backup:<\/p>\n\n\n
    pg_restore -U username -d newdatabase -1 backup.sql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 11: Automating Tasks with Cron<\/h3>\n\n\n\n
    To automate backups, you can create a cron job. Edit the crontab file:<\/p>\n\n\n
    crontab -e<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Add a cron job to back up your database daily at 2 AM:<\/p>\n\n\n
    0 2 * * * pg_dump -U username -d mydatabase -F c -f \/path\/to\/backup\/backup_$(date +\\%F).sql<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Step 12: Securing PostgreSQL<\/h3>\n\n\n\n
    Securing your PostgreSQL installation is vital. Here are a few recommendations:<\/p>\n\n\n\n
    Use Strong Passwords<\/h4>\n\n\n\n
    Ensure all your PostgreSQL roles use strong passwords.<\/p>\n\n\n\n
    Restrict Remote Access<\/h4>\n\n\n\n
    By default, PostgreSQL listens on localhost<\/code>. To allow remote connections, modify the postgresql.conf<\/code> file:<\/p>\n\n\n
    sudo nano \/etc\/postgresql\/12\/main\/postgresql.conf<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
    Uncomment and set the listen_addresses<\/code> line to:<\/p>\n\n\n
    listen_addresses = 'localhost'<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    To allow specific IP addresses, adjust the pg_hba.conf<\/code> file accordingly.<\/p>\n\n\n\n
    Enable SSL<\/h4>\n\n\n\n
    Enabling SSL encrypts connections between clients and the database server. You can enable SSL in the postgresql.conf<\/code> file:<\/p>\n\n\n
    ssl = on<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    You’ll need SSL certificates, which you can generate or obtain from a certificate authority.<\/p>\n\n\n\n
    Step 13: Performance Tuning<\/h3>\n\n\n\n
    Optimizing PostgreSQL performance involves tuning various settings in the postgresql.conf<\/code> file. Key settings to consider include:<\/p>\n\n\n\n
    Shared Buffers<\/h4>\n\n\n
    shared_buffers = 25% of total RAM<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Work Mem<\/h4>\n\n\n
    work_mem = 4MB or more, depending on your workload<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Maintenance Work Mem<\/h4>\n\n\n
    maintenance_work_mem = 64MB or more<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Effective Cache Size<\/h4>\n\n\n
    effective_cache_size = 50% to 75% of total RAM<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Conclusion<\/h3>\n\n\n\n
    Setting up PostgreSQL on Ubuntu involves several steps, from installation and configuration to securing and optimizing your database. By following this comprehensive guide, you should have a robust PostgreSQL installation ready for development or production use. Remember, ongoing maintenance and regular backups are crucial to ensure your database remains secure and performant.<\/p>\n\n\n\n
    Further Reading<\/h3>\n\n\n\n
    For more advanced topics and detailed configuration options, refer to the official PostgreSQL documentation: PostgreSQL Documentation<\/a>.<\/p>\n\n\n\n
    This tutorial should provide a solid foundation for setting up and managing a PostgreSQL database on Ubuntu. Adjust configurations and settings based on your specific requirements and workload to get the best performance and security for your database system.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Introduction PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development. It boasts a strong reputation for reliability, feature robustness, and performance. This tutorial aims to provide a comprehensive guide for setting up a PostgreSQL database on Ubuntu, targeting users who have some experience with Linux systems and are familiar […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14,22],"tags":[],"class_list":["post-1994","post","type-post","status-publish","format-standard","category-database-development","category-postgresql","entry"],"yoast_head":"\nHow to Set Up a PostgreSQL Database on Ubuntu<\/title>\n<meta name=\"description\" content=\"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Set Up a PostgreSQL Database on Ubuntu\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-27T12:53:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-27T12:53:15+00:00\" \/>\n<meta name=\"author\" content=\"w3compadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"w3compadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/\"},\"author\":{\"name\":\"w3compadmin\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\"},\"headline\":\"How to Set Up a PostgreSQL Database on Ubuntu\",\"datePublished\":\"2024-06-27T12:53:06+00:00\",\"dateModified\":\"2024-06-27T12:53:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/\"},\"wordCount\":772,\"articleSection\":[\"Database Development\",\"PostgreSQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/\",\"name\":\"How to Set Up a PostgreSQL Database on Ubuntu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#website\"},\"datePublished\":\"2024-06-27T12:53:06+00:00\",\"dateModified\":\"2024-06-27T12:53:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\"},\"description\":\"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/how-to-set-up-a-postgresql-database-on-ubuntu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Articles Home\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Development\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/database-development\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Set Up a PostgreSQL Database on Ubuntu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/\",\"name\":\"Developer Articles Hub\",\"description\":\"\",\"alternateName\":\"Developer Articles\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/#\\\/schema\\\/person\\\/a550b3e20d78bb4f79b7c6b7b53f0561\",\"name\":\"w3compadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266\",\"contentUrl\":\"https:\\\/\\\/www.w3computing.com\\\/articles\\\/wp-content\\\/litespeed\\\/avatar\\\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266\",\"caption\":\"w3compadmin\"},\"sameAs\":[\"http:\\\/\\\/w3computing.com\\\/articles\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Set Up a PostgreSQL Database on Ubuntu","description":"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"How to Set Up a PostgreSQL Database on Ubuntu","og_description":"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.","og_url":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/","article_published_time":"2024-06-27T12:53:06+00:00","article_modified_time":"2024-06-27T12:53:15+00:00","author":"w3compadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"w3compadmin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/#article","isPartOf":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/"},"author":{"name":"w3compadmin","@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561"},"headline":"How to Set Up a PostgreSQL Database on Ubuntu","datePublished":"2024-06-27T12:53:06+00:00","dateModified":"2024-06-27T12:53:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/"},"wordCount":772,"articleSection":["Database Development","PostgreSQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/","url":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/","name":"How to Set Up a PostgreSQL Database on Ubuntu","isPartOf":{"@id":"https:\/\/www.w3computing.com\/articles\/#website"},"datePublished":"2024-06-27T12:53:06+00:00","dateModified":"2024-06-27T12:53:15+00:00","author":{"@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561"},"description":"PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development.","breadcrumb":{"@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.w3computing.com\/articles\/how-to-set-up-a-postgresql-database-on-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Articles Home","item":"https:\/\/www.w3computing.com\/articles\/"},{"@type":"ListItem","position":2,"name":"Database Development","item":"https:\/\/www.w3computing.com\/articles\/database-development\/"},{"@type":"ListItem","position":3,"name":"How to Set Up a PostgreSQL Database on Ubuntu"}]},{"@type":"WebSite","@id":"https:\/\/www.w3computing.com\/articles\/#website","url":"https:\/\/www.w3computing.com\/articles\/","name":"Developer Articles Hub","description":"","alternateName":"Developer Articles","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.w3computing.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.w3computing.com\/articles\/#\/schema\/person\/a550b3e20d78bb4f79b7c6b7b53f0561","name":"w3compadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266","url":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266","contentUrl":"https:\/\/www.w3computing.com\/articles\/wp-content\/litespeed\/avatar\/bd481d404e42caa2763662a3bfe825f8.jpg?ver=1780141266","caption":"w3compadmin"},"sameAs":["http:\/\/w3computing.com\/articles"]}]}},"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":"w3compadmin","author_link":"https:\/\/www.w3computing.com\/articles\/author\/w3compadmin\/"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/1994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/comments?post=1994"}],"version-history":[{"count":1,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/1994\/revisions"}],"predecessor-version":[{"id":1995,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/posts\/1994\/revisions\/1995"}],"wp:attachment":[{"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/media?parent=1994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/categories?post=1994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.w3computing.com\/articles\/wp-json\/wp\/v2\/tags?post=1994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}