Skip site navigation (1) Skip section navigation (2)

Re: Where is pg_create_restore_point funciton in 9.1a2 ?

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Where is pg_create_restore_point funciton in 9.1a2 ?
Date: 2011-06-22 09:14:09
Message-ID: BANLkTinmnUfdnDym-uf7ezDFqNVfksm4cg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com> wrote:
> I'm still finding pg_create_restore_point in 9.1a2 documentation:
> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>
> But I've compiled that version and I didn't found it:
>
> postgres=# \df *create_restore*
>                       List of functions
>  Schema | Name | Result data type | Argument data types | Type
> --------+------+------------------+---------------------+------
> (0 rows)
>

the function exists... and it should appear, it does for me

postgres=# \df *create_re*
                                   List of functions
   Schema   |          Name           | Result data type | Argument
data types |  Type
------------+-------------------------+------------------+---------------------+--------
 pg_catalog | pg_create_restore_point | text             | text
        | normal
(1 row)

postgres=# select pg_create_restore_point('jcm');
ERROR:  WAL level not sufficient for creating a restore point
HINT:  wal_level must be set to "archive" or "hot_standby" at server start.
STATEMENT:  select pg_create_restore_point('jcm');

>
> By the way, another issue that I found is when I execute \df. It
> doesn't display anything (I must
> force with * to do that).

i can confirm this

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to

Responses

pgsql-bugs by date

Next:From: Hartmut Hardy RaschickDate: 2011-06-22 10:54:13
Subject: BUG #6072: VPATH build fails in src/backend/port for src tarball, errcodes.h not found
Previous:From: Emanuel CalvoDate: 2011-06-22 08:28:51
Subject: Where is pg_create_restore_point funciton in 9.1a2 ?

pgsql-general by date

Next:From: simonDate: 2011-06-22 09:42:42
Subject: Re: Error - could not get socket error status: Invalid argument
Previous:From: Grzegorz JaśkiewiczDate: 2011-06-22 09:13:27
Subject: Re: data compression in protocol?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group