I tried with full paths: su -l postgres -c "/bin/gunzip -c /backup/rms.gz | /usr/lib/postgresql/8.2/bin/psql rms" su -l postgres -c "/bin/gunzip -c /backup/rms.gz | /usr/bin/psql rms"
su -l postgres -c "/bin/zcat /backup/rms.gz | /usr/lib/postgresql/8.2/bin/psql rms" su -l postgres -c "/bin/zcat /backup/rms.gz | /usr/bin/psql rms" same result when it running trough cronjob. Manually everything is fine. Even I put this commands (without su -l ...) in postgres user crontab, but same result. Server is ubuntu 64bit. Does it makes any difference from 32bit in terms of crontab functionality? Thanks, David Phillip Smith wrote: >> su -l postgres -c "gunzip -c /backup/rms.gz | psql rms" >> > > You could also try: > /bin/zcat /backup/rms.gz | /usr/local/postgres/bin/psql rms > > > THINK BEFORE YOU PRINT - Save paper if you don't really need to print this > > *******************Confidentiality and Privilege Notice******************* > > The material contained in this message is privileged and confidential to > the addressee. If you are not the addressee indicated in this message or > responsible for delivery of the message to such person, you may not copy > or deliver this message to anyone, and you should destroy it and kindly > notify the sender by reply email. > > Information in this message that does not relate to the official business > of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. > Weatherbeeta, its employees, contractors or associates shall not be liable > for direct, indirect or consequential loss arising from transmission of this > message or any attachments > e-mail. > > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
