Re: [ADMIN] Unending DB migration

2012-04-20 Thread Thomas Kellerer
ЇЯЅHAÐ wrote on 17.04.2012 01:27: Hi, We are trying to migrate from Postgres to Oracle, although our DB is gigantic but we started on Mar 14th 2012 & its still running with an average of 40 records per day How can we check what is going wrong. Any memory leak, CPU issue or anything. If y

Re: [ADMIN] Unending DB migration

2012-04-20 Thread Walter Hurry
On Mon, 16 Apr 2012 16:27:38 -0700, ЇЯЅHAÐ wrote: > Hi, > > We are trying to migrate from Postgres to Oracle, although our DB is > gigantic but we started on Mar 14th 2012 & its still running with an > average of 40 records per day 400,000? That's pathetic. Why didn't you just use Postgres's

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-04-20 Thread Alexander Fortin
On 3/30/12 12:14 PM, Bernhard Schrader wrote: > > Ok, well with Kernel 2.6.38 xfs introduced a new "feature" (i think it > was dynamic preallocation) which caused some strange behaviour for me > also, i discussed it on xfs mailinglist, maybe this gives you some hints > of solving your different di

Re: [ADMIN] ERROR: invalid input syntax for type timestamp: ""

2012-04-20 Thread Albe Laurenz
Kshirsagar, Swanand wrote: > I am using Postgres version 8.3.17 on one of my database server. I have received a .sql dump file from > my client. Which is supposed to be taken from a Postgres 8.3.7 db. Now, I have created an empty > database and I am trying to restore the .sql file with command psql