Re: >>>>> pg_dump in crontab

thats assuming linux (gotta mention that)
--
Mike

"Mike Miller" <temp6453(at)hotmail(dot)com> wrote in message
news:9434st$kp0$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> echo "/usr/local/pgsql/lib" >> /etc/ld.so.conf
> ldconfig -v
>
> [note >> means APPEND]
>
> That should fix it
> --
> Mike
>
>
> "Iwan Tutuka Pambudi" <itpambudi(at)yahoo(dot)com> wrote in message
> news:20010117033047(dot)8997(dot)qmail(at)web219(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> >
> > Hi,
> >
> > I need to back up my database "test" at 23:30
> > everyday.
> >
> > $ crontab -l
> > 30 23 * * * pg_dump test > test.out
> >
> > I got an error massage
> > /bin/sh: pg_dump: command not found
> >
> > $ which pg_dump
> > /usr/local/pgsql/bin/pg_dump
> > $ crontab(at)-l
> > 30 23 * * * /usr/local/pgsql/bin/pg_dump test >
> > /home/iwan/test.out
> >
> > I got another error message
> > /usr/local/pgsql/bin/pgdump: error in loading shared
> > libraries: libpq.so.2.0: cannot open shared object
> > file: No such file or directory
> >
> > But in my machine libpq.so.2.0 located in
> > /usr/local/src/postgresql-6.5.2/src/interface/libpq/libpq.so.2.0
> > /usr/local/pgsql/lib/libpq.so.2.0
> >
> > What's wrong? Please help me ...
> >
> >
> > Thanks in advance
> > Iwan
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
>
>