From: | Eric Naujock <naujocke(at)abacusii(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Reliable and scrptable backup to Postgresql databases. |
Date: | 2002-06-23 17:18:00 |
Message-ID: | 20020623T131853Z_E5A300070003@abacusii.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am looking to setup a reliable and automatic way to backup my Postgresql database to a remote server.
What I have tried is to use the PG_Dumpall function to dump the contents of my databases. And then have a remote machine use SMB to back up the files using our backup system. My problem is that pg_dumpall wants a password for the account I want to use to run the backup.
Is there a better way to do this. If my understanding is correct, It would be a bad thing for me to just try to tarball the /pgsql folder when the databases is running. I cannot readily take the database offline to run the backup as it is a key part of running a webserver and some network utilities.
Does anyone have an suggestions on how to do this well. I also have to be able to backup my BLOBS that are in the database.
Thanks in advance.
--------------------------------------------------------------------------------
Eric Naujock CCNA, CCDA, A+, Network +, I-Net +
Abacus II
5610 Monroe St.
Sylvania, Ohio 43560
<http://www.abacusii.com>
E-mail - naujocke(at)abacusii(dot)com
Phone - 419-885-0082 X 241
Fax : 419-885-2717
AOL IM: erlic
From | Date | Subject | |
---|---|---|---|
Next Message | John Nix | 2002-06-23 18:25:34 | Re: Reliable and scrptable backup to Postgresql databases. |
Previous Message | Tom Lane | 2002-06-21 20:54:32 | Re: Opaque not working as documented |