| From: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade & tablespaces |
| Date: | 2013-12-31 21:31:02 |
| Message-ID: | CAAW2xfcCO=cyJWt2qEYW-rZTtwC0fYBrONtQG_-QqfmZB4=cFw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
>
>
>> ERROR: relation "sys_errors" does not exist
>> LINE 1: SELECT * FROM sys_errors ORDER BY created_ts DESC LIMIT 100;
>> ^
>> ********** Error **********
>>
>> ERROR: relation "sys_errors" does not exist
>> SQL state: 42P01
>> Character: 15
>>
>
> sys_errors is a table in the tablespace correct?
>
Yes it is.
>
>> The second test, using the exact same pg_upgrade line. But this time I
>> updated the location of the tablespaces to outside the /data directory.
>> I updated pg_tablespace and re-created all symlinks. Now the data
>> directory doesn't contain the tablespaces. Again pg_upgrade completes
>> successfully and again I get the same error about the relation.
>>
>> Any thoughts?
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-12-31 21:39:08 | Re: pg_upgrade & tablespaces |
| Previous Message | John R Pierce | 2013-12-31 21:09:54 | Re: Format of Pioint datatype.... lat/long or long/lat?? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-12-31 21:39:08 | Re: pg_upgrade & tablespaces |
| Previous Message | Tom Lane | 2013-12-31 21:01:34 | Re: Get more from indices. |