[ADMIN] server - odbc driver compatibility matrix
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 server version. any comment higly appreciated. -- Silvio Brandani --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme. -- -- 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] postgres on CVFS / StorNext filesystem
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 achieve by running the database over such a filesystem - it would equate to running it over NFS. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Deadlock during CREATE INDEX CONCURRENTLY, but index still created
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/28523127; blocked by process 26612. Process 26612 waits for ShareUpdateExclusiveLock on relation 229701 of database 229155; blocked by process 23530. Process 23530: CREATE INDEX CONCURRENTLY idx1 ON tbl (col1); Process 26612: CREATE INDEX CONCURRENTLY idx2 ON tbl (col); The curious thing is that both indexes were created. I would have expected that the creation of idx1 would be rolled back. Are both of the usable, or should I re-create idx1 from scratch? This is with PostgreSQL 8.4.7. (The changelog for 8.4.8 does not list anything which appears to be relevant.) -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- 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] Deadlock during CREATE INDEX CONCURRENTLY, but index still created
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 both of the usable, or should I re-create idx1 from scratch? They should be marked invalid. -- 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] Deadlock during CREATE INDEX CONCURRENTLY, but index still created
* 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 both of the usable, or should I re-create idx1 from scratch? > > They should be marked invalid. Ah, thanks, I see it now. I guess this answers my question. 8-) -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] shutdown procedure warm standby
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 database are back up and running in recovery mode. 2011-05-17 17:37:50 PDTHINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target. Does that mean our data has been corrupted ? I have tested and opened the database but don't see any corruption. If we use PG_CTL STOP the recovery doesn't stop at all. Please let us know if the above message can be ignored or if we are not shutting the warm database properly. Thanks! Regards, Syed # 2852
[ADMIN] visualizing database schema - png/jpeg?
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
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. > > On Wed, May 18, 2011 at 8:38 AM, Tim wrote: >> First google hit said this: >> >> "It seems (not sure) to occur when user retypes password fast. >> Maybe in this case ODBC driver gets old connection somehow from driver >> manager." >> >> also >> "It looks to me like the ODBC driver is failing to follow the protocol. >> It shouldn't respond with an 'X' if it doesn't have a password, just >> disconnect." >> I would start logging traffic so you have more to go on next time it >> happens. >> >> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns wrote: >>> >>> Anyone have any ideas on this? We're an ISP. I was thinking of the >>> possibility of a hack attempt. >>> >>> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns >>> wrote: >>> > Howdy, >>> > >>> > Environment: >>> > >>> > Postgres 8.2.3 >>> > Solaris 10 >>> > >>> > We were unable to make a remote postgres connection for ~2 hours this >>> > afternoon. Receiving the following message in the postgres log every >>> > 30 seconds: >>> > >>> > LOG: expected password response, got message type 88 >>> > >>> > Connection limit is 300. 17 active connections at the time. Bounced >>> > postgres successfully but the above error message was still being >>> > logged. About 20 minutes later the error message stopped and >>> > connections started to re-establish. >>> > >>> > Any ideas? >>> > >>> > Thank you, >>> > >>> > Sam >>> > >>> >>> -- >>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-admin >> >> > -- 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] visualizing database schema - png/jpeg?
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.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] visualizing database schema - png/jpeg?
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 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. "But as it is written, Eye hath not seen, nor ear heard, neither have entered into the heart of man, the things which God hath prepared for them that love him." I Corinthians 2:9 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
