pg_dumpall backup script w. ftp ; pgpass file ; after upgrade to Ubuntu 10.4 (lucid) and Postgresql 9.0.2
<font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2"><div>After a year I have restarted work on a project using Postgresql. The database I created was in Postgresql 8.2.5. I updated my database server from Ubuntu 7.10 to 10.4 (lucid) and installed Postgresql 9.0.2 The Postgresql install went fine and the restore from my previous pg_dumpall went fine but I have an issue with the backup script.<br><br>I have made the pgpass file as root but I cannot get the backup script to run as root I must change to a postgresql/ubuntu user engineering and then the script runs. Previously the backup script ran from cron.daily . I need to know what I am not doing correctly for this to work. I do not have much scripting experience. <br><br>The error message is <br>root@claLinus:/# source /etc/cron.daily/postgresql-backup.sh<br>pg_dumpall: could not connect to database "template1": FATAL: Ident authentication failed for user "engineering"<br><br><br><br>I have confirmed that .pgpass exists <br><br>root@claLinus:/# locate .pgpass<br>/home/engineering/.pgpass<br>/home/mmg/.pgpass<br>/root/.pgpass<br><br><font><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">Below is my backup script and my instructions for creating the pgpass that came from this list several years ago<br><br></font></font>Thank you for any help.<br><div>Margaret <br><br><font><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***<br></font></font>#!/bin/bash<br>#file is /etc/cron.daily/postgresql-backup.sh<br>#store the file name into a variable<br>numdate=$(date +%F)-$(date +%k%M)owl.sql<br>#remove spaces from the file name<br>numdate=${numdate/ /}<br>#backup the database<br>pg_dumpall -U engineering --column-inserts --attribute-inserts > /tmp/$numdate<br># record in the log it was done<br>echo $(date) PID $$ backup completed >> /var/log/messages<br>#ftp the file<br>ftp -inv 192.168.100.29<<ENDFTP<br>user backupftp password<br>cd ./backupLinus/<br>lcd /tmp<br>put $numdate<br>bye<br>ENDFTP<br><br><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2"><font><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***<br>#instructions for making the .pgpass file<br><br>touch ~/.pgpass<br>chmod 0600 ~/.pgpass<br>echo '*:*:*:username:password' > ~/.pgpass<br>Note that this presumes you are logged in as the user who will be dumping the database(s).<br><br></font></font></font><br></div></div></font>"This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain company proprietary, privileged or confidential information. If you are not the intended recipient(s), please contact the sender by reply e-mail, advise them of the error and destroy this message and its attachments as well as any copies. The review, use or distribution of this message or its content by anyone other than the intended recipient or senior management of the company is strictly prohibited."<BR>
Import Notes
Reply to msg id not found:
On 01/21/11 11:07 AM, MargaretGillon@chromalloy.com wrote:
After a year I have restarted work on a project using Postgresql. The
database I created was in Postgresql 8.2.5. I updated my database
server from Ubuntu 7.10 to 10.4 (lucid) and installed Postgresql
9.0.2 The Postgresql install went fine and the restore from my
previous pg_dumpall went fine but I have an issue with the backup script.I have made the pgpass file as root but I cannot get the backup script
to run as root I must change to a postgresql/ubuntu user engineering
and then the script runs. Previously the backup script ran from
cron.daily . I need to know what I am not doing correctly for this to
work. I do not have much scripting experience.
...
FATAL: Ident authentication failed for user "engineering"
that says it right there. your LOCAL authentication type is set to
IDENT in your pg_hba.conf file.
see the documentation section on Client Authentication,
http://www.postgresql.org/docs/current/static/client-authentication.html
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><div>>> FATAL: Ident authentication failed for user "engineering"<br>><br>>that says it right there. your LOCAL authentication type is set to <br>>IDENT in your pg_hba.conf file.<br>><br><br>That was it. I have updated my install documentation. <br>Thank you, <br>Margaret </div></FONT>"This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain company proprietary, privileged or confidential information. If you are not the intended recipient(s), please contact the sender by reply e-mail, advise them of the error and destroy this message and its attachments as well as any copies. The review, use or distribution of this message or its content by anyone other than the intended recipient or senior management of the company is strictly prohibited."<BR>