Re: log_collector & sysout on windows

From: Marc Brazeau <litespeedmarc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: log_collector & sysout on windows
Date: 2014-05-29 19:30:04
Message-ID: CAKuZ-AgTf87z1fvesbUNUs+P_CCHC7CbBvz1jqg=twa9uaqCpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think I figured this out after some playing around.

Looks like postgres only redirects stderr to its log files. Consistent
with what documentation says, and my findings playing around.

In my situation, I was looking for sysout of my python archiver to go to
postgres log files.

I added sys.stdout = sys.stderr at the start of entry python script, and
all was well after that.

On Wed, May 28, 2014 at 1:30 PM, Marc Brazeau <litespeedmarc(at)gmail(dot)com>wrote:

> So I'm sure I'm doing something wrong, or this is maybe a novice question,
>
> On My Mac, I set log_collector=on, archive_command='echo hello %p %f'
> And awesome, my postgres log files get the output from my archive command.
>
> On Windows, this does not work (Using postgres 9.3..4)
>
> Only way to get output from my archive_command, is with the -l option on
> pg_ctl start. But this has issues:
> - Not sure it will work with Services (thoughI haven't tried).
> - I don't get any of the log_rotation
> - And I lose context (from having sysouts along side other Postgres
> message).
>
> Surely there is a simple answer here?
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2014-05-29 19:36:53 Re: Postgresql 9.2.4 - timezone error
Previous Message Bruce Momjian 2014-05-29 19:16:42 Re: Is it typo in pg_stat_replication column name in PG 9.4 ?