Re: [ADMIN] Migrating a live database

2011-01-17 Thread Vladislav Geller
HI, The problem with this solution is that i don't have enough space on the targeted live to implement such a procedure. It would have to work by pulling data directly off the live server. The issue with new data whilst the procedure is running (over a span of days or weeks in not severe as eac

Re: [ADMIN] How do I stop/disable PITR and safely clean WAL segments?

2011-01-17 Thread Vladimir Rusinov
On Tue, Jan 18, 2011 at 8:18 AM, Gnanakumar wrote: > Hi, > > Our production server is running PostgreSQL v8.2.3 on CentOS release 5.2 > (Final). > > We've setup PITR in our production server. For some reasons, after setting > up PITR, we're not able to manage and maintain it. Eventually, our WAL

Re: [ADMIN] Migrating a live database

2011-01-17 Thread Vladimir Rusinov
On Tue, Jan 18, 2011 at 8:07 AM, Vladislav Geller < vladislav.gel...@vincorex.ch> wrote: > Hello, > > I'm currently in the process of migrating a huge live database from one > part of the world to the other (for local use and data analysis). The > bandwidth does not allow me to get a decent transf

Re: [ADMIN] Migrating a live database

2011-01-17 Thread Scott Marlowe
On Mon, Jan 17, 2011 at 10:07 PM, Vladislav Geller wrote: > Hello, > > I'm currently in the process of migrating a huge live database from one part > of the world to the other (for local use and data analysis). The bandwidth > does not allow me to get a decent transfer speed. Furthermore i can n

[ADMIN] How do I stop/disable PITR and safely clean WAL segments?

2011-01-17 Thread Gnanakumar
Hi, Our production server is running PostgreSQL v8.2.3 on CentOS release 5.2 (Final). We've setup PITR in our production server. For some reasons, after setting up PITR, we're not able to manage and maintain it. Eventually, our WAL archive drive (secondary drive) has become full (100% use) and ad

[ADMIN] Migrating a live database

2011-01-17 Thread Vladislav Geller
Hello, I'm currently in the process of migrating a huge live database from one part of the world to the other (for local use and data analysis). The bandwidth does not allow me to get a decent transfer speed. Furthermore i can not migrate during business hours since the connection is critical.

Re: [ADMIN] ssl client cert authentication

2011-01-17 Thread Bruce Momjian
Ray Stell wrote: > On Mon, Nov 01, 2010 at 12:46:33PM -0400, Tom Lane wrote: > > Ray Stell writes: > > > Someone asked about ssl client cert auth recently. I got > > > this to work, but something tripped me up. > > > > > http://developer.postgresql.org/pgdocs/postgres/ssl-tcp.html > > > > > sta

[ADMIN] Postgres Backup Utility

2011-01-17 Thread Bradley Holbrook
Hello! First day on the new mailing list as I have need of some expert's advice. I need to be able to quickly apply the structure updates from a development database to a testing database, and do selective data updates (like on lookup tables, but not content tables). Any help would be a

Re: [ADMIN] Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time

2011-01-17 Thread Achilleas Mantzios
Στις Saturday 15 January 2011 00:35:44 ο/η Kevin Grittner έγραψε: > Achilleas Mantzios wrote: > > > I agree about the subject line. But whouldn't -bugs be a more > > apropriate place than -performance? > > Is it returning incorrect results, or is it not running as fast as > you would like? alr

Re: [ADMIN] Out of Memory postgres

2011-01-17 Thread Silvio Brandani
Il 14/01/2011 21.34, Kevin Grittner ha scritto: Silvio Brandani wrote: I try to change odbc drivers (version 8.x to 9.x) and postgres version (8.3.x to 9.x , Linux platform ) but the error appear in all versions. MessageContext: 1590689792 total in 211 blocks; 8496 free (19 chunks); 15