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
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
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 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
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
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:
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
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
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
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
-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,
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?
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
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 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,
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:
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
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
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
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 |
--
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