Thanks. This is what I have. May be it is not really an error?
2013-10-18 12:23:54.996 IST,,,8855,,523c23ea.2297,20,,2013-09-20 16:01:06 IST,,0,LOG,00000,"received SIGHUP, reloading configuration files",,,,,,,,,""
2013-10-18 12:23:54.996 IST,,,8855,,523c23ea.2297,21,,2013-09-20 16:01:06 IST,,0,LOG,55P02,"parameter ""superuser_reserved_connections"" cannot be changed without restarting the server",,,,,,,,,""
2013-10-18 12:23:54.997 IST,,,8855,,523c23ea.2297,22,,2013-09-20 16:01:06 IST,,0,LOG,F0000,"configuration file ""/pgdata/prod/data_93/postgresql.conf"" contains errors; unaffected changes were applied",,,,,,,,,""
2013-10-18 12:23:54.996 IST,,,8855,,523c23ea.2297,20,,2013-09-20 16:01:06 IST,,0,LOG,00000,"received SIGHUP, reloading configuration files",,,,,,,,,""
2013-10-18 12:23:54.996 IST,,,8855,,523c23ea.2297,21,,2013-09-20 16:01:06 IST,,0,LOG,55P02,"parameter ""superuser_reserved_connections"" cannot be changed without restarting the server",,,,,,,,,""
2013-10-18 12:23:54.997 IST,,,8855,,523c23ea.2297,22,,2013-09-20 16:01:06 IST,,0,LOG,F0000,"configuration file ""/pgdata/prod/data_93/postgresql.conf"" contains errors; unaffected changes were applied",,,,,,,,,""
On Fri, Oct 18, 2013 at 1:12 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Jayadevan M <maymala.jayadevan@xxxxxxxxx> writes:There should be log message(s) before that one complaining about the
> Which is the quickest way to troubleshot the message "
> LOG: configuration file "..../postgresql.conf" contains errors;
> unaffected changes were applied"" ?
specific problems.
regards, tom lane