On 23.04.13 12.50, Karl Wright wrote:
Can you dump the postgresql schema that is in place on the production
machine? Specifically, I want to see the jobqueue table's indexes.
I must use the tools I have available since I'm not having direct access
to the PostgreSQL server. I cannot use the pg_dump tool.
The seven indices which are available for the jobqueue table is (made
visible by using "create scrip" in PGAdmin:
1. CREATE UNIQUE INDEX i1362584563120
ON jobqueue
USING btree
(dochash COLLATE pg_catalog."default", jobid);
2. CREATE INDEX i1362584563121
ON jobqueue
USING btree
(docpriority, status COLLATE pg_catalog."default", checkaction
COLLATE pg_catalog."default", checktime);
3. CREATE INDEX i1362584563122
ON jobqueue
USING btree
(status COLLATE pg_catalog."default", priorityset);
4. CREATE INDEX i1362584563123
ON jobqueue
USING btree
(status COLLATE pg_catalog."default", checkaction COLLATE
pg_catalog."default", checktime);
5. CREATE INDEX i1362584563124
ON jobqueue
USING btree
(failtime, jobid);
6. CREATE INDEX i1362584563125
ON jobqueue
USING btree
(isseed COLLATE pg_catalog."default", jobid);
7. CREATE INDEX i1362584563126
ON jobqueue
USING btree
(jobid, status COLLATE pg_catalog."default");
I *have* deleted the MCF tables manually before in case that operation
caused problems. Just mentioning.
Erlend
--
Erlend Garåsen
Center for Information Technology Services
University of Oslo
P.O. Box 1086 Blindern, N-0317 OSLO, Norway
Ph: (+47) 22840193, Fax: (+47) 22852970, Mobile: (+47) 91380968, VIP: 31050
