> System logs maybe? Something about a process getting killed? Have > you tried turning up the verbosity of the pg logs? Syslog has to be compiled with PG? How do I enable it? Where should I look for it? The documentation, whenever it mentions "syslog", always just assumes the expression "If syslog is enabled". Well where do I enable it? - http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html Would appreciate some guidance on this. > We gotta check one thing at a time really. > > If you copy the dir off to another machine and run pgsql 8.2.latest or > thereabouts, can you then create the index? I will try this. Transferring 106GB of data, even zipped, is a huge ask and just the management will take over a day or so. I was hoping we could do without this. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general