On 04/18/2014 06:25 AM, Guillaume Drolet wrote:
> Thanks for the doc on pg_resetxlog. Will try it next week when I'm
> back from Easter holiday, first backuping $PGDATA.
>
> Most of my databases are stored in a default tablespace I defined on a
> different disk than that of my PG installation (and $PGDATA): could I
> just reinstall PG and then re-link it with my databases on that disk?
>
Not really, $PGDATA holds the global information for the cluster. If you
reinstalled which implies another initdb then you would have a
head($PGDATA) that knows nothing about the rest of the body.
--
Adrian Klaver
adrian.klaver@aklaver.com