Search code examples
pgadminpgadmin-4

Cannot backup table in postgreSQL using pgAdmin 4

I'm trying to backup my postgreSQL 9.6 database using pgAdmin 4. First, when I tried to use backup, it failed saying that I have to set the binary path on my pgAdmin preferences. It maybe worth noting that I have recently changed the password of user postgres to postgres.

I googled this issue and found an answer (not sure if it's correct though), I set the value of PostgreSQL Binay Path to /usr/lib/postgresql.

However now when I try to back up a table, I get the following error:

Error snapshot

I keep the defaults except for these values:

Only schema: YES
Use Column Insert: YES
Use Insert Commands: YES

Can anyone help me with this?

Solution

  • You need to provide a path where binaries from PostgreSQL-9.6 are present. 

    root@x0x:/opt/PostgreSQL/9.6/bin# pwd
/opt/PostgreSQL/9.6/bin

root@x0x:/opt/PostgreSQL/9.6/bin# ls
clusterdb   droplang  pg_archivecleanup  pg_ctl      pg_recvlogical  pg_test_fsync   pltcl_listmod  psql.bin
createdb    dropuser  pg_basebackup  pg_dump     pg_resetxlog    pg_test_timing  pltcl_loadmod  reindexdb
createlang  ecpg      pgbench        pg_dumpall  pg_restore  pg_upgrade  postgres   vacuumdb
createuser  initdb    pg_config      pg_isready  pg_rewind   pg_xlogdump     postmaster vacuumlo
dropdb      oid2name  pg_controldata     pg_receivexlog  pg_standby  pltcl_delmod    psql

    Check the sample path in screenshot which is working for me, so according to your postgres installation set proper path in preference and you are good to go, make sure not to add any unwanted whitespace before or after path.

    enter image description here