pg_dump Error in Windows

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

pg_dump Error in Windows

soumik.bhattacharjee

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

RE: pg_dump Error in Windows

soumik.bhattacharjee

Same error with pg_dumpall it does not accept the postgres default password

 

 

C:\Program Files\PostgreSQL\9.6\bin>pg_dumpall > postgres

Password:

pg_dumpall: could not connect to database "template1": FATAL:  password authentication failed for user " testusr"

 

 

From: Bhattacharjee, Soumik
Sent: Thursday, March 21, 2019 11:16 AM
To: [hidden email]
Subject: pg_dump Error in Windows

 

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Shreeyansh dba
In reply to this post by soumik.bhattacharjee
Hi Soumik,

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

Are you trying to perform backup from remote server or local...?

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

RE: pg_dump Error in Windows

soumik.bhattacharjee

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Holger Jakobs-2

Hello all,

since the message is 'Ident authentication failed for user "testusr"', in pg_hba.conf the host/user/database combination must be configured to be identified by the ident protocol, which is very insecure.

Please change the entry to "md5" or whatever is appropriate. Or you set up an ident service on the client, which would help authenticating the testusr. Please bear in mind that it isn't secure.

Regards,

Holger

Am 21.03.19 um 12:53 schrieb [hidden email]:

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba [hidden email]
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik [hidden email]
Cc: Pgsql-admin [hidden email]
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

--

Holger Jakobs, Bergisch Gladbach
instant messaging: <a href="xmpp:holger@jakobs.com">xmpp:holger@...
<a href="tel:+491789759012">+49 178 9759012 oder <a href="tel:+492202817157">+49 2202 817157

Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Shreeyansh dba
In reply to this post by soumik.bhattacharjee
To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

RE: pg_dump Error in Windows

soumik.bhattacharjee

Below are the entries in pg_hba.conf  file.

 

I tried re-setting the postgres db user password, but it did not helped.

 

Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?

 

Thanks..

 

 

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Pepe TD Vo
Try to reconfig your script and use localhost not hostname and it work well.

I had an issue with this too and I found out the port works only for local host not registered with hostname.  SA tried to help me and still not work.  Since it's development server, I just let it be with localhost.

 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Thursday, March 21, 2019 8:19 AM, "[hidden email]" <[hidden email]> wrote:


Below are the entries in pg_hba.conf  file.
 
I tried re-setting the postgres db user password, but it did not helped.
 
Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?
 
Thanks..
 
 
 
From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows
 
To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
 
 
On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:
Hi Shreeyansh,
 
In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.
 
Thanks
Soumik
 
From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows
 
Hi Soumik,
 
Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.
 
Are you trying to perform backup from remote server or local...?

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
 
 
On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:
Hello All,
 
When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-
 
pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"
 
Is there any changes I need to do in pg_hba.conf file?
 
Please suggest a solution.
 
Thanks
Soumik
 
 


Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Shreeyansh dba
In reply to this post by soumik.bhattacharjee
It seems the the local level entry are missed in pg_hba.conf file your entry must like below...

# TYPE  DATABASE    USER     ADDRESS    METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32        md5
# IPv6 local connections:
host    all             all             ::1/128                md5

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Thu, Mar 21, 2019 at 5:49 PM <[hidden email]> wrote:

Below are the entries in pg_hba.conf  file.

 

I tried re-setting the postgres db user password, but it did not helped.

 

Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?

 

Thanks..

 

 

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik

 

 

Reply | Threaded
Open this post in threaded view
|

Re: pg_dump Error in Windows

Pepe TD Vo
I do have this entry on pg_hba.conf
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Thursday, March 21, 2019 8:39 AM, Shreeyansh Dba <[hidden email]> wrote:


It seems the the local level entry are missed in pg_hba.conf file your entry must like below...

# TYPE  DATABASE    USER     ADDRESS    METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             <a rel="nofollow" shape="rect" target="_blank" onclick="return window.theMainWindow.showLinkWarning(this)" href="http://127.0.0.1/32">127.0.0.1/32        md5
# IPv6 local connections:
host    all             all             ::1/128                md5

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Thu, Mar 21, 2019 at 5:49 PM <[hidden email]> wrote:
Below are the entries in pg_hba.conf  file.
 
I tried re-setting the postgres db user password, but it did not helped.
 
Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?
 
Thanks..
 
 
 
From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows
 
To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
 
 
On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:
Hi Shreeyansh,
 
In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.
 
Thanks
Soumik
 
From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows
 
Hi Soumik,
 
Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.
 
Are you trying to perform backup from remote server or local...?

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com
 
 
On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:
Hello All,
 
When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-
 
pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"
 
Is there any changes I need to do in pg_hba.conf file?
 
Please suggest a solution.
 
Thanks
Soumik
 
 


Reply | Threaded
Open this post in threaded view
|

RE: pg_dump Error in Windows

soumik.bhattacharjee

Ok, Thanks all, let me try and come back.

 

From: Pepe TD Vo <[hidden email]>
Sent: Thursday, March 21, 2019 1:59 PM
To: Shreeyansh Dba <[hidden email]>; Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

I do have this entry on pg_hba.conf

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:

 

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)


**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

 

On Thursday, March 21, 2019 8:39 AM, Shreeyansh Dba <[hidden email]> wrote:

 

It seems the the local level entry are missed in pg_hba.conf file your entry must like below...

 

# TYPE  DATABASE    USER     ADDRESS    METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32        md5
# IPv6 local connections:
host    all             all             ::1/128                md5


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 5:49 PM <[hidden email]> wrote:

Below are the entries in pg_hba.conf  file.

 

I tried re-setting the postgres db user password, but it did not helped.

 

Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?

 

Thanks..

 

 

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 5:23 PM <[hidden email]> wrote:

Hi Shreeyansh,

 

In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.

 

Thanks

Soumik

 

From: Shreeyansh Dba <[hidden email]>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <[hidden email]>
Cc: Pgsql-admin <[hidden email]>
Subject: Re: pg_dump Error in Windows

 

Hi Soumik,

 

Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.

 

Are you trying to perform backup from remote server or local...?


Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

On Thu, Mar 21, 2019 at 3:46 PM <[hidden email]> wrote:

Hello All,

 

When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-

 

pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL:  Ident authentication failed for user "testusr"

 

Is there any changes I need to do in pg_hba.conf file?

 

Please suggest a solution.

 

Thanks

Soumik