Hi. To access postgres set pg_hba.conf like this: host all all 0.0.0.0 0.0.0.0 md5 This will allow any user from any IP to connect. nd: «md5» sets the authentication mode, check the PG documentation for alternative methods (if you need them). Cheers, Andrea On Tue, 2006-09-19 at 13:00 +0200, Josef Springer wrote: > Hi Magnus, > > i must explain my users how to maintain. > The menu opens the dialog pgAdminIII - Backend Access Configuration > Editor with 6 colomns: > Type > > Database > > User > > IP-Address > > Method > > Option > > host > > all > > all > > 127.0.0.1/32 > > md5 > > > > host > > all > > all > > ::1/128 > > md5 > > > > > Is all required option set ? If no, what is required to access from > any client ? > > Josef > > Magnus Hagander wrote: > > 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:Josef.Springer@xxxxxxxxx] > > > Sent: Tuesday, September 19, 2006 12:18 PM > > > To: Magnus Hagander > > > Cc: > > > 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://pginst > > > aller.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 > > > > -- Andrea Gozzi <andrea.gozzi@xxxxxxxxxxxxxxxxxx>
Attachment:
signature.asc
Description: This is a digitally signed message part
