top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Not able to connect the postgresql database? Getting error while connecting. ?

0 votes
322 views

Error Details:

Resolve "FATAL:no pg_hba.conf entry for host"

Anyone suggest how to solve this error?

posted Jul 30, 2018 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You need to add user IP address to the server. Basically in pg_hdb.conf file you need to add.

For Example:

host all all xx.xxx.xx.xx/xx md5

answer Jul 31, 2018 by Sandeep Bedi
Similar Questions
0 votes

Using PostgreSQL shell how to select the database and tables.

+3 votes

I am using rails 3.1 and ruby 1.9.3,Now i want to use uuid concept in rails 3 for existing data

so I did like :-

create_table :posts, :id => false do |t|
 t.string :uuid, :limit => 36, :primary => true
end

ActiveRecord::Base.class_eval do

# old rails versions
set_primary_key 'uuid'

before_create :generate_uuid
def generate_uuid
self.id = UUIDTools::UUID.random_create.to_s
end
end

This is working for new data,now i want to migrate existing data with relation.for uuid they are using datatype as string,in postgresql the data type used for primary_key and foreign key is integer ,so if i am trying to change foreign key integer to string it is throwing error. Can someone please tell me some example,how to do this.

0 votes

Hi,

I need to take the only schema from Postgresql. Can anyone suggest how to dumb or migrate the schema?

+1 vote

enter image description here

This pic is what i am geting error response from server(HTTP 406). Actually i am trying to post some content from CKeditor, but normal text with styles type of content is accepting by server when i add table content server not accepting.

...