Re: [GENERAL] 8.0 Client can't connect to 7.3 server?
On Wed, Mar 08, 2006 at 03:03:22PM -0500, Louis Gonzales wrote: > Two things come to mind: > 1) do you have a defined postgresql user "joe" ? > 2) 192.168.1.11/32 (without looking it up, I'm not sure if you can > specify the subnetmask, as an alternative to the /DecimalNumber notation) > This is certainly only an issue with the entry in pg_hba.conf, on the > server to be contacted, just missing the correct configuration. > > Remember OS user "joe" != postgresql user "joe" > postgresql user "joe" must have been granted access to the database > instance you're attempting to connect to, then you can have an entry like: > > host all all 192.168.1.1/32 trust ( where postgresql user "joe" > would be implied ) > Thanks Louis! Problem was in pg_hba.conf as error message suggested ;) Servers are now in different subnets and my configuration was out of date. Sorry. -- -jussi -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---(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
Re: [GENERAL] 8.0 Client can't connect to 7.3 server?
Jussi Saarinen <[EMAIL PROTECTED]> writes: > I can't connect to server1 (7.3.4) using client (8.0.7) at server2. > I just get error: > psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe, > database template1 > Uncommented lines at server1's pg_hba.conf (postgresql service is > restarted after every change): > local all all trust trust > host all all 192.168.1.11 255.255.255.255 trust That error is not possible with this pg_hba.conf file. You're probably editing the wrong conf file, or possibly restarting the wrong server. regards, tom lane ---(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
Re: [GENERAL] 8.0 Client can't connect to 7.3 server?
Jussi Saarinen wrote: I have following environment: Server1, rh9, ip:192.168.1.10: postgresql-7.3.4-3.rhl9 postgresql-libs-7.3.4-3.rhl9 postgresql-server-7.3.4-3.rhl9 postgresql-jdbc-7.3.4-3.rhl9 Server2, fc4, ip:192.168.1.11: postgresql-libs-8.0.7-1.FC4.1 postgresql-8.0.7-1.FC4.1 postgresql-server-8.0.7-1.FC4.1 postgresql-jdbc-8.0.7-1.FC4.1 postgresql-contrib-8.0.7-1.FC4.1 I can't connect to server1 (7.3.4) using client (8.0.7) at server2. I just get error: psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe, database template1 Uncommented lines at server1's pg_hba.conf (postgresql service is restarted after every change): local all all trust trust host all all 192.168.1.11 255.255.255.255 trust Server1 also have line: tcpip_socket = true in postgresql.conf Any ideas what's wrong? Two things come to mind: 1) do you have a defined postgresql user "joe" ? 2) 192.168.1.11/32 (without looking it up, I'm not sure if you can specify the subnetmask, as an alternative to the /DecimalNumber notation) This is certainly only an issue with the entry in pg_hba.conf, on the server to be contacted, just missing the correct configuration. Remember OS user "joe" != postgresql user "joe" postgresql user "joe" must have been granted access to the database instance you're attempting to connect to, then you can have an entry like: host all all 192.168.1.1/32 trust ( where postgresql user "joe" would be implied ) begin:vcard fn:louis n:gonzales;louis email;internet:[EMAIL PROTECTED] tel;home:248.943.0144 tel;cell:248.943.0144 x-mozilla-html:TRUE version:2.1 end:vcard ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] 8.0 Client can't connect to 7.3 server?
I have following environment: Server1, rh9, ip:192.168.1.10: postgresql-7.3.4-3.rhl9 postgresql-libs-7.3.4-3.rhl9 postgresql-server-7.3.4-3.rhl9 postgresql-jdbc-7.3.4-3.rhl9 Server2, fc4, ip:192.168.1.11: postgresql-libs-8.0.7-1.FC4.1 postgresql-8.0.7-1.FC4.1 postgresql-server-8.0.7-1.FC4.1 postgresql-jdbc-8.0.7-1.FC4.1 postgresql-contrib-8.0.7-1.FC4.1 I can't connect to server1 (7.3.4) using client (8.0.7) at server2. I just get error: psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe, database template1 Uncommented lines at server1's pg_hba.conf (postgresql service is restarted after every change): local all all trust trust host all all 192.168.1.11 255.255.255.255 trust Server1 also have line: tcpip_socket = true in postgresql.conf Any ideas what's wrong? -- -jussi -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
