Ygthkb

Consequences of lack of rigour

Play Zip, Zap, Zop

When can a QA tester start his job?

What's a good word to describe a public place that looks like it wouldn't be rough?

Slow While Loop, Query Improvment Assistance

How do you funnel food off a cutting board?

How can I get my players to come to the game session after agreeing to a date?

Does every functor from Set to Set preserve products?

Can you tell from a blurry photo if focus was too close or too far?

Why do neural networks need so many training examples to perform?

Should I reinstall Linux when changing the laptop's CPU?

SET NOCOUNT Error in handling SQL call after upgrade

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

A Missing Symbol for This Logo

What are the exceptions to Natural Selection?

Why avoid shared user accounts?

Is using an 'empty' metaphor considered bad style?

Removing disk while game is suspended

How much mayhem could I cause as a sentient fish?

Use two 8s and two 3s to make the number 24

What sets the resolution of an analog resistive sensor?

Why is Agricola named as such?

How would an AI self awareness kill switch work?

How should I handle players who ignore the session zero agreement?

psql: FATAL: password authentication failed for user “postgres”

Howto disable Postgres listening on TCP?Authentification failure for PostgreSQL server (9.3)Connect to PgAdmin III via localhostPostgresql tries to connect to fe80::1, permission deniedPostgreSQL 9.4 - Allow access from PHPSQLAlchemy connection error with Postgrespsql: FATAL: password authentication failed for user “GuardDog_02”Postgres ignoring wal_level setting in confCan `listen_addresses` system configuration setting in Postgres stop pre-authentication exploits?psql: FATAL: role “postgres” does not exist

0

I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to look as follow, (based on various documentation I have read so far:

local all all password

# IPv4 local connections:

host all all 127.0.0.1/32 password

# IPv6 local connections:

host all all ::1/128 ident

The only problem is that after this configuration even the defaul user #postgreshas completly lost access, when i try to log in as the root user with psql and and enter my computer's root user's passwordthis is this is what is what happens:

-bash-4.2$ psql
Password:
psql: FATAL: password authentication failed for user "postgres"
but when i change the above configuration on the pg_hba.conf file to:

peer

ident

ident

i can log in as root however phpPgAdmin won't let me in witouth a password. It's been 48 hours of headach. Your help is very much appricicated.

postgresql redhat centos-7 phppgadmin

share|improve this question

asked Sep 18 '18 at 0:25

christian xchristian x

816

add a comment | 

0

I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to look as follow, (based on various documentation I have read so far:

local all all password

# IPv4 local connections:

host all all 127.0.0.1/32 password

# IPv6 local connections:

host all all ::1/128 ident

The only problem is that after this configuration even the defaul user #postgreshas completly lost access, when i try to log in as the root user with psql and and enter my computer's root user's passwordthis is this is what is what happens:

-bash-4.2$ psql
Password:
psql: FATAL: password authentication failed for user "postgres"
but when i change the above configuration on the pg_hba.conf file to:

peer

ident

ident

i can log in as root however phpPgAdmin won't let me in witouth a password. It's been 48 hours of headach. Your help is very much appricicated.

postgresql redhat centos-7 phppgadmin

share|improve this question

asked Sep 18 '18 at 0:25

christian xchristian x

816

add a comment | 

I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to look as follow, (based on various documentation I have read so far:

local all all password

# IPv4 local connections:

host all all 127.0.0.1/32 password

# IPv6 local connections:

host all all ::1/128 ident

The only problem is that after this configuration even the defaul user #postgreshas completly lost access, when i try to log in as the root user with psql and and enter my computer's root user's passwordthis is this is what is what happens:

-bash-4.2$ psql
Password:
psql: FATAL: password authentication failed for user "postgres"
but when i change the above configuration on the pg_hba.conf file to:

peer

ident

ident

i can log in as root however phpPgAdmin won't let me in witouth a password. It's been 48 hours of headach. Your help is very much appricicated.

postgresql redhat centos-7 phppgadmin

share|improve this question

asked Sep 18 '18 at 0:25

christian xchristian x

816

share|improve this question

asked Sep 18 '18 at 0:25

christian xchristian x

816

share|improve this question

asked Sep 18 '18 at 0:25

christian xchristian x

816

asked Sep 18 '18 at 0:25

christian xchristian x

816

asked Sep 18 '18 at 0:25

christian xchristian x

816

2 Answers
2

active

oldest

votes

0

I was in same situation. after installation on window machine I was getting below error:

C:Usersxxxxx>psql -U postgres



psql: FATAL:  password authentication failed for user "postgres"

password retrieved from file "C:UsersxxxxxAppDataRoaming/postgresql/pgpass

.conf"

To fix the above, I edited 'pgpass.conf' file with password I was using for the 'postgres' database, and it worked.

share|improve this answer

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

add a comment | 

0

This error can provide from the fact that you installed actively another version of Postgres or passively within a system update (and you may not be aware in this case).

The consequence is that you try to connect to the current version of database that has changed (since install or update) and having in fact a port number that has changed. Therefore you may need to check this port number :

isogladiator@edubuntu:~$ sudo /etc/init.d/postgresql status

9.3/main (port **5432**): online

9.5/main (port **5434**): online

11/main (port **5433**): online

You may be using standard port 5432 while it has become 5433 for example.

share|improve this answer

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f217854%2fpsql-fatal-password-authentication-failed-for-user-postgres%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I was in same situation. after installation on window machine I was getting below error:

C:Usersxxxxx>psql -U postgres



psql: FATAL:  password authentication failed for user "postgres"

password retrieved from file "C:UsersxxxxxAppDataRoaming/postgresql/pgpass

.conf"

To fix the above, I edited 'pgpass.conf' file with password I was using for the 'postgres' database, and it worked.

share|improve this answer

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

add a comment | 

0

I was in same situation. after installation on window machine I was getting below error:

C:Usersxxxxx>psql -U postgres



psql: FATAL:  password authentication failed for user "postgres"

password retrieved from file "C:UsersxxxxxAppDataRoaming/postgresql/pgpass

.conf"

To fix the above, I edited 'pgpass.conf' file with password I was using for the 'postgres' database, and it worked.

share|improve this answer

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

add a comment | 

I was in same situation. after installation on window machine I was getting below error:

C:Usersxxxxx>psql -U postgres



psql: FATAL:  password authentication failed for user "postgres"

password retrieved from file "C:UsersxxxxxAppDataRoaming/postgresql/pgpass

.conf"

To fix the above, I edited 'pgpass.conf' file with password I was using for the 'postgres' database, and it worked.

share|improve this answer

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

C:Usersxxxxx>psql -U postgres



psql: FATAL:  password authentication failed for user "postgres"

password retrieved from file "C:UsersxxxxxAppDataRoaming/postgresql/pgpass

.conf"

share|improve this answer

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

edited Oct 6 '18 at 22:06

peterh

1,02841429

edited Oct 6 '18 at 22:06

peterh

1,02841429

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

answered Oct 6 '18 at 10:20

Bhupinder YadavBhupinder Yadav

11

0

This error can provide from the fact that you installed actively another version of Postgres or passively within a system update (and you may not be aware in this case).

The consequence is that you try to connect to the current version of database that has changed (since install or update) and having in fact a port number that has changed. Therefore you may need to check this port number :

isogladiator@edubuntu:~$ sudo /etc/init.d/postgresql status

9.3/main (port **5432**): online

9.5/main (port **5434**): online

11/main (port **5433**): online

You may be using standard port 5432 while it has become 5433 for example.

share|improve this answer

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

This error can provide from the fact that you installed actively another version of Postgres or passively within a system update (and you may not be aware in this case).

The consequence is that you try to connect to the current version of database that has changed (since install or update) and having in fact a port number that has changed. Therefore you may need to check this port number :

isogladiator@edubuntu:~$ sudo /etc/init.d/postgresql status

9.3/main (port **5432**): online

9.5/main (port **5434**): online

11/main (port **5433**): online

You may be using standard port 5432 while it has become 5433 for example.

share|improve this answer

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

This error can provide from the fact that you installed actively another version of Postgres or passively within a system update (and you may not be aware in this case).

The consequence is that you try to connect to the current version of database that has changed (since install or update) and having in fact a port number that has changed. Therefore you may need to check this port number :

isogladiator@edubuntu:~$ sudo /etc/init.d/postgresql status

9.3/main (port **5432**): online

9.5/main (port **5434**): online

11/main (port **5433**): online

You may be using standard port 5432 while it has become 5433 for example.

share|improve this answer

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

isogladiator@edubuntu:~$ sudo /etc/init.d/postgresql status

9.3/main (port **5432**): online

9.5/main (port **5434**): online

11/main (port **5433**): online

share|improve this answer

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1

New contributor

Rabah LEKHEBASSENE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 13 mins ago

Rabah LEKHEBASSENERabah LEKHEBASSENE

1