Re: [ADMIN] How to auto swtich the roles of primary and standby

2012-04-20 Thread videanuadrian
hi, i tried the exact setup that you described here, but unfortunately i had to restart the new master(former slave)  in order to get the new settings and this will conduct to a downtime and service interruption. anyway thanks for sharing your experience. Adrian Videanu --- On Fri, 4/20/12,

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

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

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 copy

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