I have a server with Postgresql. I don't have access to this server, just the endpoint to connect with psql. I want to backup data from this server to another server using pg_dump. However, my second server does not have postgresql and I don't have root privilege to install it either.
Is there any way to run pg_dump without install postgresql?
It is possible to install postgresql on my client and pg_dump from it but I'm afraid the database is too big for my laptop.
Best Answer
Basically we don't need any Postgresql server to take the backup. Postgresql client is enough for this.
But you must have sudo privilege to install this client.
For Ubuntu:
For RedHat/CentOS/Amazon Linux:
Download the rpm here: https://yum.postgresql.org/repopackages.php#pg96
Dump the Database
More about Pg_dump:
https://www.postgresql.org/docs/9.6/static/app-pgdump.html