Sfdwhf

Text adventure game code

Horror movie/show or scene where a horse creature opens its mouth really wide and devours a man in a stables

Why does standard notation not preserve intervals (visually)

What makes a siege story/plot interesting?

Anatomically Correct Strange Women In Ponds Distributing Swords

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

Why do professional authors make "consistency" mistakes? And how to avoid them?

How do I go from 300 unfinished/half written blog posts, to published posts?

Apart from "berlinern", do any other German dialects have a corresponding verb?

What happens if you roll doubles 3 times then land on "Go to jail?"

% symbol leads to superlong (forever?) compilations

When airplanes disconnect from a tanker during air to air refueling, why do they bank so sharply to the right?

Why did we only see the N-1 starfighters in one film?

What is the difference between "behavior" and "behaviour"?

How long to clear the 'suck zone' of a turbofan after start is initiated?

Whats the best way to handle refactoring a big file?

Grabbing quick drinks

Is a stroke of luck acceptable after a series of unfavorable events?

Implement the Thanos sorting algorithm

Should I tutor a student who I know has cheated on their homework?

How to count occurrences of text in a file?

Unreliable Magic - Is it worth it?

Describing a person. What needs to be mentioned?

Why here is plural "We went to the movies last night."

Postgres pg_hba.conf Configuration

0

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a

db.session.commit()

I get this as an error:

OperationalError: (OperationalError) fe_sendauth: no password supplied None None

After playing around with the pg_hba.config file I still get the same error. The respective file is currently as follows:

# Database administrative login by Unix domain socket

local   all             postgres                                peer

local   all             alex                                    trust



# TYPE  DATABASE        USER            ADDRESS                 METHOD



# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                peer

#host    replication     postgres        127.0.0.1/32            md5

#host    replication     postgres        ::1/128                 md5

Would somebody be so kind as to help me with the right configuration for this file running on Ubuntu 14.04?

python postgresql intellij

share|improve this question

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a

db.session.commit()

I get this as an error:

OperationalError: (OperationalError) fe_sendauth: no password supplied None None

After playing around with the pg_hba.config file I still get the same error. The respective file is currently as follows:

# Database administrative login by Unix domain socket

local   all             postgres                                peer

local   all             alex                                    trust



# TYPE  DATABASE        USER            ADDRESS                 METHOD



# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                peer

#host    replication     postgres        127.0.0.1/32            md5

#host    replication     postgres        ::1/128                 md5

Would somebody be so kind as to help me with the right configuration for this file running on Ubuntu 14.04?

python postgresql intellij

share|improve this question

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a

db.session.commit()

I get this as an error:

OperationalError: (OperationalError) fe_sendauth: no password supplied None None

After playing around with the pg_hba.config file I still get the same error. The respective file is currently as follows:

# Database administrative login by Unix domain socket

local   all             postgres                                peer

local   all             alex                                    trust



# TYPE  DATABASE        USER            ADDRESS                 METHOD



# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                peer

#host    replication     postgres        127.0.0.1/32            md5

#host    replication     postgres        ::1/128                 md5

Would somebody be so kind as to help me with the right configuration for this file running on Ubuntu 14.04?

python postgresql intellij

share|improve this question

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

db.session.commit()

OperationalError: (OperationalError) fe_sendauth: no password supplied None None

# Database administrative login by Unix domain socket

local   all             postgres                                peer

local   all             alex                                    trust



# TYPE  DATABASE        USER            ADDRESS                 METHOD



# "local" is for Unix domain socket connections only

local   all             all                                     trust

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

# IPv6 local connections:

host    all             all             ::1/128                 trust

# Allow replication connections from localhost, by a user with the

# replication privilege.

#local   replication     postgres                                peer

#host    replication     postgres        127.0.0.1/32            md5

#host    replication     postgres        ::1/128                 md5

share|improve this question

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

share|improve this question

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

asked Jan 26 '16 at 20:05

Alex PlouffAlex Plouff

112

1 Answer
1

active

oldest

votes

0

Pretty nice walk-through.....
https://help.ubuntu.com/community/PostgreSQL

First find the file pg_hba.config. Usually found here:

 /etc/postgresql/9.3/main/pg_hba.conf

OR

 /etc/postgresql/[VERSION]/main/pg_hba.conf

Find this commented-out line:

# Database administrative login by Unix domain socket

And Underneath Change '???' to md5:

local   all             postgres               probably 'peer'

To:

local   all             postgres                                md5

This is because Ubuntu uses md5 with postgres instead of peer authentication

Then run this command:

sudo /etc/init.d/postgresql reload

share|improve this answer

edited Jan 26 '16 at 20:51

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f725985%2fpostgres-pg-hba-conf-configuration%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Pretty nice walk-through.....
https://help.ubuntu.com/community/PostgreSQL

First find the file pg_hba.config. Usually found here:

 /etc/postgresql/9.3/main/pg_hba.conf

OR

 /etc/postgresql/[VERSION]/main/pg_hba.conf

Find this commented-out line:

# Database administrative login by Unix domain socket

And Underneath Change '???' to md5:

local   all             postgres               probably 'peer'

To:

local   all             postgres                                md5

This is because Ubuntu uses md5 with postgres instead of peer authentication

Then run this command:

sudo /etc/init.d/postgresql reload

share|improve this answer

edited Jan 26 '16 at 20:51

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

add a comment | 

0

Pretty nice walk-through.....
https://help.ubuntu.com/community/PostgreSQL

First find the file pg_hba.config. Usually found here:

 /etc/postgresql/9.3/main/pg_hba.conf

OR

 /etc/postgresql/[VERSION]/main/pg_hba.conf

Find this commented-out line:

# Database administrative login by Unix domain socket

And Underneath Change '???' to md5:

local   all             postgres               probably 'peer'

To:

local   all             postgres                                md5

This is because Ubuntu uses md5 with postgres instead of peer authentication

Then run this command:

sudo /etc/init.d/postgresql reload

share|improve this answer

edited Jan 26 '16 at 20:51

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

add a comment | 

Pretty nice walk-through.....
https://help.ubuntu.com/community/PostgreSQL

First find the file pg_hba.config. Usually found here:

 /etc/postgresql/9.3/main/pg_hba.conf

OR

 /etc/postgresql/[VERSION]/main/pg_hba.conf

Find this commented-out line:

# Database administrative login by Unix domain socket

And Underneath Change '???' to md5:

local   all             postgres               probably 'peer'

To:

local   all             postgres                                md5

This is because Ubuntu uses md5 with postgres instead of peer authentication

Then run this command:

sudo /etc/init.d/postgresql reload

share|improve this answer

edited Jan 26 '16 at 20:51

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

 /etc/postgresql/9.3/main/pg_hba.conf

 /etc/postgresql/[VERSION]/main/pg_hba.conf

# Database administrative login by Unix domain socket

local   all             postgres               probably 'peer'

local   all             postgres                                md5

sudo /etc/init.d/postgresql reload

share|improve this answer

edited Jan 26 '16 at 20:51

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112

answered Jan 26 '16 at 20:26

Alex PlouffAlex Plouff

112