-
Notifications
You must be signed in to change notification settings - Fork 0
Install PostgREST
Peter edited this page Aug 22, 2020
·
15 revisions
As decisões de proejeto na infraestrutura AddressForAll incluem:
- uso do PostgreSQL v12 (+PostGIS etc.) em ambiente UBUNTU 20 LTS, direto (sem dockagem).
- uso do PostgREST v7.0, dockado e conectado ao PostgreSQL principal (não-dockado).
No Guia essa opção é descrita como "run the PostgREST container (...) with an existing external database" ou "... connect it to an existing native database on the host".
Testes no servidor, provavelmente com instalação parcial. Seguindo o [passo-a-passo do Guia/Install/Docker]:(http://postgrest.org/en/v7.0.0/install.html#docker).
Passo1. sudo docker pull postgrest/postgrest resulta em
Using default tag: latest
latest: Pulling from postgrest/postgrest
c499e6d256d6: Pull complete
a435bd9a4588: Pull complete
dbcbbf731db2: Pull complete
42f850f7ea21: Pull complete
Digest: sha256:2a10713acc388f9a64320443e949eb87a0424ab280e68c4ed4a6d0653c001586
Status: Downloaded newer image for postgrest/postgrest:latest
docker.io/postgrest/postgrest:latest
Passo2. Conferindo configurações default. sudo docker inspect -f "{{.Config.Env}}" postgrest/postgrest resulta em
[PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
PGRST_DB_URI= PGRST_DB_SCHEMA=public PGRST_DB_ANON_ROLE= PGRST_DB_POOL=100
PGRST_DB_EXTRA_SEARCH_PATH=public PGRST_SERVER_HOST=*4 PGRST_SERVER_PORT=3000
PGRST_OPENAPI_SERVER_PROXY_URI= PGRST_JWT_SECRET= PGRST_SECRET_IS_BASE64=false
PGRST_JWT_AUD= PGRST_MAX_ROWS= PGRST_PRE_REQUEST= PGRST_ROLE_CLAIM_KEY=.role
PGRST_ROOT_SPEC= PGRST_RAW_MEDIA_TYPES=
]
(wiki temporária!)