On Saturday 27 March 2004 08:32 pm, [EMAIL PROTECTED] wrote: > 1. Where should the postgresql.conf file be to be recognized by the > service on startup? currently, it is inside my $PGDATA directory but > all of its contents are commented out.
It is a template. This is where the file should be located. > 2. I can't find any log files for postgres. Inside my /var/log/ > directory, there is an empty > file called pgsql. What do I have to do to get it to log errors, > etc. Is there a difference between normal logging and syslog logging? Please see the section on Logging (section 9) in README.rpm-dist, which is typically installed in /usr/share/doc/postgresql-version. For example, for version 7.4.2, that is /usr/share/doc/postgresql-7.4.2. The whole section is: +++++++++++++++++++++++++++++++++++ LOGGING SET UP ------------------------------------------------------------------------------- To get rollable syslog set up, see the documentation for the file postgresql.conf, by default in the directory /var/lib/pgsql/data, as relates to the syslog options. Then, add a line to /etc/syslog.conf, using the man page for syslog.conf as a source. Example: If postgresql.conf has the following lines for the syslog settings: syslog = 1 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' Then you need to add the line to /etc/syslog.conf: local0.* /var/log/postgresql Then set up an entry in /etc/logrotate.d to roll postgresql the way you want it rolled. +++++++++++++++++++++++++++++++ Now, substitute /var/log/pgsql or whatever for the above file (hmmm, I wrote that section of the README.rpm-dist, but I though I had changed it to be /var/log/pgsql....). There is other very useful information in README.rpm-dist; you really should read that file. -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
