Обсуждение: Making connections to postgres under FreeBSD
Hi, Quick question. I'm very familiar with setting postgresql up under linux. I recently installed it on a FreeBSD box, and I'm having trouble making TCP/IP connections to it. I have set it to allow those connections under the postgresql.conf file, and it's listening on the proper port. When I try to connect with PG admin from remotely it says there is no entry for my IP address in pg_hba.conf. The problem with this is that there IS an entry for my IP. I'm using the canned BSD install of postgres 7.4 I'm sure this is just silly. Below is my pg_hba.conf Thanks, Stephen Sill II P.S. Greatbridge was the best! ____________________________________________________________________________ ________________________ # Authentication" for a complete description. A short synopsis # follows. # # This file controls: which hosts are allowed to connect, how clients # are authenticated, which PostgreSQL user names they can use, which # databases they can access. Records take one of three forms: # # local DATABASE USER METHOD [OPTION] # host DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] # hostssl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] # # (The uppercase quantities should be replaced by actual values.) # DATABASE can be "all", "sameuser", "samegroup", a database name (or # a comma-separated list thereof), or a file name prefixed with "@". # USER can be "all", an actual user name or a group name prefixed with # "+" or a list containing either. IP-ADDRESS and IP-MASK specify the # set of hosts the record matches. METHOD can be "trust", "reject", # "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam". Note # that "password" uses clear-text passwords; "md5" is preferred for # encrypted passwords. OPTION is the ident map or the name of the PAM # service. # # This file is read on server startup and when the postmaster receives # a SIGHUP signal. If you edit the file on a running system, you have # to SIGHUP the postmaster for the changes to take effect, or use # "pg_ctl reload". # Put your actual configuration here # ---------------------------------- # # CAUTION: The default configuration allows any local user to connect # using any PostgreSQL user name, including the superuser, over either # Unix-domain sockets or TCP/IP. If you are on a multiple-user # machine, the default configuration is probably too liberal for you. # Change it to use something other than "trust" authentication. # # If you want to allow non-local connections, you need to add more # "host" records. Also, remember TCP/IP connections are only enabled # if you enable "tcpip_socket" in postgresql.conf. # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all MYIPADDRESS 255.255.255.255 trust host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff trust
Sill-II, Stephen schrieb: >Hi, > >Quick question. I'm very familiar with setting postgresql up under linux. >I recently installed it on a FreeBSD box, and I'm having trouble making >TCP/IP connections to it. I have set it to allow those connections under >the postgresql.conf file, and it's listening on the proper port. When I try >to connect with PG admin from remotely it says there is no entry for my IP >address in pg_hba.conf. The problem with this is that there IS an entry for >my IP. > Did you start postmaster with -i option? Oliver -- VECERNIK Datenerfassungssysteme A-2560 Hernstein, Hofkogelgasse 17 Tel.: +43 2633 47530, Fax: DW 50 http://members.aon.at/vecernik
I went back to 7.3.1 and everything is fine. I did start it with -i so it was listening. thanks for your help though. Steve -----Original Message----- From: Oliver Vecernik [mailto:vecernik@aon.at] Sent: Thursday, January 30, 2003 4:28 PM To: Sill-II, Stephen Cc: Pgsql-Admin (E-mail) Subject: Re: [ADMIN] Making connections to postgres under FreeBSD Sill-II, Stephen schrieb: >Hi, > >Quick question. I'm very familiar with setting postgresql up under linux. >I recently installed it on a FreeBSD box, and I'm having trouble making >TCP/IP connections to it. I have set it to allow those connections under >the postgresql.conf file, and it's listening on the proper port. When I try >to connect with PG admin from remotely it says there is no entry for my IP >address in pg_hba.conf. The problem with this is that there IS an entry for >my IP. > Did you start postmaster with -i option? Oliver -- VECERNIK Datenerfassungssysteme A-2560 Hernstein, Hofkogelgasse 17 Tel.: +43 2633 47530, Fax: DW 50 http://members.aon.at/vecernik ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
Are you connecting on the "localhost" ???? -- I saw no entry in your pg_hba.conf for localhost... Also -- Was postgres STARTED with -i or did you just change the pgoptions file and NOT restart your postgres server or reload the options file ??? pg_ctl RELOAD... ""Sill-II, Stephen"" <Stephen.Sill-II@ost.dot.gov> wrote in message news:4BAE87828F06EB45B2641B83D370350F45AD@ostex002.ad.ost.dot.gov... > Hi, > > Quick question. I'm very familiar with setting postgresql up under linux. > I recently installed it on a FreeBSD box, and I'm having trouble making > TCP/IP connections to it. I have set it to allow those connections under > the postgresql.conf file, and it's listening on the proper port. When I try > to connect with PG admin from remotely it says there is no entry for my IP > address in pg_hba.conf. The problem with this is that there IS an entry for > my IP. > > I'm using the canned BSD install of postgres 7.4 > > I'm sure this is just silly. > > Below is my pg_hba.conf > > > Thanks, > > Stephen Sill II > > > P.S. Greatbridge was the best! > ____________________________________________________________________________ > ________________________ > > # Authentication" for a complete description. A short synopsis > # follows. > # > # This file controls: which hosts are allowed to connect, how clients > # are authenticated, which PostgreSQL user names they can use, which > # databases they can access. Records take one of three forms: > # > # local DATABASE USER METHOD [OPTION] > # host DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] > # hostssl DATABASE USER IP-ADDRESS IP-MASK METHOD [OPTION] > # > # (The uppercase quantities should be replaced by actual values.) > # DATABASE can be "all", "sameuser", "samegroup", a database name (or > # a comma-separated list thereof), or a file name prefixed with "@". > # USER can be "all", an actual user name or a group name prefixed with > # "+" or a list containing either. IP-ADDRESS and IP-MASK specify the > # set of hosts the record matches. METHOD can be "trust", "reject", > # "md5", "crypt", "password", "krb4", "krb5", "ident", or "pam". Note > # that "password" uses clear-text passwords; "md5" is preferred for > # encrypted passwords. OPTION is the ident map or the name of the PAM > # service. > # > # This file is read on server startup and when the postmaster receives > # a SIGHUP signal. If you edit the file on a running system, you have > # to SIGHUP the postmaster for the changes to take effect, or use > # "pg_ctl reload". > > # Put your actual configuration here > # ---------------------------------- > # > # CAUTION: The default configuration allows any local user to connect > # using any PostgreSQL user name, including the superuser, over either > # Unix-domain sockets or TCP/IP. If you are on a multiple-user > # machine, the default configuration is probably too liberal for you. > # Change it to use something other than "trust" authentication. > # > # If you want to allow non-local connections, you need to add more > # "host" records. Also, remember TCP/IP connections are only enabled > # if you enable "tcpip_socket" in postgresql.conf. > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > local all all > trust > host all all 127.0.0.1 255.255.255.255 > trust > host all all MYIPADDRESS 255.255.255.255 > trust > host all all ::1 > ffff:ffff:ffff:ffff:ffff:ffff trust > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html