Re: db backup script in gentoo - Mailing list pgsql-general

From Andrus
Subject Re: db backup script in gentoo
Date
Msg-id 76AC1C36333B40FEBB54BD78B745A112@andrusnotebook
Whole thread Raw
In response to db backup script in gentoo  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Reid,

> since he noted the distro is '3 years old', odds are the portage tree is
> out of date.
>
> you can try a
>  sudo emerge --sync
>
> and then
>
> sudo emerge --ask lftp
>
> note that if a sync has not been done in a long time, many packages may be
> out of date ( possibly why the 'get' of left failed ).  if lftp has
> dependencies, they will most likely have to be rebuilt, and if the
> dependencies have dependencies, etc, etc, etc -- so the results of the
> above emerge could be very large and have a lot of impact.

Will existing PostgreSql 8.1.4 server continue working after running those
commands ?
Or is there possibility that it stops working ?
Will those commands require re-booting server ?

> If ssh/scp are already on the box it might be easier to setup a
> passwordless login configuration and use either scp or sftp to push the
> backup file.

backup ftp server is located in ISP.
It offers ftp and http access only.
So I cannot use scp nor sftp probably.

Andrus.


pgsql-general by date:

Previous
From: Maxim Boguk
Date:
Subject: Indexes on NULL's and order by ... limit N queries
Next
From: Tom Lane
Date:
Subject: Re: Cannot open include file: 'nodes/nodes.h'