5

I try to backup my university project database. I followed the instruction, everything seems to be inputed:

1:

enter image description here

2:

enter image description here

3:

But the only pop-out I get is this one in right-bottom corner of PGAdmin 4: enter image description here

From the Official site, there should be another pop-up message, similiard to this one:

enter image description here

But I don't get this one, nor I get the other one that is displayed where any error occurs.

I tried to directly use pg_dump.exe, but it prompts me for a password. I tried all my passwords - user password, server password which I use to connect to my database in PGAdmin 4, other passwords, but none of them seem to work.

enter image description here

I tried to find any information about this, but all articles about pg_dump.exe are about how to automatize password input. What is the cause of this backup silent failure, and which password does pg_dump.exe need?

I'll add any details if needed, I was trying to figure it out for 4 hours now...

xinaiz
  • 7,744
  • 6
  • 34
  • 78
  • `pg_dump` uses the current operating system user if you don't provide one (the actual username is part of the error message but your [screen shot](http://meta.stackoverflow.com/questions/285551/why-may-i-not-upload-images-of-code-on-so-when-asking-a-question/285557#285557) cut that off). Use the `-U` parameter to specify the same username you use in pgAdmin. –  Feb 28 '17 at 07:12

3 Answers3

6

I've tried with pgAdmin4 1.4 and still my backup file was empty so I moved back to pgAdmin3 and it worked like a charm. Although pgAdmin3 is not maintained anymore I suggest you use it until pgAdmin4 is up to it but right now it is way too slow.

vegemat
  • 75
  • 1
  • 6
3

Can you upgrade your pgAdmin4 with version 1.2 and try again? https://www.pgadmin.org/

I think they have fixed the issue in new release.

Murtuza Z
  • 5,639
  • 1
  • 28
  • 52
1

Clearing the items in the path: C:\Users\yourUser\AppData\Roaming\pgAdmin seems to do the trick. Tested on PGadmin 4.29.

Be aware that all the sessions and saved servers will be gone.

fizcris
  • 63
  • 7