Thread: 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°