[GENERAL] Question about concurrent synchronous and asynchronous commits

2011-01-11 Thread Dan Birken
I notice on the documentation page about Asynchronous Commit ( http://www.postgresql.org/docs/8.3/static/wal-async-commit.html*)*, it says the follow "The user can select the commit mode of each transaction, so that it is possible to have both synchronous and asynchronous commit transactions runnin

Re: [GENERAL] Question about concurrent synchronous and asynchronous commits

2011-01-13 Thread Dan Birken
I'm wrong. -Dan On Wed, Jan 12, 2011 at 12:32 PM, Vick Khera wrote: > On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken wrote: > > If I commit asynchronously and then follow that with > a synchronous commit, > > does that flush the asynchronous commit as well? > > I'

Re: [GENERAL] Understanding PG9.0 streaming replication feature

2011-01-26 Thread Dan Birken
(I am not the OP, but recently went through the same thing so I'll chime in) Reading through the documentation now (albeit with a now pretty good understanding of how everything works), I think the main confusing thing is how different bits which apply to file-base log shipping, streaming replicat

Re: [GENERAL] PostgreSQL 9.0 Streaming Replication Configuration

2011-02-08 Thread Dan Birken
If the standby server cannot pull the WAL file from the master using streaming replication, then it will attempt to pull it from the archive. If the WAL segment isn't archived (for example because you aren't using archiving), then your streaming replication is unrecoverable and you have to take a

[GENERAL] pg_receivexlog 9.2 client working with 9.1 server?

2013-05-24 Thread Dan Birken
I am running a pg_receivexlog 9.2 client against a 9.1 server. It seems to work. Comments in the code seem to indicate that this setup is workable. However, pg_receivexlog is not part of the 9.1 source tree nor the rpm package (as far as I see), so I am curious if there is some caveat that I sur

Re: [GENERAL] pg_receivexlog 9.2 client working with 9.1 server?

2013-06-25 Thread Dan Birken
Update: I have successfully used this configuration with a month's worth of WALs (tens of thousands), run a test restore, and everything appears to have worked as expected. So at least based on that test, this configuration seems fine. -Dan On Fri, May 24, 2013 at 4:42 PM, Dan Birken

Re: [GENERAL] pg_dump on Hot standby : clarification on how to

2011-05-13 Thread Dan Birken
What is your "max_standby_streaming_delay" set at? If your pg_dump takes longer than your "max_standby_streaming_delay" (which is likely since the default is 30s), you might get that error as well. This setting tells your standby how long it should wait to apply conflicting WAL files to finish a