Re: [GENERAL] Question regarding DEALLOCATE pdo_stmt_00000001

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. Executing *select * from pg_stat_activity where query like

[GENERAL] Question regarding DEALLOCATE pdo_stmt_00000001

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

[GENERAL] Database compare tools

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?

, Michael Paquier michael.paqu...@gmail.comwrote: On Thu, Dec 19, 2013 at 10:07 PM, Laurentius Purba lpu...@sproutloud.com 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 upgrading this past week, but always ended up

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

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,

Re: [GENERAL] Clone database using rsync?

://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: Twitter]http://twitter.com/sproutloud [image: Google+] http

Re: [GENERAL] Postgresql 9.0.13 core dump

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 kgri...@ymail.com wrote: Laurentius Purba lpu...@sproutloud.com wrote: I did google this error message, ...signal 10: Bus error.. and found the issue

Re: [GENERAL] Postgresql 9.0.13 core dump

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 t...@fuzzy.cz wrote: On 14.10.2013 22:18, Laurentius Purba wrote: Hello all

[GENERAL] Postgresql 9.0.13 core dump

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

Re: [GENERAL] Postgresql 9.0.13 core dump

: Laurentius Purba lpu...@sproutloud.com wrote: I am having core dump on Postgres 9.0.13 with the message ...was terminated by signal 10: Bus error Every time I have seen this it has been a bug in VM or jail code; although a hardware problem could also cause it. -- Kevin Grittner EDB