3 ms·

I can’t remember the exact command off top of my head but it’s something like: docker run -it -e POSTGRES_PASSWORD -p 5432:5432 postgres:12 And bam, you have

I can’t remember the exact command off top of my head but it’s something like: docker run -it -e POSTGRES_PASSWORD -p 5432:5432 postgres:12 And bam, you have a server

sixbrx 4y ago
Another cool thing is you can initialize the Postgres db when it starts the container with your own SQL (or sh) scripts to create your schemas, tables, views etc by just copying the scripts into /docker-entrypoint-initdb.d/. Like: FROM postgres:14.3 COPY pg/pg-config.sql /docker-entrypoint-initdb.d/000-pg-config.sql COPY pg/schemas.sql /docker-entrypoint-initdb.d/010-schemas.sql COPY pg/meddra-tables.sql /docker-entrypoint-initdb.d/020-meddra-tables.sql # ... RUN chmod a+r /docker-entrypoint-initdb.d/* ENV POSTGRES_USER=myapp ENV POSTGRES_PASSWORD=xxx ENV POSTGRES_DB=mydb
- physicsguy 4y ago
  I tend to do things like (after launching container): docker exec postgres psql -h localhost -p 5432 -U ${DBADMINUSER} -c "some SQL statement"
riku_iki 4y ago
There is config change in steps above (pgsql defaults suck), and having docker now, changing them becomes harder. Also, I usually change hba.conf file too, to disallow outside connections.
- jayd16 4y ago
  Keep in mind the suggestion was a managed product in production but if you really need to customize your local image, you can mount in arbitrary initialization scripts as well. If you need all this customization then did SQLite really fit the bill in the first place?
  - riku_iki 4y ago
    > if you really need to customize your local image I need to change config for prod pgsql instance, because default config performance wise is not necessary suitable for serious prod machines. > If you need all this customization then did SQLite really fit the bill in the first place? I am not familiar with SQLite, but somehow familiar with Java H2 DB, which has similar idea. You can embed it and all configs into self contained java jar file together with your app and no moves in host OS is needed.
- physicsguy 4y ago
  I only use this for local development personally, we use RDS in Prod

I can’t remember the exact command off top of my head but it’s something like: docker run -it -e POSTGRES_PASSWORD -p 5432:5432 postgres:12 And bam, you have a server

sixbrx 4y ago

Another cool thing is you can initialize the Postgres db when it starts the container with your own SQL (or sh) scripts to create your schemas, tables, views etc by just copying the scripts into /docker-entrypoint-initdb.d/. Like: FROM postgres:14.3 COPY pg/pg-config.sql /docker-entrypoint-initdb.d/000-pg-config.sql COPY pg/schemas.sql /docker-entrypoint-initdb.d/010-schemas.sql COPY pg/meddra-tables.sql /docker-entrypoint-initdb.d/020-meddra-tables.sql # ... RUN chmod a+r /docker-entrypoint-initdb.d/* ENV POSTGRES_USER=myapp ENV POSTGRES_PASSWORD=xxx ENV POSTGRES_DB=mydb

physicsguy 4y ago
I tend to do things like (after launching container): docker exec postgres psql -h localhost -p 5432 -U ${DBADMINUSER} -c "some SQL statement"

riku_iki 4y ago

There is config change in steps above (pgsql defaults suck), and having docker now, changing them becomes harder. Also, I usually change hba.conf file too, to disallow outside connections.

jayd16 4y ago
Keep in mind the suggestion was a managed product in production but if you really need to customize your local image, you can mount in arbitrary initialization scripts as well. If you need all this customization then did SQLite really fit the bill in the first place?
- riku_iki 4y ago
  > if you really need to customize your local image I need to change config for prod pgsql instance, because default config performance wise is not necessary suitable for serious prod machines. > If you need all this customization then did SQLite really fit the bill in the first place? I am not familiar with SQLite, but somehow familiar with Java H2 DB, which has similar idea. You can embed it and all configs into self contained java jar file together with your app and no moves in host OS is needed.
physicsguy 4y ago
I only use this for local development personally, we use RDS in Prod