Skip site navigation (1) Skip section navigation (2)

Re: db backup script in gentoo

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: db backup script in gentoo
Date: 2008-11-30 22:16:11
Message-ID: ggv4n8$2ojc$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
Scott,

> emerge lftp

root # emerge lftp
Calculating dependencies... done!

>>> Emerging (1 of 1) net-ftp/lftp-3.4.6 to /
>>> Downloading 'http://distfiles.gentoo.org/distfiles/lftp-3.4.6.tar.gz'
--23:39:28--  http://distfiles.gentoo.org/distfiles/lftp-3.4.6.tar.gz
           => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
Lahendan distfiles.gentoo.org... 64.50.236.52, 64.50.238.52, 
140.211.166.134, ...
Loon C¼hendust serveriga distfiles.gentoo.org|64.50.236.52|:80... C¼hendus 
loodud.
HTTP pC¤ring saadetud, ootan vastust... 404 Not Found
23:39:29 VIGA 404: Not Found.

>>> Downloading 
>>> 'http://distro.ibiblio.org/pub/linux/distributions/gentoo/distfiles/lftp-3.4.6.tar.gz'
--23:39:29--  
http://distro.ibiblio.org/pub/linux/distributions/gentoo/distfiles/lftp-3.4.6.tar.gz
           => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
Lahendan distro.ibiblio.org... 152.46.7.109
Loon C¼hendust serveriga distro.ibiblio.org|152.46.7.109|:80... C¼hendus 
loodud.
HTTP pC¤ring saadetud, ootan vastust... 404 Not Found
23:39:31 VIGA 404: Not Found.

>>> Downloading 'ftp://lftp.yar.ru/lftp/old/lftp-3.4.6.tar.gz'
--23:39:31--  ftp://lftp.yar.ru/lftp/old/lftp-3.4.6.tar.gz
           => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
Lahendan lftp.yar.ru... 193.233.48.99
Loon C¼hendust serveriga lftp.yar.ru|193.233.48.99|:21... ebaCµnnestus: 
Connection refused.
!!! Couldn't download 'lftp-3.4.6.tar.gz'. Aborting.

> Because ftp is running as a cron?  Doesn't have the right permissions?

I ran script from command line as root.
Running from cron does not also upload copy. since I used cron -e as root, 
script runs probably in cron also as root.

> Because it appeared the username and password were failing?
> Maybe a lack of EOF in the
> original example you posted.  Could be a lot of reasons.

This script tries to write to /root/my-backup directory in ftp server which 
fails.
I fixed this and now it works.
There is no EOF in script but it still works.

Thank you very much for quick help, it was really useful!

> What?  Only root can access /root directory.  Or do you mean something
> else?  Only things that should be run by root are things that
> genuinely need to, and this doesn't look like one of them.
> Looks like you're trying to write to the /root directory.  Don't do that.

There are no console users in this server other than root. /home directory 
is empty.
console access is used only some times in year.

Andrus. 


In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-11-30 22:54:10
Subject: Re: db backup script in gentoo
Previous:From: Reid ThompsonDate: 2008-11-30 21:47:25
Subject: Re: db backup script in gentoo

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group