Re: [GENERAL] Question regarding DEALLOCATE pdo_stmt_00000001

2014-05-22 Thread Laurentius Purba
On Wed, May 21, 2014 at 7:50 PM, David G Johnston < david.g.johns...@gmail.com> wrote: > Laurentius Purba wrote > > Hello all, > > > > I've been seeing lots of this processes in my database DEALLOCATE > > pdo_stmt_0001 with idle state. > > > &g

[GENERAL] Question regarding DEALLOCATE pdo_stmt_00000001

2014-05-21 Thread Laurentius Purba
Hello all, I've been seeing lots of this processes in my database DEALLOCATE pdo_stmt_0001 with idle state. Executing *select * from pg_stat_activity where query like 'DEALLOCATE%';*I can see some of them are idle for +/- 30 minutes, and there is one idle for 4 days. When I checked one of th

[GENERAL] Database compare tools

2014-02-17 Thread Laurentius Purba
Hello all, I was wondering if anyone of you know any database compare tools. I've been using PgComparer, and it has been working great until we upgraded Postgres from 9.0 to 9.3, and PgComparer stops to work. Any help is appreciated. Thanks! -Laurent

Re: [GENERAL] Is it advisable to pg_upgrade directly from 9.0 to 9.3?

2013-12-20 Thread Laurentius Purba
ec 20, 2013 at 1:05 AM, Michael Paquier wrote: > On Thu, Dec 19, 2013 at 10:07 PM, Laurentius Purba > wrote: > > Hi Greg, > > > > I just wanted to know if you were able successfully upgrading from 9.0 to > > 9.3. > > > > I have been doing this upgrad

Re: [GENERAL] Is it advisable to pg_upgrade directly from 9.0 to 9.3?

2013-12-19 Thread Laurentius Purba
Hi Greg, I just wanted to know if you were able successfully upgrading from 9.0 to 9.3. I have been doing this upgrading this past week, but always ended up with unsuccessful upgrade. It will be great if you can share you knowledge on this. Thanks! -Laurent On Thu, Nov 7, 2013 at 2:07 PM, Gre

Re: [GENERAL] Clone database using rsync?

2013-11-14 Thread Laurentius Purba
org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- - *Laurentius Purba* - SproutLoud Media Networks, LLC. - lpu...@sproutloud.com - www.sproutloud.com - • - [image: Facebook] <http://www.facebook.com/SproutLoud> [image:

Re: [GENERAL] Postgresql 9.0.13 core dump

2013-10-15 Thread Laurentius Purba
ly it is not. Regarding an update PDF, I am not sure if this update causing core dump, as I mentioned in my second paragraph. Anyway, thanks for your response, Tomas. -Laurent On Mon, Oct 14, 2013 at 4:37 PM, Tomas Vondra wrote: > On 14.10.2013 22:18, Laurentius Purba wrote: > > Hello

Re: [GENERAL] Postgresql 9.0.13 core dump

2013-10-15 Thread Laurentius Purba
Kevin, Thanks for the response. I will look into it based on your suggestion. -Laurent On Mon, Oct 14, 2013 at 8:29 PM, Kevin Grittner wrote: > Laurentius Purba wrote: > > > I did google this error message, "...signal 10: Bus error.." and > > found the issue w

Re: [GENERAL] Postgresql 9.0.13 core dump

2013-10-14 Thread Laurentius Purba
Hi Kevin, Thanks for your response. I did google this error message, "...signal 10: Bus error.." and found the issue with hardware problem, memory. Do you have any other pointers or clues that I can look into? -Laurent On Mon, Oct 14, 2013 at 4:33 PM, Kevin Grittner wrote: &g

[GENERAL] Postgresql 9.0.13 core dump

2013-10-14 Thread Laurentius Purba
Hello all, I am having core dump on Postgres 9.0.13 with the message "...was terminated by signal 10: Bus error...". So, I set a PID on the log file to capture specific PID that causing this crash. After, several crashes, I finally got the PID that causing this crash. But I am still not convinced