Rob Richardson <RDRichardson@xxxxxxxxxxx> writes: > I've get several processes running that use the same database. My database log file is filled with these: > 2014-04-09 14:16:45 EDT WARNING: invalid value for parameter "search_path": "public, operationsplanning, cooling_stands" > 2014-04-09 14:16:45 EDT DETAIL: schema "cooling_stands" does not exist > I would like to have more information in the file about this, such as > the source process or the statement that is throwing this warning. Since there's not a statement there already, I'd imagine this is coming from connection-time processing of values installed by ALTER USER SET or ALTER DATABASE SET. A look into the relevant system catalogs should find the bogus setting. Or you could turn on log_connections to get some info about what's making the connection that throws the warning. (I'd suggest adding %p to your log_line_prefix so you can definitively connect this message with the connection log one ...) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
