DEV Community: Tony Zheng

RDS while connection error: no pg_hba.conf entry for host

Tony Zheng — Tue, 30 Apr 2024 19:24:43 +0000

Create a New Parameter Group:

Open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the navigation pane, choose "Parameter groups".
Click "Create parameter group" at the top right of the page.
In the "Parameter group family" dropdown, select "postgres15".
In the "Group name" field, enter a name for the new parameter group.
In the "Description" field, enter a description for the new parameter group.
Click "Create" at the bottom right of the page.

Modify the rds.force_ssl Parameter of your new Parameter Group:

In the list of parameter groups, click on the name of the new parameter group you just created.
In the "Filter parameters" box, type rds.force_ssl and press Enter.
You should see the rds.force_ssl parameter. Click "Edit parameters".
Change the value of rds.force_ssl from 1 to 0, then click "Save changes".

Associate Your RDS Instance with the New Parameter Group:

In the navigation pane, choose "Databases".
Click on the name of your RDS instance.
Click "Modify" at the top right of the page.
In the "Database options" section, find the "DB parameter group" setting and select the new parameter group you created from the dropdown menu.
Scroll down and click "Continue".
Review the summary of modifications and click "Modify DB Instance".

Reboote Your RDS Instance:

In the navigation pane, choose "Databases".
Click on the name of your RDS instance.
Click "Actions" at the top right of the page, then "Reboot".
Confirm that you want to reboot the instance.

By following these steps, you should be able to successfully modify the rds.force_ssl parameter in your Amazon RDS instance. And hopefully the connection issue would be resolved.

Add Github Eslint Checker Action

Tony Zheng — Wed, 18 Jan 2023 15:45:19 +0000

Add .github/workflows/eslint.yml file

Add this content

name: Lint
on:
  push:
    branches:
      - '*'
  pull_request:
    branches:
      - master
  workflow_dispatch:
jobs:
  ESlinter_JS:
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repository
        uses: actions/checkout@master
      - uses: actions/setup-node@v3
        with:
          node-version: '16.14.1'
      - name: Install Dependencies
        run: npm install

      - name: Run ESLint
        run: npm run eslint

Add Eslint, Prettier, Husky, Lint-staged to Vue Project

Tony Zheng — Tue, 17 Jan 2023 15:00:39 +0000

1. Install packages

npm install husky lint-staged eslint prettier --save-dev

2. eslint configuration

npm init @eslint/config

3. lint-staged Configuration
Add this to package.json

{
  ...
  "lint-staged": {
    "src/**/*.{js,vue,html,css}": "prettier --write",
    "src/**/*.{js,vue}": "eslint --fix"
  }
}

4. husky configuration

npx husky-init && npm install

Update .husky/pre-commit file

#!/usr/bin/env sh
. "$(dirname -- "$0")/_/husky.sh"

npx lint-staged