> On 07/20/2016 11:53 AM, dangal wrote:
>>
>> Dear , I have a question for them , in our work we have an environment
>> with
>> streaming replication and everything works in the best way , we are
>> trying
>> to implement high availability and for that we try to use pgpool and
>> we
>> could not ge
On 07/20/2016 11:53 AM, dangal wrote:
Dear , I have a question for them , in our work we have an environment with
streaming replication and everything works in the best way , we are trying
to implement high availability and for that we try to use pgpool and we
could not get it to work with md5 a
Dear , I have a question for them , in our work we have an environment with
streaming replication and everything works in the best way , we are trying
to implement high availability and for that we try to use pgpool and we
could not get it to work with md5 authentication
The area of systems my com
On Thu, Jun 9, 2016 at 8:01 PM, Sunil N Shinde
wrote:
> Thanks Venkata.
>
>
>
> I am considering latest version now i.e. 9.4 or 9.5 on Linux 6.
>
> Is there any difference in setup from 9.1 to 9.5?
>
There is no difference in the setup. Streaming Replication in the version
9.5 is a lot better wi
.org
Subject: Re: [GENERAL] High availability and load balancing ...
I need to do the setup for High availability function.
Also want to implement load balancing for 02 nodes.
You will have to build streaming replication which was introduced in
PostgreSQL-9.0
I think PGPool will be require for
> Hi,
>
> I need to do the setup for High availability function.
> Also want to implement load balancing for 02 nodes.
> I think PGPool will be require for that. Can I use PGPool without cost.
Yes, you can. Pgpool-II is an open source product.
> Can I get the basic steps to do this setup?
http:
>
>
>
> I need to do the setup for High availability function.
>
> Also want to implement load balancing for 02 nodes.
>
You will have to build streaming replication which was introduced in
PostgreSQL-9.0
> I think PGPool will be require for that. Can I use PGPool without cost.
>
pgpool-II is a
Hi,
I need to do the setup for High availability function.
Also want to implement load balancing for 02 nodes.
I think PGPool will be require for that. Can I use PGPool without cost.
Can I get the basic steps to do this setup?
Database-- Postgresql 9.1
On Thu, Dec 4, 2014 at 12:32 PM, Tatsuo Ishii wrote:
> No. Just the implementation of watchdog has been changed (more
> precisely new life check mode added). In recent versions (since 3.3)
> it uses UDP packet for life check of pgpool, which is pretty much
> similar to heartbeat.
>
>
Thanks for
> On Thu, Nov 27, 2014 at 7:26 PM, Maila Fatticcioni > wrote:
>
>> I was wondering if there is another way to set up a complete cluster
>> that would manage in case of failure:
>>
>> * the relocation of the VIP (virtual ip address)
>> * the relocation of the main instance of Postgresql
>>
>
> Co
On Thu, Nov 27, 2014 at 7:26 PM, Maila Fatticcioni wrote:
> I was wondering if there is another way to set up a complete cluster
> that would manage in case of failure:
>
> * the relocation of the VIP (virtual ip address)
> * the relocation of the main instance of Postgresql
>
Consider trying p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/27/2014 12:34 PM, Andreas Kretschmer wrote:
> Maila Fatticcioni wrote:
>
>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1
>>
>> Hello. I need to set up a high availability cluster with two
>> servers. I have looked for the best configuration I
Maila Fatticcioni wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello.
> I need to set up a high availability cluster with two servers. I have
> looked for the best configuration I could use but I cannot find
> anything I like. I cannot used the DRBD option and I have to use
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello.
I need to set up a high availability cluster with two servers. I have
looked for the best configuration I could use but I cannot find
anything I like. I cannot used the DRBD option and I have to use
Ubuntu 14.04 as OS.
In the past I have set up
On 23/06/10 03:05, John R Pierce wrote:
> yeah. generally when money is involved in the transactions, you gotta
> stick to the 'no committed data lost ever'. there's plenty of other use
> cases for that too.
2PC is sometimes a reasonable alternative to shared-storage failover,
though. It can be
John R Pierce writes:
> yeah. generally when money is involved in the transactions, you gotta stick
> to the 'no committed data lost ever'. there's plenty of other use cases for
> that too.
Well, it's a cost/benefit/risk evaluation you have to make. It'd be bad
news that the cost for covering y
On 06/22/10 1:58 AM, Dimitri Fontaine wrote:
John R Pierce writes:
failure modes can
include things like failing fans (which will be detected, resulting in a
server shutdown if too many fail), power supply failure (redundant PSUs, but
I've seen the power combining circuitry fail). Any of
John R Pierce wrote:
I don't like power cycling servers, so I'd prefer not to use power
switch based fencing, although I believe my blade box's management
unit is supported as a power fencing device.
I consider power control fencing to be a secondary resort if you don't
have hardware where a
John R Pierce writes:
> failure modes can
> include things like failing fans (which will be detected, resulting in a
> server shutdown if too many fail), power supply failure (redundant PSUs, but
> I've seen the power combining circuitry fail). Any of these sorts of
> failures will result in a f
On Mon, 2010-06-21 at 23:08 -0400, Greg Smith wrote:
>
> The hard part of shared storage failover is always solving the "shoot
> the other node in the head problem", to keep a down node from coming
> back once it's no longer the active one. In order to do that well,
> you really need to lock th
On 06/21/10 8:08 PM, Greg Smith wrote:
The hard part of shared storage failover is always solving the "shoot
the other node in the head problem", to keep a down node from coming
back once it's no longer the active one. In order to do that well,
you really need to lock the now unavailable node
John R Pierce wrote:
the commercial cluster software vendors insist on using dedicated
connections for the heartbeat messages between the cluster members and
insist on having fencing capabilities (for instance, disabling the
fiber switch port of the formerly active server and enabling the port
On 06/21/10 12:23 PM, Dimitri Fontaine wrote:
John R Pierce writes:
Two DB servers will be using a common external storage (with raid).
This is also one of the only postgres HA configurations that won't lose
/any/ committed transactions on a failure. Most all PITR/WAL
replicatio
John R Pierce writes:
>>> Two DB servers will be using a common external storage (with raid).
>
> This is also one of the only postgres HA configurations that won't lose
> /any/ committed transactions on a failure. Most all PITR/WAL
> replication/Slony/etc configs, the standby storage runs severa
Hi,
On 21/06/2010, at 3:37 AM, Raymond O'Donnell wrote:
On 20/06/2010 17:34, Elior Soliman wrote:
Hello,
My company looking for some solution for High availability with
Postgres.
There's quite a bit of information in the documentation here:
http://www.postgresql.org/docs/8.4/static/high
On 20/06/2010 17:34, Elior Soliman wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
There's quite a bit of information in the documentation here:
http://www.postgresql.org/docs/8.4/static/high-availability.html
HTH,
Ray.
--
Raymond O'Donnell ::
On 06/20/10 10:36 AM, David Fetter wrote:
On Sun, Jun 20, 2010 at 07:34:10PM +0300, Elior Soliman wrote:
My company looking for some solution for High availability with Postgres.
Our optional solution is as follows :
Two DB servers will be using a common external storage (with raid).
On 21/06/10 00:34, Elior Soliman wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB files on the s
On Sun, Jun 20, 2010 at 07:34:10PM +0300, Elior Soliman wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid).
Stop right there. This is the Ora
Hello,
My company looking for some solution for High availability with Postgres.
Our optional solution is as follows :
Two DB servers will be using a common external storage (with raid). Both
servers are going to use the same DB files on the storage (as
active/passive)
Now I'm trying to understa
Hi Todd,
Interesting you should bring that up, supporting high availability is
actually something we've talked about doing a bit further down the road.
Before we get to that though, there are still quite a few low hanging
fruit to pick.
If someone with experience in this field picks up the ball a
On Tue, Nov 18, 2008 at 11:09 AM, Pietro Tedesco
<[EMAIL PROTECTED]> wrote:
> We have an instance of PostgreSQL on Windows 2003 with some application
> and our customer have asked for solution
> 24x7 without human intervention for problem on the hardware/software
> primary instance.
> Actualy there
There are a couple of solutions probably.
First off, search pgfoundry for possibilities, look into clustering and
replication.
A little more insight would make it easier to answer your question:
Determine what you exactly want, what kind of uptime at what expense.
How should it be made available (
There are a couple of solutions probably.
First off, search pgfoundry for possibilities, look into clustering and
replication.
A little more insight would make it easier to answer your question:
Determine what you exactly want, what kind of uptime at what expense.
How should it be made available (
On 18 nov 2008, at 17.09, Pietro Tedesco
<[EMAIL PROTECTED]> wrote:
We have an instance of PostgreSQL on Windows 2003 with some
application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a so
We have an instance of PostgreSQL on Windows 2003 with some application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a solution with standby.
Is there a product of High Availability for PostgreSQL on
Thanks for the help guys,
I should clear up a little what I am trying to achieve I think.
The primary users of this db and application will be located in an
office, each user with a desktop machine, all networked. They need to
work with this DB in a fairly heavy kind of way, in so far as to say
t
Richard Huxton wrote:
[EMAIL PROTECTED] wrote:
I am looking now at a scenario that does not seem to be a native
ability of Postgres, but might possibly be overcome with Sequoia. I am
hoping that there exists the possibility of using Sequoia to replicate
a DB between / among a number of machine
[EMAIL PROTECTED] wrote:
Hi Guys,
I have been testing / working with Postgres for a work project, and so
far I am really impressed with this DB system. Takes a little getting
used to, but I am really beginning to love it.
Good to hear it Mr ...Umm... Frog.
I am looking now at a scenario that
Hi Guys,
I have been testing / working with Postgres for a work project, and so
far I am really impressed with this DB system. Takes a little getting
used to, but I am really beginning to love it.
I am looking now at a scenario that does not seem to be a native
ability of Postgres, but might poss
Although I rarely see it mentioned, Skype has some replication tools that
they opensourced.
https://developer.skype.com/SkypeGarage/DbProjects/SkyTools
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Simon Riggs wrote:
On Mon, 2007-06-04 at 10:21 -0400, Chander Ganesan wrote:
It's not too hard to put together a "warm standby" synchronous
replication mechanism with overhead that isn't too much more than what
you incur by enabling PITR... Such systems can also have very fast
failover on f
On Mon, 2007-06-04 at 10:21 -0400, Chander Ganesan wrote:
> It's not too hard to put together a "warm standby" synchronous
> replication mechanism with overhead that isn't too much more than what
> you incur by enabling PITR... Such systems can also have very fast
> failover on failure detection
On Mon, Jun 04, 2007 at 04:21:32PM +0200, Chander Ganesan wrote:
> I think you'll typically find that you can get one or the other -
> synchronous replication, or load balancing...but not both. On the other
Hi,
I am in very similar position, but I am more failover oriented. I am
considering us
Chander Ganesan wrote:
Madison Kelly wrote:
Hi all,
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
Can anyone point me to docs/websites that discuss options on
re
Madison Kelly wrote:
Hi all,
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
Can anyone point me to docs/websites that discuss options on
replicating in (as close a
On Sun, Jun 03, 2007 at 01:35:49PM -0400, Lew wrote:
> How much data do you put in the DB? Oracle has a free version, but it has
> size limits.
AFAIK, Oracle's free version doesn't include RAC, which is what would
be needed to satisfy the request anyway.
A
--
Andrew Sullivan | [EMAIL PROTECT
Lew wrote:
Madison Kelly wrote:
Being a quite small company, proprietary hardware and fancy software
licenses are not possible (ie: 'use oracle' won't help).
How much data do you put in the DB? Oracle has a free version, but it
has size limits.
(Ducking the slings and arrows of outraged
Madison Kelly wrote:
Being a quite small company, proprietary hardware and fancy software
licenses are not possible (ie: 'use oracle' won't help).
How much data do you put in the DB? Oracle has a free version, but it has
size limits.
(Ducking the slings and arrows of outraged PG fans: I p
Alexander Staubo wrote:
As a side-note, I sat up pgpool-II today, and was pleasantly surprised
about how easy it all was; within two minutes I had two databases in
perfect sync on my laptop. It has limitations (such as in its handling
of sequences), but compared to Slony it's like a breath of fre
Alexander Staubo wrote:
On 6/1/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
I remember being similarly disappointed in t
On 6/3/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
As a side-note, I sat up pgpool-II today, and was pleasantly surprised
about how easy it all was; within two minutes I had two databases in
perfect sync on my laptop. It has limitations (such as in its handling
of sequences), but compared to
On 6/3/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
> Slony is indeed intended for near-real-time replication; it's
> asynchronous, so slaves always lag behind the master. The amount of
> discrepancy depends on a bunch of factors -- individual node
> performance, network performance, and system l
On 6/1/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
I remember being similarly disappointed in this rampant co-opting of
Hi all,
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
Can anyone point me to docs/websites that discuss options on
replicating in (as close as possible to) realtim
Ivan Zolotukhin wrote:
Hello,
> Third idea:
> I install the Slony-I, linux-ha and postgresql on the same server of
> the two 2U servers. The web application access to the db server
> directly and without pgpool.
AFAIK, Slony does not have failover capabilities you need in HA solution:
http:/
> First idea:
> I install the pgpool on each web server (the web server farm include
> 16 web servers), and configure the pgpool as replication mode. The web
> application (written by php) access to the db server through the local
> pgpool daemon.
> The idea sounds a little unusual, dose it seems
Hello,
> Third idea:
> I install the Slony-I, linux-ha and postgresql on the same server of
> the two 2U servers. The web application access to the db server
> directly and without pgpool.
AFAIK, Slony does not have failover capabilities you need in HA solution:
http://gborg.postgresql.org/pr
> I hava a db server (mysql) in my web application, it include 550
> tables and about 10 rows in each table. Now, I want to change the
> db server to postgresql and construct a HA environment.
>
> I have two 2U servers to build postgresql server (one is master, the
> other is slave), and two 1
I hava a db server (mysql) in my web application, it include 550
tables and about 10 rows in each table. Now, I want to change the
db server to postgresql and construct a HA environment.
I have two 2U servers to build postgresql server (one is master, the
other is slave), and two 1U servers f
60 matches
Mail list logo
