[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 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 but still it is giving error. so plz help me what i have to do? what address i have to give in server name,username and password and port number.? plz reply as early as possible. mukund __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-support]
> -Original Message- > From: Mukund Pate [mailto:[EMAIL PROTECTED]] > Sent: 04 September 2002 08:31 > To: [EMAIL PROTECTED] > 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. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support]
[Please keep replies on-list] > -Original Message- > From: Mukund Pate [mailto:[EMAIL PROTECTED]] > 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. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support]
> -Original Message- > From: Mukund Pate [mailto:[EMAIL PROTECTED]] > 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. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-support]
hello, i am getting the error when i tried to connect the server with postgres as a user. the error -attribute datlastsysoid not found plz help sending the log file __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com pgAdmin II_-507555.Log Description: pgAdmin II_-507555.Log ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-support] unsubscribe
unsubscribe
[pgadmin-support] unsubscribe
unsubscribe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
