Postgres Pro
Downloads
Home   >   mailing lists

Re: Why copy_relation_data only use wal when WALarchiving is enabled - Mailing list pgsql-hackers

From Jacky Leng
Subject Re: Why copy_relation_data only use wal when WALarchiving is enabled
Date
Msg-id ff6upn$1lof$1@news.hub.org
Whole thread Raw
In response to Why copy_relation_data only use wal when WAL archiving is enabled  ("Jacky Leng" <lengjianquan@163.com>)
List pgsql-hackers
Tree view 
> You need to set $PGDATA before running the script. And psql,pg_ctl and
> pg_resetxlog need to be in $PATH. After running the script, restart
> postmaster and run "SELECT * FROM t2". There should be one row in the
> table, but it's empty.

I've tried this script, and superisingly  found that T2 is not empty, just 
as it should be.
Then I see how cluster is done, and found that

pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: max_prepared_transactions default ... why 5?
Next
From: "Jacky Leng"
Date:
Subject: Re: Why copy_relation_data only use wal whenWALarchivingis enabled