Sean Murphy wrote:
> search of the Docs tells me that I can compile the server with a
> different MAXALIGN, but the install docs don't give any indication
> how this is achieved. Is there a configure or gmake option I can
> feed, or do I need to change a line in one (or more) of the source
> files?
Actually the colo machine is running Windows as well (not my call, but
there are other workloads on it) but Ubuntu is running under VMWare, so
I could install a truly identical copy of the colo "machine" on the same
server I'm moving from...
Thanks!
Andy Shellam wrote:
> Is there any chance of yo
Slony doesn't do LOs...
Joshua D. Drake wrote:
> Sean Murphy wrote:
>> We're talking about 12 GB of data... to do the [probably ill-fated]
>> binary copy in any reasonable amount of time required a portable hard
>> drive and sneaker-net...
>>
>> That's why I'm anxious, probably to the point of stu
Sean Murphy wrote:
We're talking about 12 GB of data... to do the [probably ill-fated]
binary copy in any reasonable amount of time required a portable hard
drive and sneaker-net...
That's why I'm anxious, probably to the point of stupidity, to avoid a
situation where I'll have to bring the db d
Is there any chance of you setting up a temporary machine on the same
network as your Windows one but an identical build as your co-located
machine? Then you can transfer your Windows data to Linux using
pg_dump/restore, switch your apps over to the Linux machine, then use
WAL files to mimic t
We're talking about 12 GB of data... to do the [probably ill-fated]
binary copy in any reasonable amount of time required a portable hard
drive and sneaker-net...
That's why I'm anxious, probably to the point of stupidity, to avoid a
situation where I'll have to bring the db down long enough to pu
From experience I would say NEVER NEVER try and do a direct copy across
different platforms (Windows -> Linux.)
Someone may contradict me, but I think a dump/restore would be the way
to go.
What sort of size of data are we talking? You'll need to factor in the
time it takes to dump the data,
I'm in the process of moving a large database from an in-house Win32
server to a co-located Ubuntu Linux server. The data's in constant use,
so I can't really bring the server down for more than a half hour or so,
and I'd like to go ahead and use a base backup + WAL restore strategy to
sync the ser