Hi,
I have a few elaborating questions in regard to setting up Warm Standby.
1) The master keeps writing WAL files even though I'm quite sure nothing is
happening. This seems like a large waste of diskspace?
2) Sometimes my slave does not read and delete WAL files when in recovery mode.
This w
On 08/04/2010, at 18.36, Kevin Grittner wrote:
> Dennis Thrysøe wrote:
>
>> 1) The master keeps writing WAL files even though I'm quite sure
>> nothing is happening. This seems like a large waste of diskspace?
>
> What is your setting for archive_timeout? This l
Hi people,
I keep getting this message
"the database system is starting up" in the postgres log while system is
running in archive recovery mode (warm standby).
Stops when system enters production mode.
I have checked network traffic, but there is none for port 5432. So it must be
something
On 12/04/2010, at 14.58, Devrim GÜNDÜZ wrote:
> On Mon, 2010-04-12 at 14:04 +0200, Dennis Thrysøe wrote:
>> I know, but a log line each second becomes a lot if the system is like
>> this for weeks at a time...
>
> Definitely a client app which is trying to connect to the
On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrysøe wrote:
>
>> Are there any good tools or logging options for determining
>> who/what?
>
> Are you on a recent enough version to have log_connections and
> log_disconnections available? If s
http://geysirit.dk
+45 31 51 60 00
On 13/04/2010, at 15.44, Kevin Grittner wrote:
> Dennis Thrysøe wrote:
>
>> Yes, that tells me that connection attempts are from the local
>> host on incrementing port numbers for each attempt.
>
> Is the user your database superus