Re: Error during a dump (ts_selectivity, not found)

From: Ahmed Ossama <ahmed(at)aossama(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: adrian(dot)klaver(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Error during a dump (ts_selectivity, not found)
Date: 2011-01-19 20:00:06
Message-ID: 4D3742C6.8070200@aossama.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19/01/2011 21:51, Tom Lane wrote:
> Ahmed Ossama<ahmed(at)aossama(dot)net> writes:
>> I have no problems with the restore without them, and the restore goes
>> fine, but it stops and the point:
>> "WARNING: errors ignored on restore: 6"
> Well, those are exactly the errors you showed us, no?
Yes, these are the only errors I am getting.
>> The database is 60GB and it stops at 47GB.
> Where are you getting those numbers from? In particular, if you're
> comparing on-disk sizes of two installations, maybe the difference is
> just bloat.
I am comparing between the data/base/xxxx sizes.

Let me explain how am i comparing, the db administrator first gave me
the data/ folder of his postgresql installation. Then he gave me the
dump file, so I am comparing the size of the database after my
db_restore (when i get the error) with the size of the database in the
data folder he gave me.

Am I making an accurate comparison between the original db and the one i
am trying to dump by comparing their sizes?

If I am wrong and this size difference is just a bloat (which I hope)
how do I make sure of that?

Best Regards,
Ahmed Ossama

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DM 2011-01-19 20:12:10 Re: How can I find the schema that a table belongs to?
Previous Message Tom Lane 2011-01-19 19:51:27 Re: Error during a dump (ts_selectivity, not found)