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

2012-09-04 Thread Mathias Breuninger
Hi, I configure PostgreSQL 9.1.5 on two servers: one with FreeBSD-9.0/powerpc64 and the other with FreeBSD-9.0/powerpc. The 64 bits server is the master and I tried to configure the 32 bits one as a standby server. I followed the documentation but I can't start the standby postgres daemon:

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

2012-09-04 Thread Sergey Konoplev
On Tue, Sep 4, 2012 at 12:04 PM, Mathias Breuninger mathias.breunin...@espace29.asso.fr wrote: I configure PostgreSQL 9.1.5 on two servers: one with FreeBSD-9.0/powerpc64 and the other with FreeBSD-9.0/powerpc. The 64 bits server is the master and I tried to configure the 32 bits one as a

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

2012-09-04 Thread Albe Laurenz
Mathias Breuninger wrote: I configure PostgreSQL 9.1.5 on two servers: one with FreeBSD-9.0/powerpc64 and the other with FreeBSD-9.0/powerpc. The 64 bits server is the master and I tried to configure the 32 bits one as a standby server. I followed the documentation but I can't start

[ADMIN] Schema diagramming tool?

2012-09-04 Thread Craig James
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 produce a nice diagram that can be further edited and beautified. I want something I can print and hang on the wall as a

Re: [ADMIN] Canot access PostgreSQL via psql -h (Vmware Fusion)

2012-09-04 Thread Anderson Lunz
Hi! Try to check the iptables. If you don't need a firewall just disable it. As root, try the following: service iptables status service iptables stop To disable it from starting at boot time, use: chkconfig iptables off Regards,

Re: [ADMIN] Schema diagramming tool?

2012-09-04 Thread Bob Lunney
SchemaSpy is kind of handy. Bob Sent from my iPhone On Sep 4, 2012, at 11:35 AM, Craig James cja...@emolecules.com 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

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

2012-09-04 Thread Craig Ringer
On 09/04/2012 06:04 PM, Mathias Breuninger wrote: Hi, I configure PostgreSQL 9.1.5 on two servers: one with FreeBSD-9.0/powerpc64 and the other with FreeBSD-9.0/powerpc. 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

[ADMIN] Re: What else could I've done? COPY to unlogged tbl hung/locked the table

2012-09-04 Thread amacvar
Thank you Tom for the suggestion and the workaround. I think we will be able to hold off on the temporary workaround. Would the 2nd processes in the deadlock show up in pg_locks? (It didn't) An insert from another table that i created to test the datafile did show up as blocked. I got

Re: [ADMIN] Schema diagramming tool?

2012-09-04 Thread Sergey Konoplev
On Tue, Sep 4, 2012 at 8:35 PM, Craig James cja...@emolecules.com 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 produce a nice diagram that can be further

Re: [ADMIN] Schema diagramming tool?

2012-09-04 Thread Thomas Markus
Hi, give db visualizer a try. best regards Thomas Am 04.09.2012 18:35, schrieb Craig James: 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 produce a nice diagram