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