From: | "David Rovner" <DRovner(at)princetonservergroup(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start |
Date: | 2007-10-10 15:13:58 |
Message-ID: | F543E86A0B415E41806A68AA76E3C7F401A0FE9D@mailman.teve.inc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, October 10, 2007 10:57 AM
> To: David Rovner
> Cc: Steve Crawford; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] persistent 'psql: FATAL: "listen_addresses"
cannot be
> changed after server start
>
> "David Rovner" <DRovner(at)princetonservergroup(dot)com> writes:
> > PGOPTIONS is set to -i
>
> Well, that's equivalent to --listen_addresses=*, so that's your
problem.
>
> regards, tom lane
Yes. Found it. My .bash_profile had PGOPTIONS set to -i. Some leftover
debug before I started using the "service postgresql start" methods.
There had been a 2 month gap since I've been on the box with that
change.
Thanks for all your help!
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2007-10-10 16:37:18 | Using rsync for base backups for PITR |
Previous Message | Decibel! | 2007-10-10 15:09:16 | Re: warm/hot backup of Postgresql |