## attempt 1 22:45:30 49ce01ffccee24906ccbd05c33f6526e8c324a645614abdf5f01b162e6bf6802 0bb8c8dfa470dc5717ef6e084e7159c2831d1c0e6d29aead974df02711859cd8 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup ## attempt 2 22:46:49 7584c8f3498d793fe22e5be5557acf83202cee93a40593ca0f3adc2aa5149c0a 13398cc63ba66d596fb3cc656dd3fd0f1d6cdb76013c3aad2d3dee055ccf96f7 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup ## attempt 3 22:47:52 81c9195ed902ad5d2759cb464782fdfd6a8c251873d0d64ecc523e8bdf3a7445 2db2327c9075042a63c137385825fbbbb915a2f7cf7e9392781ae28677786095 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup ## attempt 1 (named volume) 22:58:50 8e35c547454b026cc3feef290bd0fe3925877d57b10155f41936a09fc5cdef73 0ade6f2768c20034535dae68d88eafb2229d59a24726399fe309eea01e4fbfc6 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup --- server log tail: subdirectory, allowing usage of "pg_upgrade --link" without mount point boundary issues. See https://github.com/docker-library/postgres/issues/37 for a (long) discussion around this process, and suggestions for how to do so. ## attempt 2 (named volume) 23:00:10 8dacabc8e4ab2816cb0a00868b208b653ca072acf5ce2af06ef3b403a333eb71 ba9bc12b78252ecf60324794006bc83dd98215a133bfa32c908b6d566dc259c8 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup --- server log tail: subdirectory, allowing usage of "pg_upgrade --link" without mount point boundary issues. See https://github.com/docker-library/postgres/issues/37 for a (long) discussion around this process, and suggestions for how to do so. ## attempt 3 (named volume) 23:01:14 605bd81efb536a5908ef5bc6d786be8ac188be29a85f75470513708792e3ef1c a3d3976b769e0cee8aec617357806e1a84480a5dfc5436cd9d6642d9bffbaab3 pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for initialization pgbench: error: could not translate host name "postgrestest" to address: Name does not resolve pgbench: error: could not create connection for setup --- server log tail: subdirectory, allowing usage of "pg_upgrade --link" without mount point boundary issues. See https://github.com/docker-library/postgres/issues/37 for a (long) discussion around this process, and suggestions for how to do so. ## attempt 1 (volume at /var/lib/postgresql) 23:03:40 cb587e4f77885ed288c3280da6dd58c07955072596b708ffbc339cbbd576f0c5 d17b476338babd774e7869a4fc4ccab73f5b661b1168367a7ba346e78a772d3d /var/run/postgresql:5432 - accepting connections postgres (PostgreSQL) 18.6 dropping old tables... NOTICE: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping NOTICE: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping creating tables... generating data (client-side)... 100000 of 1000000 tuples (10%) of pgbench_accounts done (elapsed 0.01 s, remaining 0.09 s) 200000 of 1000000 tuples (20%) of pgbench_accounts done (elapsed 0.05 s, remaining 0.19 s) 300000 of 1000000 tuples (30%) of pgbench_accounts done (elapsed 0.07 s, remaining 0.17 s) 400000 of 1000000 tuples (40%) of pgbench_accounts done (elapsed 0.11 s, remaining 0.17 s) 500000 of 1000000 tuples (50%) of pgbench_accounts done (elapsed 0.16 s, remaining 0.16 s) 600000 of 1000000 tuples (60%) of pgbench_accounts done (elapsed 0.18 s, remaining 0.12 s) 700000 of 1000000 tuples (70%) of pgbench_accounts done (elapsed 0.22 s, remaining 0.09 s) 800000 of 1000000 tuples (80%) of pgbench_accounts done (elapsed 0.25 s, remaining 0.06 s) 900000 of 1000000 tuples (90%) of pgbench_accounts done (elapsed 0.30 s, remaining 0.03 s) 1000000 of 1000000 tuples (100%) of pgbench_accounts done (elapsed 0.33 s, remaining 0.00 s) vacuuming... creating primary keys... done in 0.52 s (drop tables 0.00 s, create tables 0.00 s, client-side generate 0.36 s, vacuum 0.04 s, primary keys 0.12 s). pgbench (18.6) starting vacuum...end. transaction type: scaling factor: 10 query mode: simple number of clients: 10 number of threads: 1 maximum number of tries: 1 number of transactions per client: 10 number of transactions actually processed: 100/100 number of failed transactions: 0 (0.000%) latency average = 1.181 ms initial connection time = 34.816 ms tps = 8469.551961 (without initial connection time) ## attempt 2 (volume at /var/lib/postgresql) 23:03:58 c9f4c9b7b2c2d91e85a1f4334379c9435bdc601c7670e949688c2fe109ee2090 2db8dfc5756182c24057b607e77e26d8cedfc2fc99d1ff1f811c0b013138d891 /var/run/postgresql:5432 - accepting connections postgres (PostgreSQL) 18.6 dropping old tables... NOTICE: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping NOTICE: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping creating tables... generating data (client-side)... 100000 of 1000000 tuples (10%) of pgbench_accounts done (elapsed 0.01 s, remaining 0.09 s) 200000 of 1000000 tuples (20%) of pgbench_accounts done (elapsed 0.05 s, remaining 0.19 s) 300000 of 1000000 tuples (30%) of pgbench_accounts done (elapsed 0.08 s, remaining 0.18 s) 400000 of 1000000 tuples (40%) of pgbench_accounts done (elapsed 0.11 s, remaining 0.16 s) 500000 of 1000000 tuples (50%) of pgbench_accounts done (elapsed 0.14 s, remaining 0.14 s) 600000 of 1000000 tuples (60%) of pgbench_accounts done (elapsed 0.17 s, remaining 0.12 s) 700000 of 1000000 tuples (70%) of pgbench_accounts done (elapsed 0.21 s, remaining 0.09 s) 800000 of 1000000 tuples (80%) of pgbench_accounts done (elapsed 0.24 s, remaining 0.06 s) 900000 of 1000000 tuples (90%) of pgbench_accounts done (elapsed 0.28 s, remaining 0.03 s) 1000000 of 1000000 tuples (100%) of pgbench_accounts done (elapsed 0.32 s, remaining 0.00 s) vacuuming... creating primary keys... done in 0.50 s (drop tables 0.00 s, create tables 0.00 s, client-side generate 0.34 s, vacuum 0.03 s, primary keys 0.12 s). pgbench (18.6) starting vacuum...end. transaction type: scaling factor: 10 query mode: simple number of clients: 10 number of threads: 1 maximum number of tries: 1 number of transactions per client: 10 number of transactions actually processed: 100/100 number of failed transactions: 0 (0.000%) latency average = 1.158 ms initial connection time = 34.253 ms tps = 8634.832916 (without initial connection time) ## attempt 3 (volume at /var/lib/postgresql) 23:04:00 64f7dcb4ab2b405750125bdb6c91d5641ffa8789abdf1b0a68a90efa313c0911 d96e37b5d90639a09294dfeddafa9b204ebe63ce9969ed70a8c6fe5ffd4f15be /var/run/postgresql:5432 - accepting connections postgres (PostgreSQL) 18.6 dropping old tables... NOTICE: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping NOTICE: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping creating tables... generating data (client-side)... 100000 of 1000000 tuples (10%) of pgbench_accounts done (elapsed 0.01 s, remaining 0.09 s) 200000 of 1000000 tuples (20%) of pgbench_accounts done (elapsed 0.05 s, remaining 0.18 s) 300000 of 1000000 tuples (30%) of pgbench_accounts done (elapsed 0.07 s, remaining 0.17 s) 400000 of 1000000 tuples (40%) of pgbench_accounts done (elapsed 0.11 s, remaining 0.16 s) 500000 of 1000000 tuples (50%) of pgbench_accounts done (elapsed 0.15 s, remaining 0.15 s) 600000 of 1000000 tuples (60%) of pgbench_accounts done (elapsed 0.18 s, remaining 0.12 s) 700000 of 1000000 tuples (70%) of pgbench_accounts done (elapsed 0.22 s, remaining 0.09 s) 800000 of 1000000 tuples (80%) of pgbench_accounts done (elapsed 0.24 s, remaining 0.06 s) 900000 of 1000000 tuples (90%) of pgbench_accounts done (elapsed 0.28 s, remaining 0.03 s) 1000000 of 1000000 tuples (100%) of pgbench_accounts done (elapsed 0.32 s, remaining 0.00 s) vacuuming... creating primary keys... done in 0.48 s (drop tables 0.00 s, create tables 0.00 s, client-side generate 0.34 s, vacuum 0.03 s, primary keys 0.11 s). pgbench (18.6) starting vacuum...end. transaction type: scaling factor: 10 query mode: simple number of clients: 10 number of threads: 1 maximum number of tries: 1 number of transactions per client: 10 number of transactions actually processed: 100/100 number of failed transactions: 0 (0.000%) latency average = 1.203 ms initial connection time = 34.134 ms tps = 8313.242996 (without initial connection time)