Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 PostGreSQL runs only on LOCALHOST
Google
Post new topic Reply to topic
Author Message
klofsch
 
 


Joined: 07 Jan 2006
Posts: 2

PostPosted: Sun Jan 08, 2006 9:56 am Reply with quoteBack to top

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
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Sun Jan 08, 2006 3:42 pm Reply with quoteBack to top

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
View user's profileSend private message
klofsch
 
 


Joined: 07 Jan 2006
Posts: 2

PostPosted: Sun Jan 08, 2006 5:06 pm Reply with quoteBack to top

Thanks,..but this works only when i use the A2T-Web-Interface. When i edit directly the COnfiguration-file it doesnt work.

Thanks
View user's profileSend private message
Yosef
 
 


Joined: 03 Sep 2005
Posts: 9
Location: Brazil

PostPosted: Fri Feb 03, 2006 5:44 pm Reply with quoteBack to top

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
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Wed Feb 08, 2006 11:10 am Reply with quoteBack to top

for mysql see http://apache2triad.net/forums/viewtopic.php?t=914 learn to search
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT