Pg_dumpall problem

Started by James Hallover 23 years ago5 messagesgeneral

Jump to latest

James Hall

James.Hall@RadioShack.com

over 23 years ago

[cross-posting to General due to no response from Novice list]

Hello,

I am trying to backup my database with pg_dumpall.

When I try to execute the dump command, I get the following result:
---
postgres@rspde data]$ pg_dumpall > 101602.out
Password: psql: Password authentication failed for user 'postgres'
Password: xxxx <------- I enter the password for
postgres user here
Password: psql: Password authentication failed for user 'postgres'
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: xxxx <-------- prompted again for
postgres password, password entered again
Connection to database '' failed.
fe_sendauth: no password supplied

pg_dump failed on , exiting
postgres@rspde data]$
---

My pg_hba.conf is pretty simple -
local all password
host all 0.0.0.0 0.0.0.0 password

Only other thing to note is I am connecting to the server with Postgres via
a Telnet connection.

Any help in figuring this problem out would be appreciated!

Thank you,
-jim

Marie G. Tuite

marie.tuite@edisonaffiliates.com

over 23 years ago

In reply to: James Hall (#1)

Re: Pg_dumpall problem

Authentication failed. Do you have a password set for postgres in
pg_shadow?

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 2:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Pg_dumpall problem

[cross-posting to General due to no response from Novice list]

Hello,

I am trying to backup my database with pg_dumpall.

When I try to execute the dump command, I get the following result:
---
postgres@rspde data]$ pg_dumpall > 101602.out
Password: psql: Password authentication failed for user 'postgres'
Password: xxxx <------- I enter the password for
postgres user here
Password: psql: Password authentication failed for user 'postgres'
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: xxxx <-------- prompted again for
postgres password, password entered again
Connection to database '' failed.
fe_sendauth: no password supplied

pg_dump failed on , exiting
postgres@rspde data]$
---

My pg_hba.conf is pretty simple -
local all password
host all 0.0.0.0 0.0.0.0 password

Only other thing to note is I am connecting to the server with
Postgres via
a Telnet connection.

Any help in figuring this problem out would be appreciated!

Thank you,
-jim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

James Hall

James.Hall@RadioShack.com

over 23 years ago

In reply to: Marie G. Tuite (#2)

Re: Pg_dumpall problem

Thank you for your reply.

Yes, a password is set for the postgres user in pg_shadow, and I am
confidant that I entered the correct password both times prompted.

-jim

-----Original Message-----
From: Marie G. Tuite [mailto:marie.tuite@edisonaffiliates.com]
Sent: Wednesday, October 16, 2002 3:17 PM
To: James Hall; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem

Authentication failed. Do you have a password set for postgres in
pg_shadow?

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 2:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Pg_dumpall problem

[cross-posting to General due to no response from Novice list]

Hello,

I am trying to backup my database with pg_dumpall.

When I try to execute the dump command, I get the following result:
---
postgres@rspde data]$ pg_dumpall > 101602.out
Password: psql: Password authentication failed for user 'postgres'
Password: xxxx <------- I enter the password for
postgres user here
Password: psql: Password authentication failed for user 'postgres'
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: xxxx <-------- prompted again for
postgres password, password entered again
Connection to database '' failed.
fe_sendauth: no password supplied

pg_dump failed on , exiting
postgres@rspde data]$
---

My pg_hba.conf is pretty simple -
local all password
host all 0.0.0.0 0.0.0.0 password

Only other thing to note is I am connecting to the server with
Postgres via
a Telnet connection.

Any help in figuring this problem out would be appreciated!

Thank you,
-jim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Import Notes

Resolved by subject fallback

Marie G. Tuite

marie.tuite@edisonaffiliates.com

over 23 years ago

In reply to: James Hall (#3)

Re: Pg_dumpall problem

You could try the following in your pg_hba.conf, remembering to sighup the
postmaster when you change the .conf file.

local all password
host all 127.0.0.1 255.255.255.255 password

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 3:23 PM
To: marie.tuite@edisonaffiliates.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem

Thank you for your reply.

Yes, a password is set for the postgres user in pg_shadow, and I am
confidant that I entered the correct password both times prompted.

-jim

-----Original Message-----
From: Marie G. Tuite [mailto:marie.tuite@edisonaffiliates.com]
Sent: Wednesday, October 16, 2002 3:17 PM
To: James Hall; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem

Authentication failed. Do you have a password set for postgres in
pg_shadow?

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 2:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Pg_dumpall problem

[cross-posting to General due to no response from Novice list]

Hello,

I am trying to backup my database with pg_dumpall.

When I try to execute the dump command, I get the following result:
---
postgres@rspde data]$ pg_dumpall > 101602.out
Password: psql: Password authentication failed for user 'postgres'
Password: xxxx <------- I enter the password for
postgres user here
Password: psql: Password authentication failed for user 'postgres'
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: xxxx <-------- prompted again for
postgres password, password entered again
Connection to database '' failed.
fe_sendauth: no password supplied

pg_dump failed on , exiting
postgres@rspde data]$
---

My pg_hba.conf is pretty simple -
local all password
host all 0.0.0.0 0.0.0.0 password

Only other thing to note is I am connecting to the server with
Postgres via
a Telnet connection.

Any help in figuring this problem out would be appreciated!

Thank you,
-jim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

James Hall

James.Hall@RadioShack.com

over 23 years ago

In reply to: Marie G. Tuite (#4)

Re: Pg_dumpall problem

Thanks for the suggestion, I tried it and had the same result.

I have also tried to use pg_dumpall locally on the server running Postgres,
and still receive the same error. Pg_dump works fine, but I cannot backup
users/passwords with just pg_dump.

Any other thoughts?

Thanks!
-jim

-----Original Message-----
From: Marie G. Tuite [mailto:marie.tuite@edisonaffiliates.com]
Sent: Wednesday, October 16, 2002 3:33 PM
To: James Hall; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Pg_dumpall problem

You could try the following in your pg_hba.conf, remembering to sighup the
postmaster when you change the .conf file.

local all password
host all 127.0.0.1 255.255.255.255 password

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 3:23 PM
To: marie.tuite@edisonaffiliates.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem

Thank you for your reply.

Yes, a password is set for the postgres user in pg_shadow, and I am
confidant that I entered the correct password both times prompted.

-jim

-----Original Message-----
From: Marie G. Tuite [mailto:marie.tuite@edisonaffiliates.com]
Sent: Wednesday, October 16, 2002 3:17 PM
To: James Hall; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_dumpall problem

Authentication failed. Do you have a password set for postgres in
pg_shadow?

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of James Hall
Sent: Wednesday, October 16, 2002 2:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Pg_dumpall problem

[cross-posting to General due to no response from Novice list]

Hello,

I am trying to backup my database with pg_dumpall.

When I try to execute the dump command, I get the following result:
---
postgres@rspde data]$ pg_dumpall > 101602.out
Password: psql: Password authentication failed for user 'postgres'
Password: xxxx <------- I enter the password for
postgres user here
Password: psql: Password authentication failed for user 'postgres'
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: psql: fe_sendauth: no password supplied
Password: xxxx <-------- prompted again for
postgres password, password entered again
Connection to database '' failed.
fe_sendauth: no password supplied

pg_dump failed on , exiting
postgres@rspde data]$
---

My pg_hba.conf is pretty simple -
local all password
host all 0.0.0.0 0.0.0.0 password

Only other thing to note is I am connecting to the server with
Postgres via
a Telnet connection.

Any help in figuring this problem out would be appreciated!

Thank you,
-jim

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Import Notes

Resolved by subject fallback