Thread:
> -----Original Message----- > From: Mukund Pate [mailto:patemukund@yahoo.com] > Sent: 04 September 2002 08:31 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] > > > Hi, > i am trying to conversion of ms-access data to > postgresql so i use pgadmin tool to do this but i get > the error when i try to connect > > no entry found in pg_hba.conf 877.28.78.54 > username=postgres database=sample. > server ip address is - 877.28.78.50 Hi, First problem, that is not a valid IP address. > and i have installed the pgadmin on windows machine so > i am trying to convert my ms-access database to > postgresql on linux server. > > workstation ip address is - 877.28.78.54 > i have written the entry in the pg_hba.conf file like > this > host sample 877.28.78.50 255:255:0:0 postgres > or > host sample 877.28.78.50 255:255:0:0 postgres hello > or > host sample 877.28.78.50 255:255:0:0 trust Try: host dbname 877.28.78.54 255.255.255.255 trust Or host dbname 877.28.78.54 255.255.255.255 trust But with a valid IP address. Regards, Dave.
[Please keep replies on-list] > -----Original Message----- > From: Mukund Pate [mailto:patemukund@yahoo.com] > Sent: 04 September 2002 09:11 > To: Dave Page > Subject: RE: [pgadmin-support] > > > > hi sir, > its sample ip address i have mentioned. The IP address you mentioned was 877.28.78.54 which is *not* a valid addres because the first octet is greater than 254. > i registed the dll then i tried to connect to server. > but it gives the error. > is the port no 5432 correct?i have tried the postres > as a username and password but still it asking me to > enter the entry. > plz help what have to do? Have you set a password for postgres? Try using psql on the server to set one initially. Regards, Dave.
> -----Original Message----- > From: Mukund Pate [mailto:patemukund@yahoo.com] > Sent: 04 September 2002 10:05 > To: Dave Page > Subject: RE: [pgadmin-support] > > > > > > hi sir, > actuaaly client ipaddress is 123:56:3:23 and server > address is 123:56:3:20 the problem is notrelated to ip > address. > which address i have to mention in the server name and > > usr name,address. > the entry in pg_hba.conf file is as > host sample 123:56:3:23 255:255:0:0 trust > or > host sample 123:56:3:23 255:255:0:0 postgres password > or > host sample 123:56:3:23 255:255:0:0 trust > or > host all 123:56:3:23 255:255:0:0 trust > > i have mentioned the server ip address,postgres as a > user name and password,port 5432 but still it gives > the erro regarding the entry in file. > does any permission requires for the workstation to > access the database? Please keep replies on list. Don't use : in your IP addresses. They are not valid. Try: host all 123.56.3.23 255.255.0.0 trust Regards, Dave.