PostgreSQL

PostgresQL is a free and open-source object-relational database management system emphasizing extensibility and standards compliance.

Subscribe to PostgreSQL
Get notified when new articles on PostgreSQL are published.
    All
  • 20 Results
    • Question

      How do I access database as a superuser from app platform?

      I don’t see anywhere in the settings for my database set up in app platform to manage the users, or access the password for doadmin to access superuser features like enabling Telemetry in the timescaledb extension. Ho...
      1 answer14 days agoBy jjfantiniDigitalOcean App PlatformDigitalOcean Managed PostgreSQL DatabasePostgreSQL
    • Question

      How do I use Timescale DB with Managed Postgres in App Platform

      I was reading the tutorial on how to download timescaleDB on Ubuntu , but it did not seem to provide instructions on how to use on a Postgres managed database that is spun up from the app platform PaaS. Is this possib...
      1 answer15 days agoBy jjfantiniDatabasesDigitalOcean App PlatformDigitalOcean Managed PostgreSQL DatabasePostgreSQL
    • Tutorial

      How To Install and Use PostgreSQL on Ubuntu 22.04

      PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 22.04 server. It also prov...
      21 days agoBy Mark Drake, Kong YangDatabasesPostgreSQLUbuntuUbuntu 22.04Interactive
    • Tutorial

      How To Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 22.04

      Django is a powerful web framework that can help you get your Python application or website off the ground. Django includes a simplified development server for testing your code locally, but for anything even slightly...
      22 days agoBy Erin Glass, Jamon CamissoDatabasesDjangoNginxPostgreSQLPythonPython FrameworksUbuntu
    • Tutorial

      How To Install PostgreSQL on Ubuntu 22.04 [Quickstart]

      PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This quickstart guide demonstrates how to install Postgres on an Ubuntu 22.04 server. I...
      22 days agoBy Alex GarnettDatabasesPostgreSQLQuickstartUbuntuUbuntu 22.04Interactive
    • Question

      How to connect APP Platform to external database?

      I have an APP that I have just deployed to the APP Platform. It looks like it runs fine, but I cannot connect to my remote database. In order to connect to the remote database, I need to add the APP’s IP to the securi...
      1 answer22 days agoBy sergio t. ruizDatabasesDigitalOcean App PlatformPostgreSQL
    • Question

      Upgrading to multi core

      When I upgrade to a multi-core (from 1 vCPU to 2 vCPU) do I need to upgrade anything (besides my code) to take advantage of 2 vCPU? If I simply resized my droplet without a brand new Ubuntu install, if my python singl...
      1 answer24 days agoBy CodingMonkeyApplicationsBig DataData AnalysisPostgreSQLPythonSystem ToolsUbuntu
    • Question

      Choosing CPU level

      Hi, I am running a basic droplet that caps out at 100% CPU for 3 hours a day (if it doesn’t lock up) when running a data analysis script. It’s a bunch of scripts that run to analyze data and put it into a database to ...
      1 answer25 days agoBy CodingMonkeyApplicationsDjangoPostgreSQL
    • Question

      How to time SQL queries using psql?

      Being able to tell how much time a query takes to run can be very useful when you’re trying to optimize your queries. In this post, we’ll show you how to do this using the psql command-line tool.
      Accepted Answer: Hello, One of the most straightforward ways to time a query is to use the following: First, connect to the database using psql: psql -h localhost -p 5432 -U postgres Note that you would need to have the psql command i...
      1 answer29 days agoBy Bobby IlievDatabasesDigitalOcean Managed PostgreSQL DatabasePostgreSQLSQL
    • Question

      Django (App Platform) Migrate Command raises ERROR: "could not translate host name '[...]' to address: Temporary failure in name resolution'

      I re-deployed my Django App on DO’s app platform but I am facing a new issue that I did not encounter before. Once successfully deployed, when I try to go into the console and run Django’s Migrate Command (python mana...
      1 answer29 days agoBy Al3xsDeploymentDigitalOcean App PlatformDigitalOcean Managed PostgreSQL DatabaseDjangoPostgreSQL
    • Question

      Configuring POSTGRESQL To Auto-start After Boot using systemd

      I’m using PostgreSQL and it often stops working.I want the service of ‘postgreql’ to start automatically according to the article Configuring MYSQL To Auto-start After Boot using systemd which I have tried following b...
      2 answers1 month agoBy suraphanPostgreSQL
    • Question

      Performance of Postgresql Merge vs Insert & Update statements

      I would like to know will my performance of my SP’s written in postgresql is going to improve if I move my insert and update statement to the merge statement or it will hamper the performance. Also if you can provide ...
      1 answer1 month agoBy 8c8e3786132d-43ad-9044-3923e0PostgreSQL
    • Question

      Completely block IP from accessing server and postgresql

      Hi, OS - UBUNTU 20.04 Problem: Recently our server and database (postgresql) being attacked by specific IP (45.155.204.146). The IP keep on trying to connect to our database and we believe subsequently cause our postg...
      1 answer1 month agoBy CuteGreenBlueMantaRayFirewallPostgreSQL
    • Question

      Granting `pg_read_all_data` to a new user

      I’m on a managed DO Postgres 14 cluster, and it has the pg_read_all_data role. After creating a new user called backup using the DO interface, I tried to log in as doadmin and executing: GRANT pg_read_all_data TO back...
      1 answer1 month agoBy sligDigitalOcean Managed PostgreSQL DatabasePostgreSQL
    • Question

      What does adding POSTGRES env variables achieve? Django + Postgres DB

      As I have a Django App (using the app platform) with a connected DB, the connection to the DB seems to work out of the box. However, some tutorials online suggest I add the following env variables to my app: POSTGRES_...
      1 answer2 months agoBy frfaDjangoPostgreSQL
    • Question

      The email has been received locally, but I couldn't read it through POP3 / imap?

      Maillog doesn’t show any errors. I see a new email in my / home / mail / domain / user / new. I just can’t read the email by using the client or telnet 110 / 143. Dovecot info The log doesn’t seem to show any errors. ...
      No answers yet2 months agoBy GiantElectricBlueShipCentOSMessagingNetworkingPostgreSQL
    • Question

      504 Gateway Timeout NGinx

      I am running into a 504 gateway timeout error with my express API. I have a droplet using docker-compose to spin up all the resources. When doing research into the issue people say usually you run out of ram but my me...
      1 answer2 months agoBy SleepingAquamarineClamAPINginxNode.jsPostgreSQL
    • Question

      Can't connect to the server in local environment

      Hello, After running npm run develop I got this error: > [email protected] develop > strapi develop [2022-03-20 02:02:35.443] debug: ⛔️ Server wasn't able to start properly. [2022-03-20 02:02:35.444] error: connect ...
      1 answer2 months agoBy ChrisB007Node.jsPostgreSQLStrapi
    • Tutorial

      How To Install PostgreSQL on Ubuntu 20.04 [Quickstart]

      PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This quickstart guide demonstrates how to install Postgres on an Ubuntu 20.04 server. I...
      2 months agoBy Mark DrakeInteractivePostgreSQLDatabasesUbuntuUbuntu 20.04Quickstart
    • Tutorial

      How To Install and Use PostgreSQL on Ubuntu 20.04

      PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 20.04 server. It also prov...
      2 months agoBy Mark DrakeInteractiveDatabasesPostgreSQLUbuntuUbuntu 20.04