| const { Client } = require('pg'); | |
| const losslessJson = require('lossless-json'); | |
| const SLOT_NAME = process.env.SLOT_NAME; | |
| const SCHEMA_NAME = 'public'; | |
| const SHARDS_MAPPING = {}; | |
| async function processInsert(targetClient, change, tableName) { |
| Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=100000 width=16) (actual time=343.932..343.952 rows=267 loops=1) | |
| Output: remote_scan.id | |
| Task Count: 192 | |
| Tuple data received from nodes: 4272 bytes | |
| Tasks Shown: One of 192 | |
| -> Task | |
| " Query: SELECT g.id FROM ((public.game_103983 g JOIN public.game_map_238328 gm ON ((gm.id OPERATOR(pg_catalog.=) g.game_map_id))) JOIN public.game_player_173679 gp ON ((gp.game_id OPERATOR(pg_catalog.=) g.id))) WHERE ((gp.s64_id OPERATOR(pg_catalog.=) '76561197969209908'::bigint) AND (gp.game_finished_at OPERATOR(pg_catalog.>=) '2019-06-18 11:11:22'::timestamp without time zone) AND (gp.game_finished_at OPERATOR(pg_catalog.<=) '2023-05-01 17:08:44'::timestamp without time zone) AND (g.status OPERATOR(pg_catalog.=) 'ready'::public.game_status_enum))" | |
| Tuple data received from node: 48 bytes | |
| Node: host=192.168.109.4 port=11338 dbname=leetify_sharded | |
| -> Nested Loop (cost=1.11..56.92 rows=10 width=16) (actual time=0.078..0.328 rows=3 loops=1) |
| 12:36:43 2691498 INFO Running pgcopydb version 0.11-1.pgdg22.04+1 from "/usr/bin/pgcopydb" | |
| 12:36:43 2691498 INFO cli_common.c:891 Using default origin node name "pgcopydb" | |
| 12:36:43 2691498 INFO cli_common.c:897 Using default logical replication output plugin "test_decoding" | |
| 12:36:43 2691498 INFO cli_common.c:970 [SOURCE] Copying database from "postgres://@localhost:11338/_source_db?" | |
| 12:36:43 2691498 INFO cli_common.c:971 [TARGET] Copying database into "postgres://@localhost:11338/_target_db?" | |
| 12:36:43 2691498 DEBUG cli_common.c:975 Using pg_dump for Postgres "15.2" at "/usr/bin/pg_dump" | |
| 12:36:43 2691498 DEBUG cli_common.c:979 Using pg_restore for Postgres "15.2" at "/usr/bin/pg_restore" | |
| 12:36:43 2691498 DEBUG copydb.c:524 Change Data Capture data is managed at "/var/lib/postgresql/.local/share/pgcopydb" | |
| 12:36:43 2691498 NOTICE copydb.c:87 Using work dir "/tmp/pgcopydb" | |
| 12:36:43 2691498 NOTICE copydb.c:359 Work directory "/tmp/pgcopydb" already exists |
Credits go to https://docs.docker.com/registry/recipes/nginx/ and http://mindtrove.info/control-read-write-access-docker-private-registry/
Follow the steps on https://docs.docker.com/registry/recipes/nginx/ with docker-compose.yml and nginx.conf below.
Run the following for admin UI:
docker run \
When hosting our web applications, we often have one public IP
address (i.e., an IP address visible to the outside world)
using which we want to host multiple web apps. For example, one
may wants to host three different web apps respectively for
example1.com, example2.com, and example1.com/images on
the same machine using a single IP address.
How can we do that? Well, the good news is Internet browsers
Our Virtual Machines are provisioned using Vagrant from a Linux base box to run using VirutalBox. If the Hard Disk space runs out and you cannot remove files to free-up space, you can resize the Hard Disk using some VirtualBox and Linux commands.
The following steps assume you've got a set-up like mine, where:
