Re: Why copy_relation_data only use wal when WALarchiving is enabled

From: "Jacky Leng" <lengjianquan(at)163(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Why copy_relation_data only use wal when WALarchiving is enabled
Date: 2007-10-18 06:04:15
Message-ID: ff6upn$1lof$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-10-18 06:13:19 Re: max_prepared_transactions default ... why 5?
Previous Message Bruce Momjian 2007-10-18 05:34:09 Re: Release notes introductory text

Browse pgsql-patches by date

  From Date Subject
Next Message Jacky Leng 2007-10-18 07:26:36 Re: Why copy_relation_data only use wal when WALarchiving is enabled
Previous Message ITAGAKI Takahiro 2007-10-18 03:21:13 Re: BUG #3681: fillers are NULL in pgbench