Hi,
I have a database with several tablespaces on different disks and
backup-ed it with pg_basebackup. I have theses files:
base_20120902.tar.gz
27781958.tar.gz
27781959.tar.gz
Now I want to restore it on another server with only one disk. I'm
confused how to handle those tablespace files. Is
On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
> Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just using pg_upgrade?
> For what I could read, the only exception would be if I was using a
> citext column (which I am not).
You cannot use pg_upgrade for this. You just need t
Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just using pg_upgrade?
For what I could read, the only exception would be if I was using a
citext column (which I am not).
Thank you
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http:
Install Postgres in both server machine
Configure the MS Cluster Service, add the external storage and the Postgres
Service to your cluster group, and configure the postgres service to start
using the directory in the external storage.
Now you have a fail over database.
Add you application to cl
Robert Haas writes:
> On Mon, Aug 27, 2012 at 9:58 AM, Bruce Momjian wrote:
>> From Tom Lane in the above thread:
>>> Hmm. I can see how that would happen if you're using one of the Windows
>>> environments wherein malloc's done inside libpq have to be free'd inside
>>> libpq. (The PQExpBuffer
On Mon, Aug 27, 2012 at 9:58 AM, Bruce Momjian wrote:
> On Tue, Jan 17, 2012 at 04:46:50PM -0500, David Schnur wrote:
>> I finally had time to test this further on a variety of systems, and was
>> unable
>> to reproduce on any non-Windows platform. The dump even works fine on
>> Windows
>> XP;
Hello,
We are planning to use Postgresql for one our project where we can 24/7
uptime.
We would like to know if there is a High Availability Solution that can be
implemented on Windows Machines.
We are specially interested in Clustering(Active-Passive Model with DB
sitting on a Shared Drive).
Pl
On Wed, Sep 5, 2012 at 7:26 PM, Craig James wrote:
>> I used to use PostgreSQL Maestro for this purpose. Its Designer tool
>> is quite nice.
>
> They don't say anywhere on their web site which platforms they
> support. Is this a Windows-only application?
I think it is. I worked with it on Window
On 09/05/2012 4:59 PM, Craig James wrote:
> On Wed, Sep 5, 2012 at 2:21 AM, Mathias Breuninger
> > I wasn't aware of the binary problem with replication.
> > Maybe the PostgreSQL docs should emphasize the architecture
> restriction.
>
> That's sort of what "binary file" means -- a raw, architectur
