Can I install pg_dump without installing postgres on Alpine?

postgresql pg-dump alpine
Oleg picture Oleg · Nov 16, 2016 · Viewed 15.2k times · Source

I have tried to install pg_dump as part of installation of postgres-client, however it does not include pg_dump.

Can pg_dump be installed without a full installation of postgres on Alpine Linux?

Answer

Lee Benson picture Lee Benson · Dec 12, 2016

No - to install pg_dump and associated utilities, you'll need to run apk add postgresql, which will install the full PostgreSQL suite.

The installed size is currently 12.1mb (for v9.6.0-r1) vs just 451kb for postgresql-client, so it's definitely bigger. If you're using Alpine in Docker, that might not be a big deal. If you're using it in an embedded device where size matters, you could simply copy over pg_dump or whatever else you need.

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Read More
How do I do a schema only backup and restore in PostgreSQL?

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any single command available for this? For example, can I pg_dump and restore in single line?

Read More