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-line: line 0: Bad configuration option: ExitOnForwardFailure command-line: line 0: Bad configuration option: ExitOnForwardFailure Regards On Tue, Oct 1, 2013 at 6:46 PM, Sergey Konoplev <gray...@gmail.com> wrote: > On Tue, Oct 1, 2013 at 2:03 PM, akp geek <akpg...@gmail.com> 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 > do it streaming? > > BTW, you will find the SSH tunnel instructions here > http://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup > > -- > Kind regards, > Sergey Konoplev > PostgreSQL Consultant and DBA > > http://www.linkedin.com/in/grayhemp > +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 > gray...@gmail.com >