Thread: Pg_dumpall problem

Pg_dumpall problem

From
James Hall
Date:
[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

Re: Pg_dumpall problem

From
"Marie G. Tuite"
Date:
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
>



Re: Pg_dumpall problem

From
James Hall
Date:
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

Re: Pg_dumpall problem

From
"Marie G. Tuite"
Date:
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

> -----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
>



Re: Pg_dumpall problem

From
James Hall
Date:
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

> -----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
>