Home / Questions / 5195
Accepted
Diana Carolina Hernandez
Asked: 2020-03-05 05:58:03 +0800 CST 2020-03-05 05:58:03 +0800 CST

How to backup a postgres database on windows?

  • 772

Updated

Apparently it should only be done pg_dump -U <usuario> <nombre_bd>

I enter in 2 ways and I get the same error:

  1. I go in Inicio- Todos los programas - PostgreSQL 9.4 - SQL Shelland place that instruction and nothing happens, if I put it at the end ;it tells me that there is a syntax error.

  2. I enter by cmd - cd C:\Files Program\Postgresql\9.4\binand place the same instruction... without ; nothing happens and with ; get syntax error.

Can you help me? I don't know how to use windows for these things and some others I have already forgotten. If possible I would like the backup to stay on the desktop or in my Documents.

windows

3 Answers

  1. Best Answer

    As @rnd says, these commands must be run in the Windows command console, precisely in the link you put, the person asks how to do it from the command console.

    The command console in Windows is opened by simply pressing tecla windows+ R, typing cmdand then running from there. You can also open it from the start menu and search for cmd.

    To give you a better idea of ​​the command, you can see this link .

    • 4

  2. To make a backup in vs 9.5 postgres on windows:

    • Enter the windows console
    • Go to the path where the file is located with the cd command. Default isC:\Archivos de programas\postgresql\9.5\bin

    • Run the following line:

      pg_dump.exe -h localhost -p 5432 -U postgres -F c -v -d 
{nombre_de_tu_db} -f {ruta_donde_se_aloja_el_archivo}

    The path can be something likeC:\xampp\htdocs\carpeta_proyecto\pyFecha.backup

    PS: remember to put the extension '. backup ' to your file

    • 4

  3. You enter from cmd to the path where you have the postgresql installation and execute the following command.

    pg_dump.exe -h localhost -p 5432 -U postgres -F c -v -d NOMBRE_BD -f RUTA

    I leave you this link so you can see the process. https://www.youtube.com/watch?v=dQ4pRSRPfWk#action=share

    • 2