pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Please help me ?
2+ messages / 2 participants
[nested] [flat]

* Please help me ?
@ 2003-05-28 16:04  andhie adam <andhie@linuxmail.org>
  0 siblings, 1 reply; 2+ messages in thread

From: andhie adam @ 2003-05-28 16:04 UTC (permalink / raw)
  To: pgsql-php


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.



best regards

andhie

Indonesia
-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Please help me ?
@ 2003-05-28 16:12  scott.marlowe <scott.marlowe@ihs.com>
  parent: andhie adam <andhie@linuxmail.org>
  0 siblings, 0 replies; 2+ messages in thread

From: scott.marlowe @ 2003-05-28 16:12 UTC (permalink / raw)
  To: andhie adam <andhie@linuxmail.org>; +Cc: pgsql-php

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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-05-28 16:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-28 16:04 Please help me ? andhie adam <andhie@linuxmail.org>
2003-05-28 16:12 ` scott.marlowe <scott.marlowe@ihs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox