From: | James Hall <James(dot)Hall(at)RadioShack(dot)com> |
---|---|
To: | marie(dot)tuite(at)edisonaffiliates(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pg_dumpall problem |
Date: | 2002-10-16 20:22:38 |
Message-ID: | EE80A67DD80E304DA779C72BC9FA999673E573@ntmailo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)tuite(at)edisonaffiliates(dot)com]
Sent: Wednesday, October 16, 2002 3:17 PM
To: James Hall; pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of James Hall
> Sent: Wednesday, October 16, 2002 2:51 PM
> To: pgsql-general(at)postgresql(dot)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(at)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Wilson | 2002-10-16 20:30:37 | Re: accessing schemas |
Previous Message | Marie G. Tuite | 2002-10-16 20:16:33 | Re: Pg_dumpall problem |