Re: Log messages of the server?
"Magnus Hagander" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
> Hi, > > just a quick question: I've installed test-drives of the > PostgreSQL 8.0 beta installers (all versions, up to and > including beta4), on win2k, XP Pro and XP home, they all > worked fine starting the postmaster as service under user > postgres. I just realized, though, that I had a problem > upgrading one machine from beta2 to beta3, though. The > service didn't start, because an initdb was required. But I > didn't see any eventlog messages (that's where a windows user > would look first, naturally). After more careful scrutiny, I > did not find > *ANY* server log messages. Where does the installer set > logging to? Is logging to eventlog even implemented? How to > configure it? There has been a debate about where to log, and the end result was not to default to eventlog. You can enable eventlogging by editing postgresql.conf, look for the parameter "log_destination". Log files by default go into the pg_log subdirectory of the data directory. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings