Hosting Node with Postgres

To host Node on Container Hosting and connect to the Postgres database from it, you need to complete the following three steps.

1. Installing the project management utility

If your project files are in a Git repository, then installing the utility is not necessary, since you can run the project from the browser.

If you have installed the conhos utility earlier, then simply proceed to the next step. If you have not installed it, then use the Instructions to install it.

2. Creating a configuration file

If your project files are in a Git repository, you can create a configuration file from your browser.

Configuration file for creating a Node service in Container Hosting with a Postgres database server running and connecting to it from an application, and an optional example of updating Adminer to administer the database. More details in the Configuration File.

Check the current version of the Postgres container in the official Postgres repository

name: my-node-postgres-project
services:
  node1:
    image: node
    size: mili
    active: true
    version: ${{VERSION}}
    pwd: examples/node-postgres
    exclude:
      - node_modules
    command: npm i && npm run start
    ports:
      - port: 3000
        type: proxy
    depends_on: # The service should only start after the following services
      - postgres0 # postgres0 service
    environment:
      - PORT=3000
      # Next we forward the connection variables
      - POSTGRES_PASSWORD=value0
      - POSTGRES_USER=value1
      - POSTGRES_DB=value2
  postgres0:
    type: postgres
    size: mili
    active: true
    version: latest
    environment:
      # Variables for initializing the database
      - POSTGRES_PASSWORD=value0
      - POSTGRES_USER=value1
      - POSTGRES_DB=value2

The database host will be accessible in the application container via the environment variable [SERVICE_NAME]_HOST, for example for the service postgres0 the name of the host variable inside the container that references this service via depends_on will be POSTGRES0_HOST

3. Launching a project in the cloud

To upload files to the cloud and run services in containers, run the command:

conhos deploy

Continue studying

Hosting Node Redis <<< | >>> Hosting Node Mysql