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