Como instalar o 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
📌 1. Install PostgreSQL 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 postgre...
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 ...
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 status postgresql
Entre no usuário administrativo postgres:
sudo -i -u postgres
Abra o prompt do PostgreSQL:
psql
Agora execute os comandos SQL:
-- Criar banco de dados
CREATE DATABASE n8n_db;
-- Alterar a senha do usuario postgres
ALTER USER postgres PASSWORD 'sua_nova_senha';
-- Dar permissões ao usuário no banco
GRANT ALL PRIVILEGES ON DATABASE n8n_db TO postgres;