[ADMIN] server - odbc driver compatibility matrix

2011-05-18 Thread Silvio Brandani
Hi, where can I found the compatibility matrix between Postgresql server and odbc drivers ?? we are going to upgrade our production databases to 9.0.2 and we get problems with new odbc drivers 9.0.x . So we need to know if the "old" 8.3 or 8.4 drivers are still working from new postgres serv

Re: [ADMIN] postgres on CVFS / StorNext filesystem

2011-05-18 Thread Eric Comeau
On 11-05-17 02:56 PM, Maria L. Wilson wrote: Anybody have any experience or issues running postgres (version8.4) on a CVFS filesystem? thanks much Maria Wilson NASA/Langley Research Center Hampton, Virginia 23681 m.l.wil...@nasa.gov Why would you want to do this? What are you hoping to

[ADMIN] Deadlock during CREATE INDEX CONCURRENTLY, but index still created

2011-05-18 Thread Florian Weimer
I've run two CREATE INDEX CONCURRENTLY on the same table in parallel, and one of them errored out with: 2011-05-18 14:30:06.645 UTC bfk 23530 postgres ERROR: deadlock detected 2011-05-18 14:30:06.645 UTC bfk 23530 postgres DETAIL: Process 23530 waits for ShareLock on virtual transaction 9/28

Re: [ADMIN] Deadlock during CREATE INDEX CONCURRENTLY, but index still created

2011-05-18 Thread Scott Marlowe
On Wed, May 18, 2011 at 9:19 AM, Florian Weimer wrote: > I've run two CREATE INDEX CONCURRENTLY on the same table in parallel, > and one of them errored out with: > The curious thing is that both indexes were created.  I would have > expected that the creation of idx1 would be rolled back. > > Are

Re: [ADMIN] Deadlock during CREATE INDEX CONCURRENTLY, but index still created

2011-05-18 Thread Florian Weimer
* Scott Marlowe: > On Wed, May 18, 2011 at 9:19 AM, Florian Weimer wrote: >> I've run two CREATE INDEX CONCURRENTLY on the same table in parallel, >> and one of them errored out with: >> The curious thing is that both indexes were created.  I would have >> expected that the creation of idx1 would

[ADMIN] shutdown procedure warm standby

2011-05-18 Thread Syed Khan
Hi, We have a warm standby configuration, what would be a graceful way of shutting down the warm - recovering database on windows for maintenance such as patching. We do it this way... 1. PG_CTL STOP -m FAST but this results in getting this message in the pg_logs once the system and d

[ADMIN] visualizing database schema - png/jpeg?

2011-05-18 Thread neubyr
Anyone knows of tools that can generate PNG/JPEG image from pgsql database schema? -- neuby.r -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Unable To Establish Connections

2011-05-18 Thread Sam Stearns
Future reference: Problem was caused by primary DNS resolver suffering from degraded performance. Server experienced a software issue with BIND, the software that performs DNS resolution. On Wed, May 18, 2011 at 10:11 AM, Sam Stearns wrote: > Thanks, Tim. > > I've turned up logging some more. >

Re: [ADMIN] visualizing database schema - png/jpeg?

2011-05-18 Thread M. D.
might want to take a look at Power*Architect - http://www.sqlpower.ca/page/architect MD On 05/18/2011 01:09 PM, neubyr wrote: > Anyone knows of tools that can generate PNG/JPEG image from pgsql > database schema? > > -- > neuby.r > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or

Re: [ADMIN] visualizing database schema - png/jpeg?

2011-05-18 Thread Johann Spies
On Wed, May 18, 2011 at 09:09:19PM +0200, neubyr wrote: > Anyone knows of tools that can generate PNG/JPEG image from pgsql > database schema? I am usine postgresql-autodoc on Debian. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager