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

From: "Priya Kaliappan" <priya_kaliappan(at)infosys(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5624: Getting error while taking the backup of database from remote machine
Date: 2010-08-18 15:15:40
Message-ID: 201008181515.o7IFFeND007252@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5624
Logged by: Priya Kaliappan
Email address: priya_kaliappan(at)infosys(dot)com
PostgreSQL version: 8.3.0.112
Operating system: Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Description: Getting error while taking the backup of database from
remote machine
Details:

Our source machine set up : Enterprisedb 8.3 version(64 bit) Remote machine
: RHEL 8.1 version (64 bit).

We are in a need to take a dump of the database sitting in remote machine
from the source machine that too both postgres db are not in same version.
we are encountering the below error while trying from source machine:

$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

Please provide us a solution on how to backup database residing on remote
machine.


Thanks,
Priya

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-08-18 15:38:57 Re: Unable to create serial column even with permissions
Previous Message Mike Fowler 2010-08-18 14:36:39 Re: BUG #5623: xml2 and uuid-ossp contribs fail to compile