Thread: can't add connection to server in windowsXP using pgadminIII
i changed the postgresql.conf file adding listen_address = '*' but it doesn't kick. also changd the pg_hba.conf file adding "host template1 postgres 192.168.0.0/24 md5" but to no avail. inasmuch as there was no data folder in the postgres file i created the data folder and placed in them the "posgresql.conf" and "pg_hba.conf" files. i used the postgresql-8.0.0-rc2 windows installer package for the pgadminIII. here are my settings in the New server dialog box under properties tab Address: 192.168.0.1 Description: win32 Service: Port 5432 SSL InitialDB Template1 Username postgres needpassword: unchecked password: after clicking ok the result is an error has occured: error connecting to the server: could not connect to the server: No route host(0x00002751/10065). Is the server running on host "192.168.0.1" and accepting tctp/ip connections on port5432? tsk. tsk. tsk. thanks for any help. mon __________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250
If this information is all correct, anybody should be able to connect. I can't either. Is this host your web server, a local machine or ? Try hitting the help button on the new server dialog. Also, I'm not sure what it means, but I'm using PSE1 for description because that is what shows in the help. one other issue, are you sure that a firewall isn't getting in the way? Ray ----- Original Message ----- From: "Ramon Orticio" <rporticio@yahoo.com> To: <pgsql-novice@postgresql.org> Sent: Monday, January 17, 2005 7:16 PM Subject: [NOVICE] can't add connection to server in windowsXP using pgadminIII >i changed the postgresql.conf file adding > listen_address = '*' but it doesn't kick. also changd > the pg_hba.conf file adding "host template1 postgres > 192.168.0.0/24 md5" but to no avail. > > inasmuch as there was no data folder in the postgres > file i created the data folder and placed in them the > "posgresql.conf" and "pg_hba.conf" files. > > i used the postgresql-8.0.0-rc2 windows installer > package for the pgadminIII. > > here are my settings in the New server dialog box > under properties tab > > Address: 192.168.0.1 > Description: win32 > Service: > Port 5432 SSL > InitialDB Template1 > Username postgres > needpassword: unchecked > password: > > after clicking ok the result is > > an error has occured: > > error connecting to the server: could not connect to > the server: No route host(0x00002751/10065). Is the > server running on host "192.168.0.1" and accepting > tctp/ip connections on port5432? > > tsk. tsk. tsk. thanks for any help. > > mon > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - Easier than ever with enhanced search. Learn more. > http://info.mail.yahoo.com/mail_250 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005 > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005
Ramon Orticio wrote: >i changed the postgresql.conf file adding >listen_address = '*' but it doesn't kick. also changd >the pg_hba.conf file adding "host template1 postgres >192.168.0.0/24 md5" but to no avail. > >inasmuch as there was no data folder in the postgres >file i created the data folder and placed in them the >"posgresql.conf" and "pg_hba.conf" files. > >i used the postgresql-8.0.0-rc2 windows installer >package for the pgadminIII. > >here are my settings in the New server dialog box >under properties tab > >Address: 192.168.0.1 >Description: win32 >Service: >Port 5432 SSL >InitialDB Template1 >Username postgres >needpassword: unchecked >password: > >after clicking ok the result is > >an error has occured: > >error connecting to the server: could not connect to >the server: No route host(0x00002751/10065). Is the >server running on host "192.168.0.1" and accepting >tctp/ip connections on port5432? > >tsk. tsk. tsk. thanks for any help. > >mon > > Ramon, I'm still a novice myself but I did notice one thing in your post. You said "there was no data folder". If I understand correctly that should have been created by the initdb command. Did you run said command? -- Kind Regards, Keith
I think that is important to check if windows firewall or any other firewall software isn't blocking connections to postgres in the machine where postgres is installed and in the client machine too. ;-) This is simple, but I'm forget this on some ocasions and after hours trying ... well... disabling firewall they become to work Ramon Orticio escreveu: >i changed the postgresql.conf file adding >listen_address = '*' but it doesn't kick. also changd >the pg_hba.conf file adding "host template1 postgres >192.168.0.0/24 md5" but to no avail. > >inasmuch as there was no data folder in the postgres >file i created the data folder and placed in them the >"posgresql.conf" and "pg_hba.conf" files. > >i used the postgresql-8.0.0-rc2 windows installer >package for the pgadminIII. > >here are my settings in the New server dialog box >under properties tab > >Address: 192.168.0.1 >Description: win32 >Service: >Port 5432 SSL >InitialDB Template1 >Username postgres >needpassword: unchecked >password: > >after clicking ok the result is > >an error has occured: > >error connecting to the server: could not connect to >the server: No route host(0x00002751/10065). Is the >server running on host "192.168.0.1" and accepting >tctp/ip connections on port5432? > >tsk. tsk. tsk. thanks for any help. > >mon > > > > > >__________________________________ >Do you Yahoo!? >Yahoo! Mail - Easier than ever with enhanced search. Learn more. >http://info.mail.yahoo.com/mail_250 > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > > >