Re: [ADMIN] Schema diagramming tool?

2012-09-05 Thread Craig James
On Tue, Sep 4, 2012 at 9:48 PM, Sergey Konoplev wrote: > On Tue, Sep 4, 2012 at 8:35 PM, Craig James wrote: >> Can anyone recommend a good tool for producing a good drawing of an existing >> database schema? I don't need a design tool, but rather one that can take >> an existing schema and produ

Re: [ADMIN] Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error

2012-09-05 Thread Craig James
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, architecture-specific representation of data that's optimized for

Re: [ADMIN] PG 9.1 Looking for old WAL when promoting from recovery to master

2012-09-05 Thread Fujii Masao
On Tue, Sep 4, 2012 at 7:01 AM, David Morton wrote: > I'm implementing replica servers which will use a trigger file to promote > from hot standby to full read/write. I've configured streaming replication > as well as a recovery.conf which copies old WAL files from a repository if > required. > >

Re: [ADMIN] Log-Shipping Standby Server: USE_FLOAT8_BYVAL compatibility error

2012-09-05 Thread Mathias Breuninger
On 09/04/2012 11:45 PM CEST, Craig Ringer wrote: > > The 64 bits server is the master and I tried to configure the 32 bits > one as a standby server. > > That isn't a supported configuration. The standby needs to be the same > architecture as the master and needs to use the same compilation > opti