"David Rovner" <DRovner@princetonservergroup.com> writes: > I see this error at the command prompt in root executing anything that > starts with "psql". The argument list does not matter. "psql" with no > arguments returns this error as well. PGOPTIONS environment variable, perhaps? It's hard to imagine why anyone would try to set listen_addresses that way, but ... $ PGOPTIONS='--listen_addresses=*' psql psql: FATAL: parameter "listen_addresses" cannot be changed after server start $ regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org

"David Rovner" <DRovner@princetonservergroup.com> writes: > PGOPTIONS is set to -i Well, that's equivalent to --listen_addresses=*, so that's your problem. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org