Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue

This issue stays resolved !!!

The statements are no more hanging on production now :)

The suspected problem was -

Our brand new production server did not have the port 5432 open.

I had opened the port using "iptables" command and everything started
working.

synchronous replication is fast and awesome.

Thanks
VB

On Fri, Feb 3, 2012 at 9:45 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On Thursday, February 02, 2012 10:21:28 pm Venkat Balaji wrote:
>
> >
> > Connection is working fine between primary and standby, ping is working
> > fine and wal archive file transfer is working without any issues.
> >
> > I tried CREATE TABLE and CREATE DATABASE, both were hanging.
> >
> > Apart from regular streaming replication settings, I did the following on
> > primary to enable synchronous replication -
> >
> > synchronous_standby_names='*'
> >
> > Commands started hanging after that. Is there anything else i need to do.
>
> From here:
>
> http://www.postgresql.org/docs/9.1/interactive/runtime-config-replication.html
>
> "
> synchronous_standby_names (string)
> ... The synchronous standby will be the first standby named in this list
> that is
> both currently connected and streaming data in real-time (as shown by a
> state of
> streaming in the pg_stat_replication view). Other standby servers appearing
> later in this list represent potential synchronous standbys....
>
> The name of a standby server for this purpose is the application_name
> setting of
> the standby, as set in the primary_conninfo of the standby's walreceiver.
> There
> is no mechanism to enforce uniqueness. In case of duplicates one of the
> matching
> standbys will be chosen to be the synchronous standby, though exactly
> which one
> is indeterminate. The special entry * matches any application_name,
> including
> the default application name of walreceiver.
>
> "
>
> So I would check the pg_stat_replication view to see if Postgres is seeing
> the
> standby as streaming.
>
>
> >
> > Thanks
> > VB
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>