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
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) |