Where is backup file?

[TheGP]

After doing backup after it finishes the file is not present. Anyway how to access it if its on remote machine and I have no access to it with SSH.

[yogeshmahajan-1903]

If you are using pgadmin in server mode, then you can download the file from Tools > Storage Manager > Select file and click on download button. Please refer this link.

[TheGP]

No, just normal mode, desktop app which connects to the server.

[yogeshmahajan-1903]

If its desktop and you did not provide any path in backup dialog for filename field, then it will be stored in user home directory with which pgadmin is installed.

[TheGP]

I dont see it there. grep doesnt find any files with such name either on local machine nor at server where I have access

[yogeshmahajan-1903]

@TheGP
Can you please reopen backup dialog and click of file sign in filename field? pgadmin saves last directory used. So if you have not open file manager after taking backup, it should open the location which was used to store backup file.

[TheGP]

I just made new one, it says in details: /app/bin/pg_dump --file "/home/eugenebos/test.sql" --host "1.1.1.1" --port "5433" --username "test" --no-password --format=c --large-objects --verbose --table "public.test" "test"
So where is it?

cat /home/eugenebos/tokens.sql                                    (base) 
cat: /home/eugenebos/tokens.sql: No such file or directory

[yogeshmahajan-1903]

@TheGP
File name specified in the command is test.sql however you are checking of tokens.sql

[TheGP]

cat test.sql                          (base) 
cat: test.sql: No such file or directory

I did it multiple times, probably posted wrong one
Plus as I said I searched the files before with "find"

[yogeshmahajan-1903]

As command indicate file is located at home directory it should be present there only. (I your case /home/eugenebos/test.sql). Are you searching with correct user?
Here is screenshot for my pgadmin desktop app on Mac OS.

[TheGP]

I told u I tried "find" I do it from a user who has full access. There are no other users.

[yogeshmahajan-1903]

@TheGP
We can connect over the call to figure out the issue between 9AM - 5 PM IST