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:58:15 |
Message-ID: | 94358g$krq$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-17 04:20:34 | Re: MySQL file system |
Previous Message | Mike Miller | 2001-01-17 03:55:20 | Permissions |