search

Paxa / postbird

Open source PostgreSQL GUI client for macOS, Linux and Windows
MIT License
1.55k stars 124 forks source link

Linux: Can not find pg_dump in a system. #97

Open khoerodin opened 4 years ago

khoerodin commented 4 years ago

Install from Snap on Ubuntu 18.04 postgresql-client already installed:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
postgresql-client is already the newest version (10+190ubuntu0.1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

but error still appears:

Type: table

Estimate rows count: 0

Total size on disk: 24 KB (Table: 0 Bytes, Indexes: 16 KB, Toast: 8 KB)

Source SQL
Loading...Error happen while running pg_dump:
Can not find pg_dump in a system. Make sure PostgreSQL client is installed.
On Ubuntu/Debian - package 'postgresql-client'
On RHEL/Fedora - package 'postgresql'
bohdanbrn commented 4 years ago

I have the same problem. Have you solved this issue?

khoerodin commented 4 years ago

Not yet @bohdanbrn

Paxa commented 4 years ago

When you open terminal and type pg_dump can it find executable?

joacopaz commented 1 year ago

This is still an issue. I can find the pg_dump executable in my pc, it's in /etc/bin, but Postbird does not find it.

After checking in Postbird's Window -> Console I can see it properly runs the pg_dump command with the proper parameters, and even says Complete.

If I copy/paste this command into my Linux Terminal it asks me for a password (for the DB user) and dumps it correctly, this can be a useful workaround in the meantime for those of you who want to dump your DB's schema, but does not solve the issue of it not showing in Postbird.

Maybe Postbird's issue could be related to the Password prompt I get when running it in my Linux terminal?