| From: | Victor Rosenberg <victor(dot)rosenberg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Changing logging options for PostgreSQL service on windows |
| Date: | 2012-11-27 15:34:25 |
| Message-ID: | 7ea55cfb-23e9-4cf1-8374-d164d15d8654@googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all.
I need an alternative for running the following command:
"C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start
This way the server starts and logs to C:\yyy\log\pgsql.log.
When I try to register the server as a service though - no logging options are available and the server logs to Event Viewer.
From pg_ctl documentation:
pg_ctl register [-N servicename] [-U username] [-P password] [-D datadir] [-S a[uto] | d[emand] ] [-w] [-t seconds] [-s] [-o options]
How can I force the server to log into a file?
Note: I don't want to use one-click installer, I just want to work with unzipped binaries.
Thanks in advance
Victor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2012-11-27 23:25:40 | Re: Autovaccum failure with Postgres 8.3.14? (max-fsm_pages issue?) |
| Previous Message | Krawetzky, Peter J | 2012-11-27 14:39:36 | WAL Backup Error |