Re: [ADMIN] postgres 9.0 - unable to bind to localhost.

2012-12-23 Thread Strahinja Kustudić
Sorry for a late reply, but I had the exact same problem and it was a bug in the Red Hat RPM package upgrade script of the sudo package. This basically means the user running Postgres cannot resolve hostname localhost. Have you tried logging in as the user running Postgres and trying to resolve loc

Re: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf

2012-12-23 Thread Kevin Grittner
Kong Man wrote: > The postgresql.conf file has always been using the default value, which is > 'warning'. Maybe it's not using the postgresql.conf file you think it is. Does this show the file you've been looking at?: SHOW config_file; -Kevin -- Sent via pgsql-admin mailing list (pgsql-admi

[ADMIN] Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf

2012-12-23 Thread Walter Hurry
On Sun, 23 Dec 2012 11:08:32 -0500, Kevin Grittner wrote: > Kong Man wrote: > >> The postgresql.conf file has always been using the default value, which >> is 'warning'. > > Maybe it's not using the postgresql.conf file you think it is. Does this > show the file you've been looking at?: > > SHO

Re: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf

2012-12-23 Thread Tom Lane
Kong Man writes: > We ran into a production issue during our maintenance window when I switched > over LifeKeeper/PostgreSQL nodes from one to another. We noticed that the > database was 1000 times slower than it usually is, then realized that the > log_min_messages setting was set to 'debug5'

Re: [ADMIN] log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf

2012-12-23 Thread Kong Man
Hi Tom, Thank you for some clue in this. So, I assume changing log_destination (from syslog to stderr) was a way around it to override log_min_messages when the -d option is specified? I am checking with the vender, SIOS, on what scenarios LifeKeeper would start up PostgreSQL with the -d5 op