Problems with PGOPTIONS

From: Andre Schubert <andre(at)km3(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problems with PGOPTIONS
Date: 2003-01-15 10:58:26
Message-ID: 20030115115826.74472714.andre@km3.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I have a devel server where i want to turn on collector statistics.
I want to enable the collection of STATS_ROW_LEVEL for special backends
by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
After setting this variable i cant connect to my database.
Everytime the following error occurs:

Connection to database 'mydb' failed.
FATAL 1: permission denied

After unset PGOPTIONS everything works without any problems.
I have tested the same with an example C-program found under http://www.postgresql.org/idocs/
but always got the same error if i want to send additional options.

Did i make some mistakes ?

Thanks in advance for help

as

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lex 2003-01-15 12:38:17 How Copy 7.3 Schemas?
Previous Message Yudha Setiawan 2003-01-15 09:08:40 Do Something before Abort on Trigger ???