I need to create a Postgres database dump using pg_dump. Database located in Kubernetes pod. I am trying to get dump in directory format, not just single .sql file. But I don't understand how can I specify a directory.
When I try this command:
kubectl exec patroni-0 -- bash -c "pg_dump -U username db_name --format=d" > db_dump_folder
I got an error:
pg_dump: [directory archiver] no output directory specified
command terminated with exit code 1
Thanks in advance!
When using pg_dump to create a database dump in directory format, you need to specify an output directory that pg_dump can write to directly. The command you used tried to redirect stdout to a directory, which is not how pg_dump in directory format works. Instead, you need to specify the directory using the -f option or --file option directly within your pg_dump command.
However, because the dump needs to be done inside a Kubernetes pod, the directory on your local machine where you want the dump to be stored must be accessible to the pod or you can store it in the pod and copy to your local.
For the second option, you can go about it this way:
pg_dump inside the pod, specifying a temporary directory on the pod for the dump:kubectl exec patroni-0 -- bash -c "mkdir /tmp/db_dump"
kubectl exec patroni-0 -- bash -c "pg_dump -U username -d db_name --format=d -f /tmp/db_dump"
kubectl cp patroni-0:/tmp/db_dump ./db_dump_folder
kubectl exec patroni-0 -- bash -c "rm -rf /tmp/db_dump"
Hope this helps.