FROM pg_stat_all_indexes i
> JOIN pg_class c ON (c.oid = i.relid)
> JOIN pg_namespace n ON (n.oid = c.relnamespace)
> JOIN pg_index idx ON (idx.indexrelid = i.indexrelid )
> WHERE i.idx_scan = 0
>AND NOT idx.indisprimary
> AND NOT idx.indisunique
> ORDER BY 1, 2,
ta.
On Thu, Mar 10, 2016 at 7:44 PM, Adrian Klaver
wrote:
> On 03/10/2016 04:11 PM, Robert McAlpine wrote:
>
>>
>> Postgresql 9.5, Ubuntu 14.04.
>>
>> I broke my ability to access postgres after attemping to install
>> postgres-xc (ironic, since I insta
stall with a
correct default postgres role, but my gut tells me that screwing around
with those files is doomed to fail.
I would appreciate any help or thoughts on how to recover access to the
data.
--
Robert McAlpine
r...@pfcta.com
