pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump Error in Windows
11+ messages / 4 participants
[nested] [flat]
* pg_dump Error in Windows
@ 2019-03-21 10:15 soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2019-03-21 10:15 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
@ 2019-03-21 11:44 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 11+ messages in thread
From: Shreeyansh Dba @ 2019-03-21 11:44 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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
>
>
>
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-21 11:53 ` soumik.bhattacharjee@kpn.com
2019-03-21 11:59 ` Re: pg_dump Error in Windows Holger Jakobs <holger@jakobs.com>
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2019-03-21 11:53 UTC (permalink / raw)
To: shreeyansh2014@gmail.com; +Cc: pgsql-admin@lists.postgresql.org
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 <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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<http://www.shreeyansh.com;
On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
@ 2019-03-21 11:59 ` Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 11+ messages in thread
From: Holger Jakobs @ 2019-03-21 11:59 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 soumik.bhattacharjee@kpn.com:
>
> 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 <shreeyansh2014@gmail.com>
> *Sent:* Thursday, March 21, 2019 12:45 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> *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 <http://www.shreeyansh.com;
>
>
>
>
>
> On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@kpn.com
> <mailto:soumik.bhattacharjee@kpn.com>> 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: xmpp:holger@jakobs.com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
@ 2019-03-21 12:06 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
1 sibling, 1 reply; 11+ messages in thread
From: Shreeyansh Dba @ 2019-03-21 12:06 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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 <shreeyansh2014@gmail.com>
> *Sent:* Thursday, March 21, 2019 12:45 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> *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 <soumik.bhattacharjee@kpn.com> 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
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-21 12:19 ` soumik.bhattacharjee@kpn.com
2019-03-21 12:24 ` Re: pg_dump Error in Windows Pepe TD Vo <pepevo@yahoo.com>
2019-03-21 12:38 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 2 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2019-03-21 12:19 UTC (permalink / raw)
To: shreeyansh2014@gmail.com; +Cc: pgsql-admin@lists.postgresql.org
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..
[cid:image001.png@01D4DFE8.AE1DEAF0]
From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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<http://www.shreeyansh.com;
On Thu, Mar 21, 2019 at 5:23 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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 <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>>
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<http://www.shreeyansh.com;
On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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
Attachments:
image001.png (image/png, 25.1K) download
view image
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
@ 2019-03-21 12:24 ` Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 0 replies; 11+ messages in thread
From: Pepe TD Vo @ 2019-03-21 12:24 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; shreeyansh2014@gmail.com <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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, "soumik.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.com> wrote:
#yiv6584036234 #yiv6584036234 -- _filtered #yiv6584036234 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6584036234 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv6584036234 #yiv6584036234 p.yiv6584036234MsoNormal, #yiv6584036234 li.yiv6584036234MsoNormal, #yiv6584036234 div.yiv6584036234MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv6584036234 a:link, #yiv6584036234 span.yiv6584036234MsoHyperlink {color:blue;text-decoration:underline;}#yiv6584036234 a:visited, #yiv6584036234 span.yiv6584036234MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6584036234 p.yiv6584036234msonormal0, #yiv6584036234 li.yiv6584036234msonormal0, #yiv6584036234 div.yiv6584036234msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv6584036234 span.yiv6584036234EmailStyle18 {font-family:sans-serif;color:#1F497D;}#yiv6584036234 .yiv6584036234MsoChpDefault {font-family:sans-serif;} _filtered #yiv6584036234 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv6584036234 div.yiv6584036234WordSection1 {}#yiv6584036234 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 <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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 <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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
Attachments:
image001.png (image/png, 25.1K) download
view image
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
@ 2019-03-21 12:38 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:58 ` Re: pg_dump Error in Windows Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 11+ messages in thread
From: Shreeyansh Dba @ 2019-03-21 12:38 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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 <shreeyansh2014@gmail.com>
> *Sent:* Thursday, March 21, 2019 1:07 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> *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 <soumik.bhattacharjee@kpn.com> 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 <shreeyansh2014@gmail.com>
> *Sent:* Thursday, March 21, 2019 12:45 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> *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 <soumik.bhattacharjee@kpn.com> 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
>
>
>
>
>
>
Attachments:
image001.png (image/png, 25.1K) download
view image
* Re: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:38 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-21 12:58 ` Pepe TD Vo <pepevo@yahoo.com>
2019-03-21 13:02 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 11+ messages in thread
From: Pepe TD Vo @ 2019-03-21 12:58 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <shreeyansh2014@gmail.com> 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 <soumik.bhattacharjee@kpn.com> 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 <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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”. ThanksSoumik From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <soumik.bhattacharjee@kpn.com> 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. ThanksSoumik
Attachments:
image001.png (image/png, 25.1K) download
view image
* RE: pg_dump Error in Windows
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:06 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 12:38 ` Re: pg_dump Error in Windows Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:58 ` Re: pg_dump Error in Windows Pepe TD Vo <pepevo@yahoo.com>
@ 2019-03-21 13:02 ` soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2019-03-21 13:02 UTC (permalink / raw)
To: pepevo@yahoo.com; shreeyansh2014@gmail.com; +Cc: pgsql-admin@lists.postgresql.org
Ok, Thanks all, let me try and come back.
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: Thursday, March 21, 2019 1:59 PM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> 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<http://127.0.0.1/32; md5
# IPv6 local connections:
host all all ::1/128 md5
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com/;
On Thu, Mar 21, 2019 at 5:49 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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..
[cid:image001.png@01D4DFEE.C478F960]
From: Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>>
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<http://www.shreeyansh.com/;
On Thu, Mar 21, 2019 at 5:23 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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 <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>>
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<http://www.shreeyansh.com/;
On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> 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
Attachments:
image001.png (image/png, 25.1K) download
view image
* RE: pg_dump Error in Windows
@ 2019-03-21 10:50 soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 11+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2019-03-21 10:50 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2019-03-21 13:02 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-03-21 10:15 pg_dump Error in Windows soumik.bhattacharjee@kpn.com
2019-03-21 11:44 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 11:53 ` soumik.bhattacharjee@kpn.com
2019-03-21 11:59 ` Holger Jakobs <holger@jakobs.com>
2019-03-21 12:06 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:19 ` soumik.bhattacharjee@kpn.com
2019-03-21 12:24 ` Pepe TD Vo <pepevo@yahoo.com>
2019-03-21 12:38 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-21 12:58 ` Pepe TD Vo <pepevo@yahoo.com>
2019-03-21 13:02 ` soumik.bhattacharjee@kpn.com
2019-03-21 10:50 RE: pg_dump Error in Windows soumik.bhattacharjee@kpn.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox