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


From: ljsharpe <ljsharpe(at)westnet(dot)com(dot)au>
To: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Backup
Date: 2002-03-31 02:48:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi All,

Operating databases is not my forte and I am new to it.  For me a
database is a tool to use to help with my main work (so is a computer if
it comes to that).  I can ill afford to lose any data.

I run two databases for personal purposes and have a two machine
network.  The "old" machine I use for back up purposes.  I have run the
dump command and produced two .sql files which I have transferred to my
old machine via ftp.  Both have successfully re-created their databases
on my old machine.

I have now added to both databases and wish to do a subsequent back

Do I just run the dump command on each database again please?  Will this
overwrite the original .sql files or should I delete (rm) the original
.sql files on my current or working machine and start again?  On the old
machine do I delete the first .sql files and ftp the newer ones and then
just run the psql command to re-create the updated databases?  Do I have
to drop the first re-created databases before attempting to restore the
updated .sql files after sending them via ftp from my current machine to
my old machine?  I could just try to see what works (as I did when
starting and running postgresql in the first place) but I worry about
losing my data in an ill-conceived experiment.

I am running Red Hat Linux 6.2.

Thanks for any help.


Les Sharpe
Tel (08) 9193 1335
Fax (manual) (08) 9193 1335

100 things you don't want the sysadmin to say.
 76. I have never seen it do *that* before...


  • Re: Backup at 2002-03-31 03:30:39 from Jason Friedman

pgsql-novice by date

Next:From: Jason FriedmanDate: 2002-03-31 03:30:39
Subject: Re: Backup
Previous:From: pg sqlDate: 2002-03-31 00:57:12
Subject: Upgrading - How?

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