Re: [GENERAL] Db backup

On 6/8/2017 12:29 PM, John R Pierce wrote: On 6/8/2017 12:10 PM, Jimmy Lunceford wrote: A windows 7 computer went bad but the hdd is still operable. Is there a way to transfer the db data directories to another computer or does it require a dump and restore? the data directories should work

Re: [GENERAL] Db backup

On 6/8/2017 12:10 PM, Jimmy Lunceford wrote: A windows 7 computer went bad but the hdd is still operable. Is there a way to transfer the db data directories to another computer or does it require a dump and restore? the data directories should work as-is on another Windows computer with the

Re: [GENERAL] Db backup

On 06/08/2017 12:10 PM, Jimmy Lunceford wrote: A windows 7 computer went bad but the hdd is still operable. Is there a way to transfer the db data directories to another computer or does it require a dump and restore? As long as the data is intact and you use the same major version of postgre

[GENERAL] Db backup

A windows 7 computer went bad but the hdd is still operable. Is there a way to transfer the db data directories to another computer or does it require a dump and restore? -- [image: Innerspace Strategies] Jimmy Lunceford / HVAC Controls technicianjimmy_luncef...@innerspacecon

Re: [GENERAL] db backup script in gentoo

as previously said you need to go to http://forums.gentoo.org/ On Mon, Dec 1, 2008 at 13:16, Andrus <[EMAIL PROTECTED]> wrote: > your /usr/portage directory is probably not mounted properly check that >> again and then check /etc/make.profile points to a valid directory which >> will be >somethin

Re: [GENERAL] db backup script in gentoo

your /usr/portage directory is probably not mounted properly check that again and then check /etc/make.profile points to a valid directory which will be >something along the lines of /usr/portage/profiles/default-linux// jomanda etc # ls /etc/make.profile -l lrwxrwxrwx 1 root root 48 19. juuni

Re: [GENERAL] db backup script in gentoo

On Mon, Dec 1, 2008 at 12:04, Andrus <[EMAIL PROTECTED]> wrote: > sudo emerge --sync >> > > * An update to portage is available. It is _highly_ recommended > * that you update portage now, before any other packages are updated. > * Please run 'emerge portage' and then update ALL of your > * confi

Re: [GENERAL] db backup script in gentoo

sudo emerge --sync ... deleting xfce-extra/xfce4-weather/files/digest-xfce4-weather-0.4.9 deleting xfce-extra/xfce4-weather/files/digest-xfce4-weather-0.4.1 deleting xfce-extra/xfce4-weather/files/digest-xfce4-weather-0.4.0 deleting xfce-extra/xfce4-weather/files/digest-xfce4-weather-0.3.9.1-r1

Re: [GENERAL] db backup script in gentoo

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 ). i

Re: [GENERAL] db backup script in gentoo

Scott, OK, find out how to create users on your gentoo server, and see if you can figure out what's broken in emerge so you can install lftp. It's much better than regular ftp, as it has assured transfer completion and other useful features if you're interested in making sure the file gets tran

Re: [GENERAL] db backup script in gentoo

Andrus wrote: 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, I don't know how this conversation ended up on a PG mailing list, but Gentoo maintains many user forums where people are happy to answer

Re: [GENERAL] db backup script in gentoo

On Sun, Nov 30, 2008 at 3:16 PM, Andrus <[EMAIL PROTECTED]> wrote: > 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:

Re: [GENERAL] db backup script in gentoo

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/

Re: [GENERAL] db backup script in gentoo

Scott Marlowe wrote: On Sun, Nov 30, 2008 at 1:18 PM, Andrus <[EMAIL PROTECTED]> wrote: Sorry, I'm no gentoo expert. It's certainly not the first distro I'd recommend to someone just starting out with linux / unix. Time to break out the google. I also found quite a few example scripts for lft

Re: [GENERAL] db backup script in gentoo

On Sun, Nov 30, 2008 at 1:18 PM, Andrus <[EMAIL PROTECTED]> wrote: >> Sorry, I'm no gentoo expert. It's certainly not the first distro I'd >> recommend to someone just starting out with linux / unix. Time to >> break out the google. I also found quite a few example scripts for >> lftp with googl

Re: [GENERAL] db backup script in gentoo

Sorry, I'm no gentoo expert. It's certainly not the first distro I'd recommend to someone just starting out with linux / unix. Time to break out the google. I also found quite a few example scripts for lftp with google in a few minutes. I must manage existing gentoo server where previous main

Re: [GENERAL] db backup script in gentoo

On Sun, Nov 30, 2008 at 3:17 AM, Andrus <[EMAIL PROTECTED]> wrote: >> Are you using ftp or lftp? lftp is much more scriptable / controllable >> than regular ftp. > > I'm using ftp as shown in script. > typing lftp shows that this is not found but locate shows something. > How to use lftp in this 3-

Re: [GENERAL] db backup script in gentoo

Are you using ftp or lftp? lftp is much more scriptable / controllable than regular ftp. I'm using ftp as shown in script. typing lftp shows that this is not found but locate shows something. How to use lftp in this 3-year old gentoo ? Where to find sample script for thos task ? Andrus. pg_log

Re: [GENERAL] db backup script in gentoo

On Sat, Nov 29, 2008 at 3:23 PM, Andrus <[EMAIL PROTECTED]> wrote: > Uwe, > > thank you very much. I created script and ran it from command line: > > #!/bin/sh > PGUSER=postgres > PGPASSWORD=password > export PGUSER PGPASSWORD > backupdir=/root/my-backups > backupdate=$(date +%u) > backupfile=${bac

Re: [GENERAL] db backup script in gentoo

Uwe, thank you very much. I created script and ran it from command line: #!/bin/sh PGUSER=postgres PGPASSWORD=password export PGUSER PGPASSWORD backupdir=/root/my-backups backupdate=$(date +%u) backupfile=${backupdir}/mybackup${backupdate}.backup pg_dump -Fc -b -Z6 mydb >${backupfile} /usr/bin/f

Re: [GENERAL] db backup script in gentoo

On Sat, Nov 29, 2008 at 12:39 PM, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote: > Now you'd just have to figure out the ftp part, because I use rdist to push > the copies to a backup machine. Look up lftp. It's a very capable scriptable ftp client with automatic retry etc... also does ssl. -- Se

Re: [GENERAL] db backup script in gentoo

On Saturday 29 November 2008, Andrus wrote: > How to create automated backup script in Gentoo which in every night 3:00 > PM backups one database and sends backup > with ftp using unique file name? > > In windows I can use scheduler and script > > set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDb

Re: [GENERAL] db backup script in gentoo

On Saturday 29 November 2008, "Andrus" <[EMAIL PROTECTED]> wrote: > How to create automated backup script in Gentoo which in every night 3:00 > PM backups one database and sends backup > with ftp using unique file name? > > In windows I can use scheduler and script > > set FILENAME=%DATE:~8,4%%DATE

[GENERAL] db backup script in gentoo

How to create automated backup script in Gentoo which in every night 3:00 PM backups one database and sends backup with ftp using unique file name? In windows I can use scheduler and script set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDbBackup pg_dump -Z6 -b -v -f "%FILENAME%.backup" -F c -h