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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
