dump

Поиск
Список
Период
Сортировка
От Matt Block
Тема dump
Дата
Msg-id 001601c108b7$2d7ba5c0$6400000a@internal.home.blockdev.net
обсуждение исходный текст
Ответы Re: dump  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
I'm having a problem dumping a database.  I'm not the original
author of the database, and the schema is a bit unfamiliar.  It's
possible that something is really wonked deep down in the data...

[prompt]$ pg_dump -s smile
NOTICE:  Unrecognized variable client_encoding
getTables(): relation 'users': cannot find function with oid 1644 for
trigger RI_ConstraintTrigger_196192

I understand neither the NOTICE, nor the error (which appears to
be fatal).

The oid does not exist in 'users' (or, indeed, in any other table
in the database).  PostgreSQL appears to be version 7.0.
(SELECT version(); gives
PostgreSQL 7.0.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66)

The goal, here, is to get the information and structure from this
installation into another installation; I have PostgreSQL 7.1 and
change installed on another box, and need the database on the new
box.  My thought is that the easiest way to accomplish this is to
pg_dump -d and read it in on the new installation.  If there's a
simpler or better way, please advise.

Indeed, please advise!

Thanks in advance,

  -- Matt


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

Предыдущее
От: John Burski
Дата:
Сообщение: Re: Info regarding integrating a barcode reader with PostgreSQL
Следующее
От: ryan.a.roemmich@mail.sprint.com
Дата:
Сообщение: index skipped in favor of seq scan.