[GENERAL] Append second slave to Warm Standby running on postgresql v8.4 master-slave cluster

2012-08-01 Thread Капралов Александр
Hi. Сan I append second slave without stop or restart master? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Threads With Libpq

2012-08-01 Thread Alban Hertroys
On 1 Aug 2012, at 14:32, dinesh kumar wrote: Respected All, This is my first request/post in PG-Generals. If it is not the place for these kind of queries, then please guide me where i need to be. I have a quick question regarding pthread with PostgreSQL 9.0 Libpq. I'm facing a

Re: [GENERAL] Where should I start for learn development

2012-08-01 Thread AI Rumman
Thanks to all for all the good advice. I was thinking myself to work in any of the open source project and contribute there. As a database developer I think Postgresql is one of the best places for me where I may enjoy working and see the outcome. If you ask about goal, I was thinking to work in a

Re: [GENERAL] Threads With Libpq

2012-08-01 Thread Merlin Moncure
On Wed, Aug 1, 2012 at 8:09 AM, Alban Hertroys haram...@gmail.com wrote: On 1 Aug 2012, at 14:32, dinesh kumar wrote: Respected All, This is my first request/post in PG-Generals. If it is not the place for these kind of queries, then please guide me where i need to be. I have a quick

[GENERAL] Threads With Libpq Issue

2012-08-01 Thread dinesh kumar
Respected All, This is my first post in PG-Generals. If it is not the place for these kind of queries, then please guide me where i need to post. I have a quick question regarding pthread with PostgreSQL 9.0 Libpq. I'm facing a problem with Pthread and libpq. Please find the below program

Re: [GENERAL] Threads With Libpq

2012-08-01 Thread dinesh kumar
Hi Merlin/Alban, Thank you very much for your guidance .. Sure will use Async Llibpq Functionalities or Will use Thread Mutex for making the the queries to be synchronize ... Best Regards, Dinesh manojadinesh.blogspot.com On Wed, Aug 1, 2012 at 7:33 PM, Merlin Moncure mmonc...@gmail.com wrote:

[GENERAL] Streaming replication and high query cancellation values

2012-08-01 Thread Christophe Pettus
I have a couple of questions about how streaming replication works in the presence of a high timeout for query cancellation: 1. Where is the WAL data stored while waiting for the query cancellation, the primary or the secondary? In case of a crash during this interval, could the secondary end

[GENERAL] Need help with SQL query and finding NULL array_agg

2012-08-01 Thread Condor
Hello ppl, I have a problem with one sql query, can some one help me. My query is: SELECT array_agg(month) AS month, array_agg(status) AS status, array_agg(service) AS service, case when array_upper(array_agg(phone), 1) is not null THEN array_agg(phone) else array_agg(mobile) END FROM bills

Re: [GENERAL] File system level backup

2012-08-01 Thread Kevin Grittner
Manoj Agarwal m...@ockham.be wrote: I need to transfer the database from one machine to other. Both machines contain a database with the same name, for example: testdb, but with different data/values, but the structure is exactly same. Take file system level backup from from first

Re: [GENERAL] Streaming replication and high query cancellation values

2012-08-01 Thread Michael Nolan
On 8/1/12, Christophe Pettus x...@thebuild.com wrote: I have a couple of questions about how streaming replication works in the presence of a high timeout for query cancellation: Are you referring to queries on the slave? The master doesn't know what the slave is doing, so it would keep on

Re: [GENERAL] Need help with SQL query and finding NULL array_agg

2012-08-01 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Condor Sent: Wednesday, August 01, 2012 4:16 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Need help with SQL query and finding NULL array_agg Hello ppl,

[GENERAL] Async replication: how to get an alert on failure

2012-08-01 Thread Edson Richter
I have few PostgreSQL servers established with replication. Now, is there any way to receive an e-mail in case of error during synchronization? I mean, is there an script (cron?) I can run (maybe every 5 minutes) that will check if replication is stolen, and send an e-mail in case of failure?

Re: [GENERAL] Threads With Libpq Issue

2012-08-01 Thread Craig Ringer
On 08/01/2012 05:19 PM, dinesh kumar wrote: Respected All, This is my first post in PG-Generals. If it is not the place for these kind of queries, then please guide me where i need to post. I have a quick question regarding pthread with PostgreSQL 9.0 Libpq. I'm facing a problem with

Re: [GENERAL] Threads With Libpq Issue

2012-08-01 Thread Craig Ringer
Argh, disregard. Your post was duplicated, and this copy only just reached me. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Async replication: how to get an alert on failure

2012-08-01 Thread Toby Corkindale
On 02/08/12 10:04, Edson Richter wrote: I have few PostgreSQL servers established with replication. Now, is there any way to receive an e-mail in case of error during synchronization? I mean, is there an script (cron?) I can run (maybe every 5 minutes) that will check if replication is stolen,

[GENERAL] 答复: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time

2012-08-01 Thread leoxu
Hello Craig: Thank you very much! -邮件原件- 发件人: Craig Ringer [mailto:ring...@ringerc.id.au] 发送时间: 2012年7月27日 11:00 收件人: leoxu 抄送: pgsql-general@postgresql.org 主题: Re: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time On 07/27/2012 10:04 AM, leoxu wrote:

[GENERAL] Async replication: how to get an alert on failure

2012-08-01 Thread Edson Richter
I have few PostgreSQL servers established with replication. Now, is there any way to receive an e-mail in case of error during synchronization? I mean, is there an script I can run (maybe every 5 minutes) that will check if replication is stolen, and send an e-mail in

[GENERAL] How to get results with zero count from this query?

2012-08-01 Thread dud
Hello, I have a database table that contains information about the timestamp and location(latitude and longtitude) of the requests made by users. The column structure is as following: requesttime(which is a timestamp without time zone type) | latitude | longtitude I have written the

Re: [GENERAL] Async replication: how to get an alert on failure

2012-08-01 Thread Karl Denninger
On 8/1/2012 5:29 PM, Edson Richter wrote: I have few PostgreSQL servers established with replication. Now, is there any way to receive an e-mail in case of error during synchronization? I mean, is there an script I can run (maybe every 5 minutes) that will check if replication is stolen, and

Re: [GENERAL] How to get results with zero count from this query?

2012-08-01 Thread John R Pierce
On 08/01/12 8:14 PM, dud wrote: Hello, I have a database table that contains information about the timestamp and location(latitude and longtitude) of the requests made by users. The column structure is as following: requesttime(which is a timestamp without time zone type) | latitude |

[GENERAL] subscribe

2012-08-01 Thread Micah R Ledbetter
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general