Replication woes
还没有人认领这个 Issue。
评估
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 新手友好度
- 25/100
- Issue 类型
- 文档
- 描述清晰度
- 需要澄清
- 活跃度
- 停滞
- 技术栈
- linux, macos, postgresql
调研方向
No files or tests are named. Start by reviewing how PostgresApp handles data directories and the PostgreSQL log shipping replication approach described in the issue, then determine whether migration in both directions is supported. Done means documenting a verified migration and replication path, or clearly stating the limitations and unsupported steps.
由索引模型根据 Issue 内容生成。
描述
Hi there ... having a really hard time replicating from a Linux postgres setup to Postgress.app. I've tried a few different approaches but none have worked so far, so looking for advice or possibly documentation ... here's the methods I've tried:
- Copy over from current master using pg_basebackup to an appropriately located directory (~/Library/Application Support/Postgres/blah) -- PostgresApp does not pick up on this new directly.
- tried then making a new DB at that location, still doesn't pick up, wants to initialize a new DB, doing so will make the new DB but it will not pickup the current data that's there.
- Another attempt was to first initialize a new DB through app interface and then us pg_basebackup. This would not work because pb_basebackup wants an empty target (
pg_basebackup: error: directory "/Users/mguertin/Library/Application Support/Postgres/v15_production" exists but is not empty) - Tried a combination of the two, made a new DB in the PostressApp UI, used pg_basebackup to copy to a different dir and then tried to cherry pick the things that PostgressApp was looking for and combining those two. PostgressApp still wants to initialize, so I'm assuming I'm missing on moving something that it requires.
Is there any known way to make these two play nicely together for replication? I'm looking to migrate my current production (linux) over to PostrgresApp on macos, and after that migration still have PostgressApp replicate back to the linux instance. If it matters I'm using log shipping replication right now between multiple linux hosts. If it's possible to do what I'm looking to do it would be awesome to have a bit of documentation on how this could all work, even if it's just a basic overview!
Thanks in advance and love this app, makes life a lot easier. Hoping I can use this and not have to go back to homebrew on macos.
- 主要语言
- Makefile
- 星标
- 7.8k
- 派生
- 404
- 平均合并
- 6 小时 55 分钟
- 30 天内合并 PR
- 6
贡献指南
这个仓库没有索引到贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
PostgresApp/PostgresApp 的其他 Issue
-
难度 4/5 3-5 天 新手友好度 48/100
PostgresApp/PostgresApp#859 ·
-
难度 4/5 3-5 天 新手友好度 48/100
PostgresApp/PostgresApp#844 · 7 条评论 · 1 个 reaction ·
-
Postgres.app 3.0 未关闭
难度 5/5 一周以上 新手友好度 25/100
PostgresApp/PostgresApp#842 · 1 条评论 · 7 个 reaction ·
-
难度 5/5 一周以上 新手友好度 25/100
PostgresApp/PostgresApp#834 ·
-
难度 5/5 一周以上 新手友好度 35/100
PostgresApp/PostgresApp#833 ·
查看 PostgresApp/PostgresApp 的全部 Issue
相似的 Issue
-
难度 1/5 1 小时以内 新手友好度 75/100
-
bug
难度 2/5 1-3 小时 新手友好度 88/100
AstrBotDevs/AstrBot#10205 ·
-
难度 2/5 1-3 小时 新手友好度 72/100
-
难度 2/5 1-3 小时 新手友好度 70/100
OHDSI/Data2Evidence#3394 ·
-
难度 2/5 1-3 小时 新手友好度 84/100