-
Notifications
You must be signed in to change notification settings - Fork 328
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
How to run a postgres container using the raw pgdata? #1400
Comments
@jkatz do you have any suggestions? |
I've been using kind lately to run PGO locally along with my databases. It's been pretty easy and efficient. If you have the contents of the |
What about the container id that is in the pgdata folder? |
@jkatz it doesn’t work because it’s expecting the pgdata to be in |
Ok I found the answer to this HERE. Hopefully it works. |
I’m unable to get this to work because the Postgres shutdown with no errors. Any suggestions? |
I am trying to use the docker image https://hub.docker.com/r/crunchydata/crunchy-postgres and i am using below docker-compose
Output of this docker-compose postgres container is not working ** log**
what i am missing here ? |
I was running crunchydb postgres on Kubernetes, and I was backing up the underlying pgdata volume using a tool called velero.
I am trying to use the raw volume data to spin up a postgres locally on my machine so I can run a pgdump, however I am finding very difficult to start the postgres using the underlying pddata.
I am trying to use the docker image documented at the following link, because the HA container
registry.developers.crunchydata.com/crunchydata/crunchy-postgres-ha:centos8-13.4-4.7.3
seems overly complex to run as a single docker container and does not seem to be able to run outside of a kubernetes environment.https://access.crunchydata.com/documentation/crunchy-postgres-containers/4.3.1/container-specifications/crunchy-postgres
I am very confused because the
/pgdata
folder of thecrunchy-postgres
image creates a folder using the id of the running container, which is impossible to know before starting the container. I want to be able to simply mount the pgdata and have the database running in a single image locally for running pgdump.I tried using the official postgres image, but that miserably fails because there are so many postgres modules that the crunchydb postgres database uses, and the official image does not support them.
I was thinking mabye the
/recover
path is where I am supposed to mount the pgdata, because it says that it is the "Volume used for Point In Time Recovery (PITR) during startup of the PostgreSQL database.". However, there is no documentation on how to use it at all.In summary, how can I run a local single container postgres on my machine using the raw pgdata that I backed up in my kubernetes environment?
Your help is much appreciated.
The text was updated successfully, but these errors were encountered: