pg dump command

Using UNIX pipe concept one can dump database to another server securely using ssh protocol. All you need remote execution rights for the ‘dd’ command, over SSH. This allows you to run database dumps across an encrypted channel. Dump Postgres Database using ssh Use pg_dump command command: pg_dump -U USERNAME YOUR-DATABASE-NAME | ssh user@remote.server.com “dd […]

{ 5 comments }

Describes how to backup and restore postgresql database under Linux / UNIX operating system using pg_dump and psql commands.

{ 27 comments }