Psql -U postgres -d DVD_RENTAL_DB -f C:\Postgres_DB_Backups\DVD_RENTAL_DB.sqlĥ. Open the Windows Command Prompt as an Administrator and you will be in this directory:ģ. Windows 7 or later, Intel 64-bit processor. To Restore my Database I used the following in the Windows command prompt while running it as an administrator: 1. As of Go 1.13, the go command by default downloads and authenticates modules using the Go module mirror and Go checksum database run by Google. The PostgreSQL documentation didn't mention anything about double quotes around the pg_dump executable file path. This worked for me ONLY after I put double quotes around the pg_dump executable file path, before when I was adding the file path without double quotes the back up was not working probably due to spaces in my file path.
Instead, specify the output filename with the -f option: "C:\Program Files\PostgreSQL\14\bin\pg_dump" -U postgres -p 5432 -W -F p -h localhost -f C:\Postgres_DB_Backups\DVD_RENTAL_DB.sql DVD_RENTAL_DB
#DOWNLOAD PG COMMANDER INSTALL#
For all Pgadmin software, execute the following command: sudo apt install pgadmin4 If you need the Desktop version of the application to Ubuntu, install the pgadmin4-desktop package onto your computer with the command below. The shell will helpfully "correct" encoding issues and corrupt your dump. Using the apt install command below, install the software. To backup my "DVD_RENTAL_DB" database to a local folder on my computer I had to use the below in the Windows command prompt while running it as an administrator:ĭon't use shell redirection (>) on Windows with pg_dump.
0 kommentar(er)
