Re: [ADMIN] Syntax in postgresql.conf

2007-05-28 Thread Johann Spies
On Mon, May 28, 2007 at 09:05:37PM +1000, Phillip Smith wrote: > I believe you would need it to be: > listen_addresses = '192.168.0.1,localhost' > > ie, Don't close the quotes between your CSV's Thanks Phillip. That did it. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Inf

Re: [ADMIN] Syntax in postgresql.conf

2007-05-28 Thread Phillip Smith
I believe you would need it to be: listen_addresses = '192.168.0.1,localhost' ie, Don't close the quotes between your CSV's On Mon, 2007-05-28 at 11:11 +0200, Johann Spies wrote: > listen_addresses = '192.168.0.1', 'localhost' > > I get > > $sudo /etc/init.d/postgresql-8.1 restart > * Res

[ADMIN] Syntax in postgresql.conf

2007-05-28 Thread Johann Spies
A comment in postgresql.conf on Debian says: " # comma-separated list of addresses; # defaults to 'localhost', '*' = all " But when I try listen_addresses = '192.168.0.1', 'localhost' I get $sudo /etc/init.d/postgresql-8.1 restart * Restarting PostgreSQL 8.1 databa