Add locale to the service container #24923

yamap55 · 2021-03-12T15:03:51Z

yamap55
Mar 12, 2021

I used PostgreSQL service container.
I want to set env to “LC_ALL=ja_JP.UTF-8”.
but, the ja_JP.UTF-8 locale does not exist in the PostgreSQL service container.
It is described like this in the docker file.

localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8

Please tell me how to settings.

github actions yaml settings

jobs:
  pytest:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: postgres:11.5
        env:
          POSTGRES_PASSWORD: postgres
          POSTGRES_USER: postgres
          POSTGRES_DB: test
          TZ: Asia/Tokyo
          LANG: ja_JP.UTF-8
          LANGUAGE: ja_JP:ja
          LC_ALL: ja_JP.UTF-8

Answered by airtower-luna

Mar 12, 2021

I’ve looked at the “Locale Customization” section of the Docker Hub page for the postgres image. The instructions there suggest to build your own container image with the locale you want.

To do that you will need a Dockerfile like this:

FROM postgres:11.5
RUN localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8

To use such an image as a service, you’d need to build it and push it to a public registry (for example GHCR) and refer to it with the image: keyword of the service.

Alternatively, you could commit the Dockerfile to your repository and build the image during your Actions job and then start the service with docker run.

View full answer

airtower-luna · 2021-03-12T16:54:51Z

airtower-luna
Mar 12, 2021

I’ve looked at the “Locale Customization” section of the Docker Hub page for the postgres image. The instructions there suggest to build your own container image with the locale you want.

To do that you will need a Dockerfile like this:

FROM postgres:11.5
RUN localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8

To use such an image as a service, you’d need to build it and push it to a public registry (for example GHCR) and refer to it with the image: keyword of the service.

Alternatively, you could commit the Dockerfile to your repository and build the image during your Actions job and then start the service with docker run.

0 replies

yamap55 · 2021-03-14T13:14:20Z

yamap55
Mar 14, 2021
Author

thanks!

I understood that this could not be achieved with a service container.

I was able to run PostgreSQL with a github action.
Make a note of the Dockerfile used and the yaml of GitHub Actions.

Dockerfile

FROM postgres:11.5
RUN localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8

GitHub Actions setting file

name: postgresql on: [push]

jobs: postgresql: runs-on: ubuntu-latest steps: - uses: actions/checkout@v2 - name: PostgreSQL container build & run run: | docker build -t postgresql_i .github/workflows docker run -d --name postgresql_t -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e LC_ALL=ja_JP.UTF-8 postgresql_i - name: wait for db run: until docker exec postgresql_t pg_isready -U postgres; do sleep 1; done - name: show locale run: docker exec postgresql_t psql -U postgres -c "SHOW LC_COLLATE;"

output

Run docker exec postgresql_t psql -U postgres -c "SHOW LC_COLLATE;"
 lc_collate  
-------------
 ja_JP.UTF-8
(1 行)

sample repository

GitHub - yamap55/github_actions_postgresql

0 replies

airtower-luna · 2021-03-14T15:05:23Z

airtower-luna
Mar 14, 2021

Nice, thank you for sharing your solution! 🐱

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

GitHub Community

Add locale to the service container #24923

{{title}}

Replies: 3 comments

{{title}}

{{title}}

{{title}}

Select a reply

GitHub Community

Add locale to the service container #24923

yamap55 Mar 12, 2021

github actions yaml settings

Replies: 3 comments

airtower-luna Mar 12, 2021

yamap55 Mar 14, 2021 Author

Dockerfile

GitHub Actions setting file

output

sample repository

airtower-luna Mar 14, 2021

yamap55
Mar 12, 2021

airtower-luna
Mar 12, 2021

yamap55
Mar 14, 2021
Author

airtower-luna
Mar 14, 2021