Replicating a remote database (backuping)
Hello all!
I was looking for ways to backup my remote database in a local
computer. I was talking to #postgresql folks, who said me to try sloty.
I tried, but I couldn't make it run (I was following
http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic).
I have a database that is, for now, 20 Mb. I want to download that
information and store in my local computer everyday in a way that allow
me to upload everything again if something bad occurs with the remote
database.
Is sloty the best choice? Is there anything different?
Thank you! Bye!
Silas Justiniano <silasju@gmail.com> schrieb:
I was looking for ways to backup my remote database in a local
computer. I was talking to #postgresql folks, who said me to try sloty.Is sloty the best choice? Is there anything different?
Only backup? I think, you can use pg_dump or pg_dumpall.
Btw.: not 'sloty', 'slony'!
Btw.: /me is akretschmer on #postgresql ;-)
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�