dump

From: "Matt Block" <matt(at)blockdev(dot)net>
To: <pgsql-general(at)PostgreSQL(dot)org>
Subject: dump
Date: 2001-07-09 20:38:57
Message-ID: 001601c108b7$2d7ba5c0$6400000a@internal.home.blockdev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: dump at 2001-07-09 21:23:35 from Peter Eisentraut

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2001-07-09 21:03:31 Interfacing with MSAccess
Previous Message ryan.a.roemmich 2001-07-09 20:16:34 index skipped in favor of seq scan.