Home / Questions / 5338
Accepted
Diana Carolina Hernandez
Asked: 2020-03-08 06:23:05 +0800 CST 2020-03-08 06:23:05 +0800 CST

Create a Postgres backup via console in Debian

  • 772

I need to take a backup of my database via console / terminal (for academic reasons) but I get these errors, I have Debian Jessie and psql (PostgreSQL) 9.5.1.

im1

im2

postgresql

2 Answers

  1. Best Answer

    To execute pg_dumpit you must do it outside the console psql, that is, execute it directly in your terminal since it is a command like any other:

    $ pg_dump -U prueba ripso_v1 -f miarchivosql.sql

    For more information you can refer to the documentation:

    • 4

  2. For Windows you must define the PostgreSQL folder as environment variables . Then you must run the CMD and write these commands:

    pg_dump -h localhost -p 5432 -U postgres -f "E:/prueba.sql" name_basedatos

    ... and voila, with that it will create a copy and to restore the copy. It's the same, you create the database and then execute these commands in CMD :

    psql -h localhost -p 5432 -U postgres -f "E:/prueba.sql" nombre_basedatos
    • 1