Re: >>>>> pg_dump in crontab

Hi Mike,

That's right .... thanks.

Another problem :-(
In my computer "pg_dump"; "psql" and "destroydb" are
located in
/usr/ local/pgsql/bin

$ crontab -l
35 23 * * * /usr/local/pgsl/bin/destroydb test

An error message occured
/usr/local/pgsql/bin/destroydb: psql: command not
found destroydb: database destroy failed on test.

Could you fix it?

T.I.A.
Iwan

--- Mike Miller <temp6453(at)hotmail(dot)com> wrote:
> 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> wroteF
> > $ 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

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/