On Thu, 29 May 2003, andhie adam wrote:
>
> Dear All
>
> I'am new user in postgresql, i want to ask some questions. please helpme ??
>
> I have two computer A (this is server ) and computer B (this is server
> for backup).
> I want to backup database Postgresql automatically from computer A to
> computer B.
> I dont want to manual restore database from computer B. I want always
> automatic syncronicer for saerver database for backup.
Well, there's a couple of things you can do. One is to use replication.
There are several replication methods out there. They make sure that any
change on the master server gets propogated to the slave server.
the other possibility is a "hot backup" which is a box that gets a dump
from the master server each night, but doesn't get updates throughout the
day. This is more of a failover for catastrophic failure kind of box.
To backup from one box to the other, you need to have tcp_sockets turned
on in postgresql.conf, and pg_hba.conf needs to be configured to let you
connect remotely from the other machine. Then, on the slave box, you can
do this:
pg_dumpall -h masterbox | psql template1
This will run pretty fast. On a machine with simple data, you can backup
a couple of gigabytes an hour easy that way. You can write a script that
goes in and drops all the databases locally, then runs the above one liner
and cron it up to run at midnight or whatnot.