Re: BUG #5624: Getting error while taking the backup of database from remote machine

"Priya Kaliappan" <priya_kaliappan(at)infosys(dot)com> writes:
> Our source machine set up : Enterprisedb 8.3 version(64 bit) Remote machine
> : RHEL 8.1 version (64 bit).

> $pg_dump -U postgres -h (ip) -d db_name
> Password:

> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: column "nspparent" does not
> exist
> pg_dump: The command was: SELECT tableoid, oid, nspname, (SELECT rolname
> FROM pg _catalog.pg_roles WHERE oid = nspowner) as rolname, nspacl,
> nspparent FROM pg_namespace WHERE nspparent = 0

You should probably be asking EDB for support on this, not the PG
community. I will just note that there is not, and never has been,
any pg_namespace.nspparent column in any community release ... so this
is evidently an EDB-custom version of pg_dump, and it's not compatible
with the server you're pointing it at.

regards, tom lane