Re: Synch Replication

Hi,

Thanks for the response.
I tried with the your sources and found the same issue.

I explain the steps that I followed, just to avoid any gaps in
understanding.
1) I assumes that the patch was already applied in your sources. So did
went ahead doing "configure", "make" and "make install"
2) Built pg_standby and copied manually to postgres bin directory
3) Copied the test_sync_repl.sh in postgres directory
4) Run the script. Refer "startup.log". Also verified the walsender and
walreceiver processes are running. Refer "ps.log".

Tests done:
1) Execute "psql -l". Refer "list_database.log"
2) Login to standby with command "psql -d replication" and execute SQL
"select * from pg_roles;". This worked fine.
3) Login to primary with command "psql -d postgres" and execute SQL
"create table temp1 (int int);". On execution of this query the standby
instance came down. Refer "createTable.log" (printed on console)

One of the hacker suggested to remove the "echo "host all all 0.0.0.0/0
trust" >> ${SBYDATA}/pg_hba.conf" for standby database only. But here
too the result was same.

Environment that I use:
- RHEL 4.7
- Both Primary & standby in the same machine

Could you please help. If you need any more symptoms, I can re-work.

Thanks,
Niranjan

> -----Original Message-----
> From: ext Fujii Masao [mailto:masao(dot)fujii(at)gmail(dot)com]
> Sent: Wednesday, February 04, 2009 7:05 AM
> To: K, Niranjan (NSN - IN/Bangalore)
> Cc: PostgreSQL-development
> Subject: Re: Synch Replication
>
> Hi,
>
> Ooops, my mail client has sent the previous message, on the
> way. Sorry.
>
> On Wed, Feb 4, 2009 at 10:24 AM, Fujii Masao
> <masao(dot)fujii(at)gmail(dot)com> wrote:
> > Hi,
> >
> > Thanks for your testing and report!
> >
> > On Tue, Feb 3, 2009 at 8:18 PM, K, Niranjan (NSN - IN/Bangalore)
> > <niranjan(dot)k(at)nsn(dot)com> wrote:
> >> Hi,
> >>
> >> I tried using the Synchronous replication and I'am unable to
> >> replicate the queries (Ex. create table temp1(int int);).
> >>
> >> I have downloaded the latest postgres dev snapshot and the latest
> >> sync replication patch from wiki.
> >>
> >> I have attached the log file which has the trace
> statements displayed
> >> on the console. I actually changed the
> 'test_synch_rep.sh', so that
> >> the standby database will put detailed trace messages.
> >>
> >> I'am actaully getting error related to history file.
> >>
> >> Could you please help regarding this.
>
> The problem which you pointed out was not reproduced on my machine.
> I suspect that the base HEAD version might be different between us.
> I uploaded my pgsql source with synch rep patch (v0128), so
> please try it.
>
> http://senduit.com/e5a942
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source
> Software Center
>