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

Поиск
Список
Период
Сортировка
От Priya Kaliappan
Тема BUG #5624: Getting error while taking the backup of database from remote machine
Дата
Msg-id 201008181515.o7IFFeND007252@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5624: Getting error while taking the backup of database from remote machine  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5624
Logged by:          Priya Kaliappan
Email address:      priya_kaliappan@infosys.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Fwd: Per-tuple memory leak in 9.0
Следующее
От: "Stanisluv Platonov"
Дата:
Сообщение: BUG #5625: PostgreSQL fail to install files in data folder.