Postgres - afalarcon/n8n GitHub Wiki

bd Postgres

There implementation the postgres on container docker, does the create in user and password, and include command necesary for the funtionality sucess.

command's

command to get into the bd

  1. docker exec -it <'name image docker'> psql -U <'user bd> -d <name bd'>
    Command to create user in bd
  2. CREATE USER WITH PASSWORD <'DESCRIPT PASSWORD'> Command to create a database and user who was created
  3. CREATE DATABASE <'NAME NEW BD'> OWNER <'USER BD'> Command to privilege the user in the database
  4. GRANT ALL PRIVILEGES ON DATABASE <'name bd'> TO <'user privilege'>

${CONFIG_SESSION_PHONE_VERSION}

Create Data 5-06-2025 to postgres access

  • CREATE USER n8nuser WITH PASSWORD 'n8npass';
  • CREATE DATABASE n8ndb_ OWNER n8nuser;
  • GRANT ALL PRIVILEGE ON DATABASE n8ndb_ TO n8nuser
⚠️ **GitHub.com Fallback** ⚠️