Edit postgresql.conf and set a listen_addresses that's not just localhost. Then edit pg_hba.conf and add permissions based on the soruce address of the connection. There are sections in the manual that will explain the details of what you have to put there.
//Magnus > -----Original Message----- > From: Josef Springer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 19, 2006 12:18 PM > To: Magnus Hagander > Cc: [email protected] > Subject: Re: [ADMIN] Where is the msi-setup described ? > > Hi Magnus, > > thanks for quick answer. I have installed PostgreSQL 8.1 on the > server without the option Accept connections on all addreses, not > just localhost . I want to connect from a client. How can this > option be switched on without a new installation of the server ? > > Josef > > Magnus Hagander wrote: > > > Hi folks, > > > where do i get documentation about the msi-setup > dialogs for > Windows plaforms ? > > > http://pginstaller.projects.postgresql.org > > //Magnus > > > ---------------------------(end of broadcast)---------------- > ----------- > TIP 9: In versions below 8.0, the planner will ignore your > desire to > choose an index scan if your joining column's > datatypes do not > match > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
