Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_switch_xlog

pg_switch_xlog

From
Démi Zsolt
Date:
Hi,

I'm trying to setup a pgpool II cluster with online replication. I can't
finish the second step of online replication because i have to user
pg_switch_xlog function, but somehow it's not exists!

I'm using Redhat and Centos server dists. . The postgresql server version is
8.1.18

On my ubuntu server I have the 8.3.9 postgresql server, and the
pg_switch_xlog function is exitst!

Do anyone know how could it be?

Thank you!

Best Regards:
    Zsolt

Re: pg_switch_xlog

From
"Kevin Grittner"
Date:
Démi Zsolt<zsdemi@gmail.com> wrote:

> I'm trying to setup a pgpool II cluster with online replication. I
> can't finish the second step of online replication because i have
> to user pg_switch_xlog function, but somehow it's not exists!
>
> I'm using Redhat and Centos server dists. . The postgresql server
> version is 8.1.18

That function was added in 8.2.

-Kevin