Otdfbt

What is this 4-propeller plane?

Geography at the pixel level

I looked up a future colleague on LinkedIn before I started a job. I told my colleague about it and he seemed surprised. Should I apologize?

Are USB sockets on wall outlets live all the time, even when the switch is off?

What does "sndry explns" mean in one of the Hitchhiker's guide books?

Inline version of a function returns different value than non-inline version

What does "rabbited" mean/imply in this sentence?

Output the Arecibo Message

The difference between dialogue marks

Protecting Dualbooting Windows from dangerous code (like rm -rf)

Limit the amount of RAM Mathematica may access?

Where does the "burst of radiance" from Holy Weapon originate?

Why can Shazam do this?

How are circuits which use complex ICs normally simulated?

How to answer pointed "are you quitting" questioning when I don't want them to suspect

JSON.serialize: is it possible to suppress null values of a map?

Does a dangling wire really electrocute me if I'm standing in water?

How can I fix this gap between bookcases I made?

Can the Protection from Evil and Good spell be used on the caster?

Access elements in std::string where positon of string is greater than its size

Monty Hall variation

What is the use of option -o in the useradd command?

Extreme, unacceptable situation and I can't attend work tomorrow morning

Why is the maximum length of OpenWrt’s root password 8 characters?

Facing authentication error on postgres 9.2 -> dblink functions

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows:

SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
password=test')

ERROR: could not establish connection DETAIL: FATAL: password
authentication failed for user "NETWORK SERVICE"

What this error is related to? Do I need to modify pg_hba.conf file by any
chance?

postgresql

share|improve this question

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Perhaps you could tell us what operating system you're using, and what type of authentication you've configured?
  
  – voretaq7
  Feb 6 '13 at 17:06
  

  
  
  
  

add a comment | 

0

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows:

SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
password=test')

ERROR: could not establish connection DETAIL: FATAL: password
authentication failed for user "NETWORK SERVICE"

What this error is related to? Do I need to modify pg_hba.conf file by any
chance?

postgresql

share|improve this question

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Perhaps you could tell us what operating system you're using, and what type of authentication you've configured?
  
  – voretaq7
  Feb 6 '13 at 17:06
  

  
  
  
  

add a comment | 

I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows:

SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
password=test')

ERROR: could not establish connection DETAIL: FATAL: password
authentication failed for user "NETWORK SERVICE"

What this error is related to? Do I need to modify pg_hba.conf file by any
chance?

postgresql

share|improve this question

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

share|improve this question

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

share|improve this question

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

edited Feb 6 '13 at 11:49

Khaled

31.4k65487

asked Feb 6 '13 at 11:25

NeuronNeuron

1

asked Feb 6 '13 at 11:25

NeuronNeuron

1

1 Answer
1

active

oldest

votes

0

You need to specify the user parameter in the connect string, for example:

SELECT dblink_connect('host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test')

otherwise it's taken from the user account's name and obviously it's not suitable in your case.

share|improve this answer

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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%2fserverfault.com%2fquestions%2f475997%2ffacing-authentication-error-on-postgres-9-2-dblink-functions%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You need to specify the user parameter in the connect string, for example:

SELECT dblink_connect('host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test')

otherwise it's taken from the user account's name and obviously it's not suitable in your case.

share|improve this answer

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

add a comment | 

0

You need to specify the user parameter in the connect string, for example:

SELECT dblink_connect('host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test')

otherwise it's taken from the user account's name and obviously it's not suitable in your case.

share|improve this answer

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

add a comment | 

You need to specify the user parameter in the connect string, for example:

SELECT dblink_connect('host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test')

otherwise it's taken from the user account's name and obviously it's not suitable in your case.

share|improve this answer

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

SELECT dblink_connect('host=127.0.0.1 port=5432 dbname=postgres user=postgres password=test')

share|improve this answer

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813

answered Feb 6 '13 at 18:17

Daniel VéritéDaniel Vérité

1,671813