Apache2Triad Help, Support and Development Forum Index Apache2Triad Help, Support and Development
The apache2triad help , support and development forums
 

PostGreSQL runs only on LOCALHOST
Click here to go to the original topic

 
       Apache2Triad Help, Support and Development Forum Index -> Databases
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  
 
       Apache2Triad Help, Support and Development Forum Index -> Databases
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.13 © 2001, 2002 phpBB Group