--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 |
longtitud
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,
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 followi
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 cas
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:
> H
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, an
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
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 "Pthr
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?
> -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
>
> Hell
On 8/1/12, Christophe Pettus 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 shipping streaming
"Manoj Agarwal" 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 machine for
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 W
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
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 wrote:
> On Wed, Aug 1,
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
beh
On Wed, Aug 1, 2012 at 8:09 AM, Alban Hertroys 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 question
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
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
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
21 matches
Mail list logo
