Hacktoberfest 2026:メンテナが10月に向けて印を付けた、オープンで初心者向けの issue。 Hacktoberfest の issue を見る

Replication woes

オープン
#713 コメント 2 件 リアクション 0 件 担当者 0 名 GitHub で見る

まだ誰も着手していません。

評価

難易度
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:

  1. 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.
  2. 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.
  3. 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)
  4. 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分
マージ済み PR(30日)
6

コントリビューションガイド

このリポジトリのコントリビューションガイドは索引されていません

はじめの一歩

  1. issue を最後まで読み、次にプロジェクトのコントリビューションガイドを読みます。
  2. 着手することを issue にコメントします — 二人が同じ作業をするのを防げます。
  3. リポジトリをフォークし、ブランチを切って変更します。
  4. issue 番号を参照したプルリクエストを送ります。

PostgresApp/PostgresApp のほかの issue

PostgresApp/PostgresApp の issue をすべて見る

似ている issue

Databases の issue をもっと見る

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。