pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedPlease help me ?
2+ messages / 2 participants
[nested] [flat]
* Please help me ?
@ 2003-05-28 16:04 andhie adam <andhie@linuxmail.org>
2003-05-28 16:12 ` Re: Please help me ? scott.marlowe <scott.marlowe@ihs.com>
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:04 Please help me ? andhie adam <andhie@linuxmail.org>
@ 2003-05-28 16:12 ` scott.marlowe <scott.marlowe@ihs.com>
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