1) Cek file-nya ada

ls -l servicesv2.sh

2) convert CRLF -> LF

sed -i 's/\r$//' servicesv2.sh

3) Bikin executable

chmod +x servicesv2.sh

4) Tampilkan template .env (INI COMMAND TERPISAH)

./servicesv2.sh env-example

5) Install dependensi

./servicesv2.sh install

6) Start services

./servicesv2.sh start

7) Cek status

./servicesv2.sh status

8) Grant Access to n8n Database User

To set up proper permissions for the n8n user in your PostgreSQL database, run the following commands:

sudo -u postgres psql -d postgres -c "GRANT CONNECT ON DATABASE postgres TO n8n;"
sudo -u postgres psql -d postgres -c "GRANT USAGE, CREATE ON SCHEMA public TO n8n;"
sudo -u postgres psql -d postgres -c "ALTER SCHEMA public OWNER TO n8n;"
sudo -u postgres psql -d postgres -c "REVOKE CREATE ON SCHEMA public FROM PUBLIC;"

Explanation:

• GRANT CONNECT: Allows n8n to connect to the postgres database.
• GRANT USAGE, CREATE: Gives n8n permission to use and create objects in the public schema.
• ALTER SCHEMA OWNER: Changes the owner of the public schema to n8n.
• REVOKE CREATE FROM PUBLIC: Removes create privileges from all other users on the public schema.

💡 Tip: Run each command in your terminal for proper access