| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrew Bartley" <abartley(at)evolvosystems(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: reindex |
| Date: | 2003-02-25 15:02:16 |
| Message-ID: | 10407.1046185336@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Andrew Bartley" <abartley(at)evolvosystems(dot)com> writes:
> We are running PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC gcc
> (GCC) 3.2.1
> backend> reindex database evolvo force
> NOTICE: relation 1247 was reindexed
> NOTICE: relation 1249 was reindexed
> NOTICE: relation 1259 was reindexed
> NOTICE: relation 1261 was reindexed
> NOTICE: relation 1262 was reindexed
> ERROR: cannot create pg_inherits_relid_seqno_index: File exists
If you've been running this database long enough to wrap around the OID
counter, then this failure is possible (though I wouldn't have thought
it probable). Try a few times and it'll probably succeed eventually.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-02-25 15:02:49 | Re: [urgent]need help transferring database to another server |
| Previous Message | Andrew Sullivan | 2003-02-25 15:01:21 | Re: 7.4? |