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.
