How to install PostgreSQL - Ubuntu 24
PHP Developer, Laravel Lover ❤️, Entrepreneur, Founder @ Bee Delivery
Search for a command to run...
PHP Developer, Laravel Lover ❤️, Entrepreneur, Founder @ Bee Delivery
No comments yet. Be the first to comment.
Coolify is an open-source, self-hostable Platform as a Service (PaaS) — a powerful alternative to Vercel, Heroku, and Netlify. It lets you deploy static sites, full-stack applications, databases, and
Sign up for DigitalOcean using my link and get $200 for your projects, valid for 60 days! Click here: GET $200 This tutorial is available as a video on YouTube: https://www.youtube.com/watch?v=KZh9Wodsa40 Updating the Operating System Step 1 - Update...
Cadastre-se na DigitalOcean, basta usar o meu link e ganhar $200 dĂłlares para seus projetos, válidos por 60 dias! Clique em: QUERO OS 200tĂŁo Este tutorial esta disponĂvel em vĂdeo no YouTube: https://www.youtube.com/watch?v=KZh9Wodsa40 Atualizando o ...
📌 1. Instalar PostgreSQL Atualize os pacotes e instale o servidor PostgreSQL: sudo apt update && sudo apt upgrade -y Instale o servidor PostgreSQL sudo apt install postgresql postgresql-contrib -y Verifique se o serviço está ativo: sudo systemctl ...
Update packages and install PostgreSQL server:
sudo apt update && sudo apt upgrade -y
Install PostgreSQL server
sudo apt install postgresql postgresql-contrib -y
Check if the service is active:
sudo systemctl status postgresql
Switch to the administrative postgres user:
sudo -i -u postgres
Open the PostgreSQL prompt:
psql
Now execute the SQL commands:
-- Create database
CREATE DATABASE n8n_db;
-- Change postgres user password
ALTER USER postgres PASSWORD 'your_new_password';
-- Grant permissions to the user on the database
GRANT ALL PRIVILEGES ON DATABASE n8n_db TO postgres;