Help connecting to Postgres Container

[alexlin51]

const cont = async (layerName: string, nw: string) => {
    return await new GenericContainer('postgres', 'latest')
        .withName(containerNames.con + layerName)
        .withNetworkMode(nw)
        .withExposedPorts(5432)
        .withEnv('POSTGRES_DB', 'dbName')
        .withEnv('POSTGRES_PASSWORD', 'postgres')
        .withEnv('POSTGRES_USER', 'postgres')
        .start();
};

Sorry, I am new to this library and docker in general but would really appreciate any help or guidance.

I'm hoping to set up a container with a Postgres DB where I can eventually connect to it and unit test some queries. Here are my questions:
By setting the POSTGRES_DB, POSTGRES_PASSWORD, and POSTGRES_USER env vars, does this mean that the created DB would have these connection values? My suspicions is that the answer is not, if so, how would I set those up?
What is the host URL to connect to this DB with?
Is the connection port 5432?

Here are the errors I am running into currently:

2021-07-23 15:55:00 - itests.infra.ts - info: �      NThe files belonging to this database system will be owned by user "postgres".
2021-07-23 15:55:00 - itests.infra.ts - info: �      ,This user must also own the server process.
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      CThe database cluster will be initialized with locale "en_US.utf8".
2021-07-23 15:55:00 - itests.infra.ts - info: �      BThe default database encoding has accordingly been set to "UTF8".
2021-07-23 15:55:00 - itests.infra.ts - info: �      @The default text search configuration will be set to "english".
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      "Data page checksums are disabled.
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      Ifixing permissions on existing directory /var/lib/postgresql/data ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �      �creating subdirectories ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �      9selecting dynamic shared memory implementation ... posix
2021-07-23 15:55:00 - itests.infra.ts - info: �      *selecting default max_connections ... 100
2021-07-23 15:55:00 - itests.infra.ts - info: �      +selecting default shared_buffers ... 128MB
2021-07-23 15:55:00 - itests.infra.ts - info: �      (selecting default time zone ... Etc/UTC
2021-07-23 15:55:00 - itests.infra.ts - info: �      $creating configuration files ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �       running bootstrap script ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �      0performing post-bootstrap initialization ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �      �syncing data to disk ... ok
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      6Success. You can now start the database server using:
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      8    pg_ctl -D /var/lib/postgresql/data -l logfile start
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      Ginitdb: warning: enabling "trust" authentication for local connections
2021-07-23 15:55:00 - itests.infra.ts - info: �      FYou can change this by editing pg_hba.conf or using the option -A, or
2021-07-23 15:55:00 - itests.infra.ts - info: �      <--auth-local and --auth-host, the next time you run initdb.
2021-07-23 15:55:00 - itests.infra.ts - info: �      �waiting for server to start....2021-07-23 22:54:58.540 UTC [119] LOG:  starting PostgreSQL 13.3 (Debian 13.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-07-23 15:55:00 - itests.infra.ts - info: �      e2021-07-23 22:54:58.543 UTC [119] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-07-23 15:55:00 - itests.infra.ts - info: �      a2021-07-23 22:54:58.553 UTC [120] LOG:  database system was shut down at 2021-07-23 22:54:58 UTC
2021-07-23 15:55:00 - itests.infra.ts - info: �      W2021-07-23 22:54:58.558 UTC [119] LOG:  database system is ready to accept connections
2021-07-23 15:55:00 - itests.infra.ts - info: �      � done
2021-07-23 15:55:00 - itests.infra.ts - info: �      �server started
2021-07-23 15:55:00 - itests.infra.ts - info: �      �CREATE DATABASE
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      L/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      G2021-07-23 22:54:58.918 UTC [119] LOG:  received fast shutdown request
2021-07-23 15:55:00 - itests.infra.ts - info: �      lwaiting for server to shut down....2021-07-23 22:54:58.921 UTC [119] LOG:  aborting any active transactions
2021-07-23 15:55:00 - itests.infra.ts - info: �      {2021-07-23 22:54:58.923 UTC [119] LOG:  background worker "logical replication launcher" (PID 126) exited with exit code 1
2021-07-23 15:55:00 - itests.infra.ts - info: �      62021-07-23 22:54:58.923 UTC [121] LOG:  shutting down
2021-07-23 15:55:00 - itests.infra.ts - info: �      E2021-07-23 22:54:58.943 UTC [119] LOG:  database system is shut down
2021-07-23 15:55:00 - itests.infra.ts - info: �      � done
2021-07-23 15:55:00 - itests.infra.ts - info: �      �server stopped
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      6PostgreSQL init process complete; ready for start up.
2021-07-23 15:55:00 - itests.infra.ts - info: �      �
2021-07-23 15:55:00 - itests.infra.ts - info: �      �2021-07-23 22:54:59.045 UTC [1] LOG:  starting PostgreSQL 13.3 (Debian 13.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-07-23 15:55:00 - itests.infra.ts - info: �      U2021-07-23 22:54:59.045 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-07-23 15:55:00 - itests.infra.ts - info: �      P2021-07-23 22:54:59.045 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2021-07-23 15:55:00 - itests.infra.ts - info: �      c2021-07-23 22:54:59.052 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-07-23 15:55:00 - itests.infra.ts - info: �      a2021-07-23 22:54:59.063 UTC [170] LOG:  database system was shut down at 2021-07-23 22:54:58 UTC
2021-07-23 15:55:00 - itests.infra.ts - info: �      U2021-07-23 22:54:59.070 UTC [1] LOG:  database system is ready to accept connections

[cristianrgreco]

@alexlin51 I've just published a PostgreSQL module to make this easier for everyone, it's available in 7.17.0.

README is here, which includes links to examples: https://github.com/testcontainers/testcontainers-node/tree/master/src/modules/postgresql.

Using it is as simple as:

import { PostgreSqlContainer } from "testcontainers";

const container = await new PostgreSqlContainer().start();

(See the examples for further customisation options, such as setting the database/username/password).

Hope that helps 🙂

[alexlin51]

Yes! thank you for taking the time to do this! I really do appreciate it too much :)