From: | "Mike Miller" <temp6453(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: >>>>> pg_dump in crontab |
Date: | 2001-01-17 03:52:06 |
Message-ID: | 9434st$kp0$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-17 03:53:04 | Re: pg_log |
Previous Message | Alfred Perlstein | 2001-01-17 03:43:42 | Re: MySQL file system |