| View previous topic :: View next topic |
| Author |
Message |
klofsch
Joined: 07 Jan 2006
Posts: 2
|
| Posted: Sun Jan 08, 2006 9:56 am Post subject: PostGreSQL runs only on LOCALHOST |
|
|
Hello,
i want to make PostGre listen on my LAN-Ip but when i set the Ip or '*' the server dont start. Only wiht LOCALHOST it starts.
How can i solve this problem?
thanks
Peter |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 1538
|
| Posted: Sun Jan 08, 2006 3:42 pm Post subject: |
|
|
in order for it to listen on all interfaces you have to either use
Code: listen_addresses = '*'
or
Code: listen_addresses = '0.0.0.0'
listen_addresses = * or listen_addresses = 0.0.0.0 throws up a syntax error |
|
| Back to top |
|
klofsch
Joined: 07 Jan 2006
Posts: 2
|
| Posted: Sun Jan 08, 2006 5:06 pm Post subject: |
|
|
Thanks,..but this works only when i use the A2T-Web-Interface. When i edit directly the COnfiguration-file it doesnt work.
Thanks |
|
| Back to top |
|
Yosef
Joined: 03 Sep 2005
Posts: 9
Location: Brazil
|
| Posted: Fri Feb 03, 2006 5:44 pm Post subject: |
|
|
klofsch wrote: Thanks,..but this works only when i use the A2T-Web-Interface. When i edit directly the COnfiguration-file it doesnt work.
Thanks
Hi there,
Having the same problem. But also with MYSQL...
And trying the sugested solutions blocks PG and MYSQL from starting... (using A2T interface and/or manualy editing)...
Realy need to put DB servers online, not only localy!
Thanks in advance to any suggestions
Eneas |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 1538
|
| Posted: Wed Feb 08, 2006 11:10 am Post subject: |
|
|
| for mysql see http://apache2triad.net/forums/viewtopic.php?t=914 learn to search |
|
| Back to top |
|
| |