Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
"000101F60003" from archive
sc
On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote:
>
>> but it would be a good idea to set hot_standby_feedback to on and
>> max_standby_archive_delay to something larger than 30s
>
> Doesn't replica need a connection to master for hot_
On Tue, Oct 1, 2013 at 5:30 PM, akp geek wrote:
> I tried tunneling this morning and it did not work. when tried the tunneling
> command in the url you mentioned getting following error. I will try to find
> what exactly this mean , but any help is appreciated.
>
> command-line: line 0: Bad config
On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote:
> you don't need to use streaming replication for a hot standby, it
> works perfectly well even if you replay everything from archive and
> never do streaming.
Right, I mixed up a with the terms a bit.
> but it would be a good idea to set hot
On Tue, Oct 1, 2013 at 5:46 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 2:03 PM, akp geek wrote:
>> One more thing.. pardon me for being dumb
>>
>> I want to set the 2 nd slave as HOT STAND BY, not steaming ..
>
> Hot standby assumes being streaming. You can not establish a hot
> standb
thanks. I can try this. Any idea for the message below. Thanks for the
patience
I tried tunneling this morning and it did not work. when tried the
tunneling command in the url you mentioned getting following error. I will
try to find what exactly this mean , but any help is appreciated.
command-l
On Tue, Oct 1, 2013 at 2:03 PM, akp geek wrote:
> One more thing.. pardon me for being dumb
>
> I want to set the 2 nd slave as HOT STAND BY, not steaming ..
Hot standby assumes being streaming. You can not establish a hot
standby without using streaming replication. What is the reason not to
d
One more thing.. pardon me for being dumb
I want to set the 2 nd slave as HOT STAND BY, not steaming ..
What would be steps.
on the primary I will have the archive_command
on the slave in the recover.conf , restore_command.
After I make my slave as exactly as master, How can the slave gets
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel to the primary via tunnel. will give that a try
regards
On Mon, Sep 30, 2013 at 11:10 PM, Chris Travers wrote:
>
>
>
> On Mon, Sep 30, 2013 at 7:14 PM, akp geek wrote:
>
>> Hi all -
>>
>>
On Mon, Sep 30, 2013 at 7:14 PM, akp geek wrote:
> Hi all -
>
> Currently we have set up one master one slave , which working
> fine. Now we need to replicate to an other slave. The problem we have ,
> the port that we use on primary can not be reached from the new slave. We
> can't t
Hi all -
Currently we have set up one master one slave , which working
fine. Now we need to replicate to an other slave. The problem we have ,
the port that we use on primary can not be reached from the new slave. We
can't the change the primary port also, because many applications usi
Mageshwaran wrote:
Hi ,
Is there any way to do replication in postgres.. Please give me any
idea to do replication...
entering postgresql replication into google brings up:
www.commandprompt.com
www.greenplum.com (kind of different but sure)
And don't forget:
www.slony.info
And PITR.
La
Hi ,
Is there any way to do replication in postgres.. Please give me any idea
to do replication...
Regards
J Mageshwaran
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or e
dcrespo wrote:
Good question. The only concern that I have is the date of the last
version (2005-3-7).
You will find that their website has not been updated for a while. If
you look in pgfoundry you will find that they have releases as recent as
a few days ago.
The different 1.x versions rel
Look into heartbeat:
http://www.linux-ha.org/HeartbeatProgram
The idea is that you have a virtual address to be "the database", and that
the primary server configures itself for this address as well as whatever
address it would normally have. Then, when you want to switch servers
(maybe becau
Good question. The only concern that I have is the date of the last
version (2005-3-7).
Do you or anybody know if this software (PGCluster) is stable and works
fine? Please, give information on how it fits your needs.
Thank you!
Daniel
km wrote:
> On Tue, Jan 09, 2007 at 12:17:20PM -0600, Scott
Thank you, Ben, for your reply.
I have read the FAQ of DRBD, but I'm still wondering how an application
accessing a database server knows when to switch to the mirror (setting
this one as the master). I think I should have an application that
provides the connection transparently which determines
On Tue, Jan 09, 2007 at 12:17:20PM -0600, Scott Marlowe wrote:
> > Has anybody researched on this that can point me in the right
> > direction?
>
> You could use possibly use pgpool as long as its caveats aren't a show
> stopper (can't insert with random, individual inserts with things like
> now(
If you only want to use one database at a time you might look into using
DRBD. It's a linux block-level package that is like raid-1 over the
network.
On Tue, 9 Jan 2007, dcrespo wrote:
Hi everybody,
I have two computers with a Postgres Database each. I want one of them
to be the replica of t
On Tue, 2007-01-09 at 07:36, dcrespo wrote:
> Hi everybody,
>
> I have two computers with a Postgres Database each. I want one of them
> to be the replica of the other one; let's say I want a Master to Master
> replication in order to use either one (but only one at a time) as the
> main database:
Hi everybody,
I have two computers with a Postgres Database each. I want one of them
to be the replica of the other one; let's say I want a Master to Master
replication in order to use either one (but only one at a time) as the
main database: in case of failure, switch. The ideal synchronization
w
Hello,
a question about a tool or a possibility how could something work.
following situation:
we have a database which is full of very sensitive information and needed that db to use our online website.
but now we move the website to a server outside our office and needed to replicate only some da
After a long battle with technology, Matthias Blohm <[EMAIL PROTECTED]>, an earthling,
wrote:
> Hello,
> a question about a tool or a possibility how could something work.
>
> following situation:
> we have a database which is full of very sensitive information and needed that db to
> use our onl
hello,
i need help with online database replication.
is there any daemon, whitch can do that ?
right now i'm writting one based on triggers, but it will be great
if somebody has some link for something like that, witch is already made
.
i found erserver.com , but it's not complete right now and i
24 matches
Mail list logo
