Re: Can a whole server be restored over to another server in a single command?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Can a whole server be restored over to another server in a single command?
From: Kevin Bailey <kbailey@xxxxxxxxxxxxxxxxxxx>
Date: Sat, 11 Apr 2009 11:30:40 +0100
In-reply-to: <49E064D4.1070300@xxxxxxxxxxxxxxxxxxx>
References: <49DF12B4.8080100@xxxxxxxxxxxxxxxxxxx> <4544e0330904101231w733e0af6we803e4684be36b87@xxxxxxxxxxxxxx> <29476.1239392731@xxxxxxxxxxxxx> <49DFF3AA.1070900@xxxxxxxxxxxxxxxxxxx> <49E064D4.1070300@xxxxxxxxxxxxxxxxxxx>
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx
User-agent: Thunderbird 2.0.0.21 (X11/20090318)

The problem is that we'd like to repeatedly carry out this action - soexisting objects are causing errors.

Maybe there can be a combination? Say, completely dropping alldatabases on the receiving server before reloading from the backup file?


Kev

--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Follow-Ups:
- How to completely clean out all databases from a PG server and reinitialise from scratch
  - From: Kevin Bailey

References:
- backing and restoring whole database server - how does this script look
  - From: Kevin Bailey
- Re: backing and restoring whole database server - how does this script look
  - From: Peter Koczan
- Re: backing and restoring whole database server - how does this script look
  - From: Tom Lane
- Re: backing and restoring whole database server - how does this script look
  - From: Kevin Bailey
- Can a whole server be restored over to another server in a single command?
  - From: Kevin Bailey

Prev by Date: Can a whole server be restored over to another server in a single command?
Next by Date: How to completely clean out all databases from a PG server and reinitialise from scratch
Previous by thread: Can a whole server be restored over to another server in a single command?
Next by thread: How to completely clean out all databases from a PG server and reinitialise from scratch
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]