{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":440229033,"defaultBranch":"main","name":"pgcopydb","ownerLogin":"dimitri","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-12-20T16:04:47.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/102900?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1716458811.0","currentOid":""},"activityList":{"items":[{"before":"06ae6560dbf44f765833e3073a8343c99fb514ff","after":"120601c7796bbb519d2079c9819ea85dfb756a21","ref":"refs/heads/main","pushedAt":"2024-05-30T14:14:18.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Refactor pgcopydb for standby server support (#655)\n\nTo be able to use a standby server, pgcopydb needs to switch from ISOLATION_SERIALIZABLE to ISOLATION_READ_REPEATED, and we also need to avoid calling into ANALYZE, which is not available there.","shortMessageHtmlLink":"Refactor pgcopydb for standby server support (#655)"}},{"before":"daea3f5db80dfa6ff59faef5ee297d8ee1321805","after":"9d46a324a8f8e6bbc08dd91e74373508f6c07d6b","ref":"refs/heads/feature/use-sqlite-for-cdc","pushedAt":"2024-05-30T10:54:35.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"{WIP} Use SQLite as the file format for CDC streaming.","shortMessageHtmlLink":"{WIP} Use SQLite as the file format for CDC streaming."}},{"before":"b0ce438cd0b30b2d4db0db9be9d9b7bd9515fa75","after":"06ae6560dbf44f765833e3073a8343c99fb514ff","ref":"refs/heads/main","pushedAt":"2024-05-30T10:29:26.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Implement support for filtering materialized view and data (refresh) (#737)\n\nCurrently, there is no way to filter materialized view or materialized view data(refresh).\r\n\r\npg_dump supports it with following option,\r\n\r\n* pg_dump --exclude-table filters materialized view altogether.\r\n* pg_dump --exclude-table-data filters REFRESH MATERIALIZED VIEW.\r\n\r\nSolution: Incorporate materialized view filtering into existing filtering framework. [exclude-table], [include-table] can be used filter the materialized view and [exclude-table-data] can be used to filter materialized view data(refresh).\r\n\r\nSigned-off-by: Arunprasad Rajkumar ","shortMessageHtmlLink":"Implement support for filtering materialized view and data (refresh) (#…"}},{"before":"06f00e3a3944c5bc74def3331cf864a9b5b89053","after":"daea3f5db80dfa6ff59faef5ee297d8ee1321805","ref":"refs/heads/feature/use-sqlite-for-cdc","pushedAt":"2024-05-30T09:50:02.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"{WIP} Use SQLite as the file format for CDC streaming.","shortMessageHtmlLink":"{WIP} Use SQLite as the file format for CDC streaming."}},{"before":"aece0790d9222c6f0e8e75b378c9f0d2fff72e83","after":"b0ce438cd0b30b2d4db0db9be9d9b7bd9515fa75","ref":"refs/heads/main","pushedAt":"2024-05-29T17:37:17.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Introduce new options for estimating table sizes (#793)\n\nThis commit introduces a new option --estimate-table-sizes. When set,\r\npgcopydb will use the relpages value in system catalog to estimate the\r\nsize of each table. This is done by multiplying the number of pages by\r\nthe page size. PostgreSQL uses a default of 8KB for page sizes, but can\r\nbe changed in build time.\r\n\r\nOptionally, the user can set the environment variable\r\nPGCOPYDB_ESTIMATE_TABLE_SIZES to a boolean value to enable the option.\r\n\r\nIf this option is used, we run vacuumdb --analyze-only on the source to\r\nupdate the relpages values before calculating the estimates.\r\n\r\nIn passing, I fixed several things including the following:\r\n- Fix comment references to pg_autoctl\r\n- Remove some unused functions\r\n- Remove reference to non-existing vacuumdb command\r\n- Remove --cache and --drop-cache references that are no longer used\r\n- Fix typos in vacuum logs and comments\r\n- Remove references to pgcopydb_table_size table","shortMessageHtmlLink":"Introduce new options for estimating table sizes (#793)"}},{"before":"19795fca058a34292a9f15a8cd5e360d41bf46c0","after":"aece0790d9222c6f0e8e75b378c9f0d2fff72e83","ref":"refs/heads/main","pushedAt":"2024-05-29T15:54:09.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Improve formatting for pretty printed integers (#792)\n\nDuring development I created a table with 1000 tuples and in the logs I\r\nsaw that the format is not so easy to read and understand.\r\n\r\n... with an estimated total of 1 0 tuples ...\r\n\r\nFor numbers with 4, 5, or 6 decimal digits, we should pad the number\r\nwith zeros.","shortMessageHtmlLink":"Improve formatting for pretty printed integers (#792)"}},{"before":"b290f30eb0cf34e5fd26a9177608fda3b99419da","after":"06f00e3a3944c5bc74def3331cf864a9b5b89053","ref":"refs/heads/feature/use-sqlite-for-cdc","pushedAt":"2024-05-28T11:22:28.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"{WIP} Use SQLite as the file format for CDC streaming.","shortMessageHtmlLink":"{WIP} Use SQLite as the file format for CDC streaming."}},{"before":"a988fec7d1bd67daef91904051b5b32afe902da2","after":"19795fca058a34292a9f15a8cd5e360d41bf46c0","ref":"refs/heads/main","pushedAt":"2024-05-27T11:22:37.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Improve foreign key dependency tracking SQL query for extension tables (#790)","shortMessageHtmlLink":"Improve foreign key dependency tracking SQL query for extension tables ("}},{"before":"2ca40d5ddb39264f5308b01ce17fcf3bc32ca878","after":"a988fec7d1bd67daef91904051b5b32afe902da2","ref":"refs/heads/main","pushedAt":"2024-05-25T08:52:08.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Allow exclude-index filtering with other filters (#789)\n\n[exclude-index] works only when there is no other filter presents.\n\nSolution: Fix index listing query to consider exclude-index filters on\nall possible scenarios.\n\nSigned-off-by: Arunprasad Rajkumar ","shortMessageHtmlLink":"Allow exclude-index filtering with other filters (#789)"}},{"before":"a8d2749959da3900e32f9a618600bf3575cc49f3","after":"2ca40d5ddb39264f5308b01ce17fcf3bc32ca878","ref":"refs/heads/main","pushedAt":"2024-05-23T12:27:19.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Skip disable by ctid (#785)","shortMessageHtmlLink":"Skip disable by ctid (#785)"}},{"before":"41090fef70201f7ac27b968b7023ad676ab9d02f","after":null,"ref":"refs/heads/origin/fix/post-release","pushedAt":"2024-05-23T10:06:51.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"}},{"before":"1529aff59f5c0f3c1b7ecf800d622c578d061ef6","after":"a8d2749959da3900e32f9a618600bf3575cc49f3","ref":"refs/heads/main","pushedAt":"2024-05-23T10:06:48.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Post release adjustments (#788)\n\nSigned-off-by: Dimitri Fontaine ","shortMessageHtmlLink":"Post release adjustments (#788)"}},{"before":null,"after":"41090fef70201f7ac27b968b7023ad676ab9d02f","ref":"refs/heads/origin/fix/post-release","pushedAt":"2024-05-23T10:02:16.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Post release adjustments\n\nSigned-off-by: Dimitri Fontaine ","shortMessageHtmlLink":"Post release adjustments"}},{"before":"4a7b70a0bd90e0145fec2f2c806a09eed04b5c4e","after":null,"ref":"refs/heads/release/v0.16","pushedAt":"2024-05-22T15:49:59.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"}},{"before":"c84f1b9307f4d65acd703ebed82c028d698bd478","after":"1529aff59f5c0f3c1b7ecf800d622c578d061ef6","ref":"refs/heads/main","pushedAt":"2024-05-22T15:49:56.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Release v0.16 (#787)","shortMessageHtmlLink":"Release v0.16 (#787)"}},{"before":"040a16ecdfe69945536a0db5bcdc9faba28442da","after":"4a7b70a0bd90e0145fec2f2c806a09eed04b5c4e","ref":"refs/heads/release/v0.16","pushedAt":"2024-05-22T15:46:11.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Release v0.16","shortMessageHtmlLink":"Release v0.16"}},{"before":null,"after":"040a16ecdfe69945536a0db5bcdc9faba28442da","ref":"refs/heads/release/v0.16","pushedAt":"2024-05-22T15:39:15.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Release v0.16","shortMessageHtmlLink":"Release v0.16"}},{"before":"de96808b637a162eaa80d7d1ccf3cbed48398bbe","after":null,"ref":"refs/heads/fix/parse-restore-list-database","pushedAt":"2024-05-21T15:26:53.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"}},{"before":"992dac5759f370005104ed05a6a81f1923032b3b","after":"c84f1b9307f4d65acd703ebed82c028d698bd478","ref":"refs/heads/main","pushedAt":"2024-05-21T15:26:50.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Parse pg_restore Archive TOC entry for DATABASE. (#786)\n\nEven though pgcopydb does not support creating the target database (which\r\nwould require another connection string to the target only for that\r\noperation), we might have to process pg_dump output that contains the\r\nDATABASE entry.","shortMessageHtmlLink":"Parse pg_restore Archive TOC entry for DATABASE. (#786)"}},{"before":null,"after":"de96808b637a162eaa80d7d1ccf3cbed48398bbe","ref":"refs/heads/fix/parse-restore-list-database","pushedAt":"2024-05-21T13:39:04.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Parse pg_restore Archive TOC entry for DATABASE.\n\nEven though pgcopydb does not support creating the target database (which\nwould require another connection string to the target only for that\noperation), we might have to process pg_dump output that contains the\nDATABASE entry.","shortMessageHtmlLink":"Parse pg_restore Archive TOC entry for DATABASE."}},{"before":"c74047ae7fb2e3fac5eaae0157175bb91dc65d73","after":"992dac5759f370005104ed05a6a81f1923032b3b","ref":"refs/heads/main","pushedAt":"2024-05-21T09:45:24.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"BUG: summary_start_timing: db is NULL (#784)\n\nSolution: Prepare catalog before accessing it!\r\n\r\nFixes https://github.com/dimitri/pgcopydb/issues/729\r\n\r\nSigned-off-by: Arunprasad Rajkumar ","shortMessageHtmlLink":"BUG: summary_start_timing: db is NULL (#784)"}},{"before":"10be10693f45c7b3a3a86e362fa59e3ddde15e7b","after":"c74047ae7fb2e3fac5eaae0157175bb91dc65d73","ref":"refs/heads/main","pushedAt":"2024-05-16T15:45:11.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Fix resume on interruped index creation (#783)\n\nIf we interrupt the process while creating an index, the summary catalog\r\nwill show the index command as `CREATE INDEX ..`. When resuming,\r\npgcopydb alters the command to `CREATE INDEX IF NOT EXISTS ..` to avoid errors if index already created on target. However, summary_lookup_index() will change it back to `CREATE INDEX ..` because it replaces the command from the summary catalog table.\r\n\r\nSolution: Change the index definition just before executing it against the target.\r\n\r\nSigned-off-by: Arunprasad Rajkumar ","shortMessageHtmlLink":"Fix resume on interruped index creation (#783)"}},{"before":"cd0895a80a038e6ad8d262ff02a89f84c6686a5e","after":null,"ref":"refs/heads/fix/restore-list-oid-lookup","pushedAt":"2024-05-16T15:03:34.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"}},{"before":"22b3fac0d2bd74da7240c8afec9d71a48003fbe1","after":"10be10693f45c7b3a3a86e362fa59e3ddde15e7b","ref":"refs/heads/main","pushedAt":"2024-05-16T10:48:04.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Fix index/constraint lookup when preparing pg_restore list files. (#782)\n\nThe Postgres catalog OIDs are unique per-catalog, not globally unique, and\nwe could see the same OID being assigned to both an index and also a\nconstraint.\n\nTo support the situation, we need to implement per-catalog lookup. In our\ncase this is limited to indexes and constraints.","shortMessageHtmlLink":"Fix index/constraint lookup when preparing pg_restore list files. (#782)"}},{"before":"0502c3f70b090cbcb58c4f71e047dc0f171026e2","after":"cd0895a80a038e6ad8d262ff02a89f84c6686a5e","ref":"refs/heads/fix/restore-list-oid-lookup","pushedAt":"2024-05-16T10:33:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Update src/bin/pgcopydb/dump_restore.c\n\nCo-authored-by: Hanefi Onaldi ","shortMessageHtmlLink":"Update src/bin/pgcopydb/dump_restore.c"}},{"before":null,"after":"0502c3f70b090cbcb58c4f71e047dc0f171026e2","ref":"refs/heads/fix/restore-list-oid-lookup","pushedAt":"2024-05-16T10:06:53.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Fix index/constraint lookup when preparing pg_restore list files.\n\nThe Postgres catalog OIDs are unique per-catalog, not globally unique, and\nwe could see the same OID being assigned to both an index and also a\nconstraint.\n\nTo support the situation, we need to implement per-catalog lookup. In our\ncase this is limited to indexes and constraints.","shortMessageHtmlLink":"Fix index/constraint lookup when preparing pg_restore list files."}},{"before":"6a4b3a4bc422412a5b6244ecbf86824d04ad037f","after":"22b3fac0d2bd74da7240c8afec9d71a48003fbe1","ref":"refs/heads/main","pushedAt":"2024-05-15T18:31:57.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Allow identity based sequences to be found and reset (#778)","shortMessageHtmlLink":"Allow identity based sequences to be found and reset (#778)"}},{"before":"6c308be88208997621aaa9f7fb67bbd5a5aa6339","after":"6a4b3a4bc422412a5b6244ecbf86824d04ad037f","ref":"refs/heads/main","pushedAt":"2024-05-15T15:37:47.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Incorrect type used for `partnum` while querying summary table (#781)\n\nThis leads to considering `0` as `null` while querying and table with\r\npartnum as 0 is never matched.\r\n\r\nAlso fix typo which refers partnum as partnumber.\r\n\r\nSigned-off-by: Arunprasad Rajkumar ","shortMessageHtmlLink":"Incorrect type used for partnum while querying summary table (#781)"}},{"before":"6e0f1cae802e0e349b2e488a362527d2722ccef0","after":"6c308be88208997621aaa9f7fb67bbd5a5aa6339","ref":"refs/heads/main","pushedAt":"2024-05-15T13:05:29.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"},"commit":{"message":"Fix short args common cli options (#780)\n\nAdded missing -g for skip-db-properties.\r\nRemoved redundant -d for debug.\r\n\r\nRelated: #779","shortMessageHtmlLink":"Fix short args common cli options (#780)"}},{"before":"0d806eebcced9d34a56605cb2b8b32c0e3a8544f","after":null,"ref":"refs/heads/feature/skip-db-properties","pushedAt":"2024-05-15T11:46:58.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dimitri","name":"Dimitri Fontaine","path":"/dimitri","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/102900?s=80&v=4"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEWBiO7QA","startCursor":null,"endCursor":null}},"title":"Activity · dimitri/pgcopydb"}