pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedbackup software for postgresql
7+ messages / 7 participants
[nested] [flat]
* backup software for postgresql
@ 2005-10-02 12:06 Robert Ngo <robertngo@perridot.com>
0 siblings, 5 replies; 7+ messages in thread
From: Robert Ngo @ 2005-10-02 12:06 UTC (permalink / raw)
To: pgsql-admin
Hi,
Which backup software out there work well with postgresql, I cannot find one
with backup agent for postgres.
I am looking for a backup solution that will backup the postgres database
from a fiber channel san to a fiber channel tape library, any one here have
experience with similar setup?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2005-10-02 23:04 Uwe C. Schroeder <uwe@oss4u.com>
parent: Robert Ngo <robertngo@perridot.com>
4 siblings, 0 replies; 7+ messages in thread
From: Uwe C. Schroeder @ 2005-10-02 23:04 UTC (permalink / raw)
To: pgsql-admin; +Cc: Robert Ngo <robertngo@perridot.com>
I'm going the easy route with that one.
I do a full dump every night - which goes to tape (using any type of tape
backup software) and is mirrored to another machine using rdist. For
continuous backup I use Slony to replicate the master database to two
off-site backup servers. That way there are 3 live copies and one daily copy
at any given time - although I never needed a backup (knock on wood).
UC
On Sunday 02 October 2005 05:06, Robert Ngo wrote:
> Hi,
>
>
>
> Which backup software out there work well with postgresql, I cannot find
> one with backup agent for postgres.
>
>
>
> I am looking for a backup solution that will backup the postgres database
> from a fiber channel san to a fiber channel tape library, any one here have
> experience with similar setup?
--
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2005-10-02 23:35 Hervé Piedvache <bill.footcow@gmail.com>
parent: Robert Ngo <robertngo@perridot.com>
4 siblings, 0 replies; 7+ messages in thread
From: Hervé Piedvache @ 2005-10-02 23:35 UTC (permalink / raw)
To: pgsql-admin; +Cc: Robert Ngo <robertngo@perridot.com>
Hi,
Arkeia do this ... but the PostregSQL agent is not free.
regards,
Le Dimanche 2 Octobre 2005 14:06, Robert Ngo a écrit :
> Hi,
>
>
>
> Which backup software out there work well with postgresql, I cannot find
> one with backup agent for postgres.
>
>
>
> I am looking for a backup solution that will backup the postgres database
> from a fiber channel san to a fiber channel tape library, any one here have
> experience with similar setup?
--
Hervé Piedvache
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2005-10-03 10:35 lst_hoe01@kwsoft.de
parent: Robert Ngo <robertngo@perridot.com>
4 siblings, 0 replies; 7+ messages in thread
From: lst_hoe01@kwsoft.de @ 2005-10-03 10:35 UTC (permalink / raw)
To: pgsql-admin
Zitat von Robert Ngo <robertngo@perridot.com>:
> Hi,
>
>
>
> Which backup software out there work well with postgresql, I cannot find one
> with backup agent for postgres.
>
>
>
> I am looking for a backup solution that will backup the postgres database
> from a fiber channel san to a fiber channel tape library, any one here have
> experience with similar setup?
>
There are a number of products which can do this :
http://www.bakbone.com/products/backup_and_restore/
http://www.sep.de/sesam/overview_us.php
and maybe many others.
Regards
Andreas
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2005-10-05 16:00 Chris Browne <cbbrowne@acm.org>
parent: Robert Ngo <robertngo@perridot.com>
4 siblings, 0 replies; 7+ messages in thread
From: Chris Browne @ 2005-10-05 16:00 UTC (permalink / raw)
To: pgsql-admin
robertngo@perridot.com ("Robert Ngo") writes:
> Which backup software out there work well with postgresql, I cannot
> find one with backup agent for postgres.:p>
You don't need one.
You can simply schedule a job that runs "pg_dump" every so often
(daily is common) to save data to a file. Most competent backup
systems can backup data in files, so can pull the pg_dump output...
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://www3.sympatico.ca/cbbrowne/backup.html
"sic transit discus mundi"
-- From the System Administrator's Guide, by Lars Wirzenius
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2015-06-22 09:44 apogoreliy <apogoreliy@gmail.com>
parent: Robert Ngo <robertngo@perridot.com>
4 siblings, 1 reply; 7+ messages in thread
From: apogoreliy @ 2015-06-22 09:44 UTC (permalink / raw)
To: pgsql-admin
Robert Ngo wrote
> Hi,
>
>
>
> Which backup software out there work well with postgresql, I cannot find
> one
> with backup agent for postgres.
>
>
>
> I am looking for a backup solution that will backup the postgres database
> from a fiber channel san to a fiber channel tape library, any one here
> have
> experience with similar setup?
I would like to recommend this tool to backup postgresql database scheduled
- PostgreSQL Backup http://postgresql-backup.com/ PostgreSQL Backup runs on
Windows machine and backups remote PostgreSQL databases via TCP/IP
connection.
--
View this message in context: http://postgresql.nabble.com/backup-software-for-postgresql-tp2078003p5854682.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup software for postgresql
@ 2015-06-23 16:19 Scott Ribe <scott_ribe@elevated-dev.com>
parent: apogoreliy <apogoreliy@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Scott Ribe @ 2015-06-23 16:19 UTC (permalink / raw)
To: apogoreliy <apogoreliy@gmail.com>; +Cc: pgsql-admin
On Jun 22, 2015, at 3:44 AM, apogoreliy <apogoreliy@gmail.com> wrote:
>
> I would like to recommend this tool to backup postgresql database scheduled
> - PostgreSQL Backup http://postgresql-backup.com/ PostgreSQL Backup runs on
> Windows machine and backups remote PostgreSQL databases via TCP/IP
> connection.
And it uses pg_dump, thus not solving OP's problem with pg_dump failing.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2015-06-23 16:19 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-02 12:06 backup software for postgresql Robert Ngo <robertngo@perridot.com>
2005-10-02 23:04 ` Uwe C. Schroeder <uwe@oss4u.com>
2005-10-02 23:35 ` Hervé Piedvache <bill.footcow@gmail.com>
2005-10-03 10:35 ` lst_hoe01@kwsoft.de
2005-10-05 16:00 ` Chris Browne <cbbrowne@acm.org>
2015-06-22 09:44 ` apogoreliy <apogoreliy@gmail.com>
2015-06-23 16:19 ` Scott Ribe <scott_ribe@elevated-dev.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