Link to home
Start Free TrialLog in
Avatar of Olukayode Oluwole
Olukayode OluwoleFlag for Canada

asked on

Whats the correct entry into pg_hba.conf file

Hi
I have just installed postgresql  on linux ubuntu server

I tried to modify  postgresql.conf  and pg_hba.conf

When i restarted the postgresql i got the error below

Invalid IP mask "md5" Name or service not known

The specification was

host  all    datatronx  128.0.0.0  md5



What is wrong with the spec above


Regards


Oluwole
Avatar of Jan Bacher
Jan Bacher
Flag of United States of America image

host  all    datatronx  128.0.0.0/24  md5
Avatar of Olukayode Oluwole

ASKER

Thanks
I have tried the entry above and got an error as below

User generated image
Note that the IP mentioned in the error has no relevance to my IP

The  error is from PgAdmin

It is strange completely

How do I resolve this problem

Oluwole
Post the contents of your pg_hba.conf
See it below

User generated image
Pls note that i tried  md5  before trust  and got the same result
I still don't see a netmask after 128.0.0.0
what should the netmask line be like

Thanks
The link above did not take me to a new page

It keeps returning me to this same page

I have tried 255.255.255.0  as the subnet and still got the same result

My info is from the attached doc

User generated image
Am i doing something wrong

Oluwole
The link took you to my comment above where I gave an example of a netmask.

How many hosts in the 128.0.0.0 network do you wish to allow?  Starting with what IP?  Ending with what IP?
Hi

I want an arrangement where i can have a maximum of  20 clients on 1 host

and as many host as the given IP will allow

My server IP is 46.101.17.29

What and how many entries will have to be in my pg_hba.conf file

Thanks

Oluwole



Oluwole
ASKER CERTIFIED SOLUTION
Avatar of Jan Bacher
Jan Bacher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
good effort