Re: postgres catalog files problem

From: Erik Jones <erik(at)myemma(dot)com>
To: "Josh Harrison" <joshques(at)gmail(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres catalog files problem
Date: 2007-09-17 17:35:52
Message-ID: C36939E7-C7BD-481A-B4E7-2457E5D83A8F@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sep 17, 2007, at 12:31 PM, Josh Harrison wrote:

> Thanks.
> Actually Im currently testing "oracle to postgres migration" with a
> small dataset. I haven't started working with the real dataset. I
> wanted to check with a small dataset before I start with the big one.
> I know the records that I deleted from the pg_class file. so what
> do i do next? Will it help if I drop the problematic tables and
> recreate them? (like i said im currently testing with a small
> datset only and my real data are in oracle and they are not messed
> in nay way). What will happen to my catalog files if i do that?
> Josh

If you can successfully drop those tables, then yes. Given that this
is just a test database, if you have any issues doing that, I'd scrap
the whole database.

Erik Jones

Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-09-17 17:44:30 PostgreSQL Conference Fall 07, all speaker slots filled!
Previous Message Josh Harrison 2007-09-17 17:31:29 Re: postgres catalog files problem