Replication woes
Nadie ha tomado este issue todavía.
Evaluación
- Dificultad
- 4/5
- Tiempo estimado
- 3-5 días
- Aptitud para principiantes
- 25/100
- Tipo de issue
- Documentación
- Claridad
- Necesita aclaración
- Estado de actividad
- Estancado
- Stack tecnológico
- linux, macos, postgresql
Línea de trabajo
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.
Escrito por el modelo de indexación a partir del texto del issue.
Descripción
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.
- Lenguaje dominante
- Makefile
- Estrellas
- 7.8k
- Forks
- 404
- Merge medio
- 6 h 55 min
- PR fusionados (30 d)
- 6
Guía de contribución
No hay ninguna guía de contribución indexada para este repositorio
Primeros pasos
- Lee el issue completo y luego la guía de contribución del proyecto.
- Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
- Haz un fork del repositorio y trabaja en una rama.
- Abre un pull request que haga referencia al número del issue.
Más de PostgresApp/PostgresApp
-
Dificultad 4/5 3-5 días Aptitud para principiantes 48/100
PostgresApp/PostgresApp#859 ·
-
Dificultad 4/5 3-5 días Aptitud para principiantes 48/100
PostgresApp/PostgresApp#844 · 7 comentarios · 1 reacción ·
-
Postgres.app 3.0 Abierto
Dificultad 5/5 Más de una semana Aptitud para principiantes 25/100
PostgresApp/PostgresApp#842 · 1 comentario · 7 reacciones ·
-
Dificultad 5/5 Más de una semana Aptitud para principiantes 25/100
PostgresApp/PostgresApp#834 ·
-
Apple Script Support Abierto
Dificultad 5/5 Más de una semana Aptitud para principiantes 35/100
PostgresApp/PostgresApp#833 ·
Todos los issues de PostgresApp/PostgresApp
Issues similares
-
Add: New Channel Pop! Abiertochannels:add check:passed
Dificultad 1/5 Menos de una hora Aptitud para principiantes 90/100
-
Dificultad 2/5 1-3 horas Aptitud para principiantes 70/100
confluentinc/dbt-confluent#160 ·
-
Dificultad 1/5 Menos de una hora Aptitud para principiantes 75/100
-
bug
Dificultad 2/5 1-3 horas Aptitud para principiantes 88/100
AstrBotDevs/AstrBot#10205 ·
-
Dificultad 2/5 1-3 horas Aptitud para principiantes 72/100