On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo <postgres.arg@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
