Обсуждение: Log verbosity setting (client)

Поиск
Список
Период
Сортировка

Log verbosity setting (client)

От
Dave Barter
Дата:

Is it possible to alter the pgadmin client settings for display of NOTICE/ERROR messages


I want to add log_error_verbosity=terse to prevent display of all of the context messages. 


I can set this in postgresql.conf server side and it works but pgadmin still displays the context messages client side.


For info. I am running pgadmin 1.20 on OS X



Re: Log verbosity setting (client)

От
Sanket Mehta
Дата:
Hi Dave,

You can change the logging settings for pgadmin using below mentioned menu:

File -> options -> Logging

There is a option to set No logging to prevent log messages of pgadmin.


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter <dave.barter@gmail.com> wrote:

Is it possible to alter the pgadmin client settings for display of NOTICE/ERROR messages


I want to add log_error_verbosity=terse to prevent display of all of the context messages. 


I can set this in postgresql.conf server side and it works but pgadmin still displays the context messages client side.


For info. I am running pgadmin 1.20 on OS X




Re: Log verbosity setting (client)

От
Dave Barter
Дата:

On 28 Aug 2015, at 12:58, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:

Hi Dave,

You can change the logging settings for pgadmin using below mentioned menu:

File -> options -> Logging

There is a option to set No logging to prevent log messages of pgadmin.


Thanks, but this is not what I want. I need to change the log_error_verbosity but still see the log messages


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter <dave.barter@gmail.com> wrote:

Is it possible to alter the pgadmin client settings for display of NOTICE/ERROR messages


I want to add log_error_verbosity=terse to prevent display of all of the context messages. 


I can set this in postgresql.conf server side and it works but pgadmin still displays the context messages client side.


For info. I am running pgadmin 1.20 on OS X





Re: Log verbosity setting (client)

От
Sanket Mehta
Дата:
Hi Dave,

After setting the log_error_verbosity in postgres.conf have you reload the configuration of that server?


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Fri, Aug 28, 2015 at 5:30 PM, Dave Barter <dave@phased.co.uk> wrote:

On 28 Aug 2015, at 12:58, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:

Hi Dave,

You can change the logging settings for pgadmin using below mentioned menu:

File -> options -> Logging

There is a option to set No logging to prevent log messages of pgadmin.


Thanks, but this is not what I want. I need to change the log_error_verbosity but still see the log messages


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter <dave.barter@gmail.com> wrote:

Is it possible to alter the pgadmin client settings for display of NOTICE/ERROR messages


I want to add log_error_verbosity=terse to prevent display of all of the context messages. 


I can set this in postgresql.conf server side and it works but pgadmin still displays the context messages client side.


For info. I am running pgadmin 1.20 on OS X






Re: Log verbosity setting (client)

От
Dave Barter
Дата:
Yes, to be clear the logs are working as I expect on the server.

I understand that this needs to be set client side as well. In sql you would do this via:-

\set VERBOSITY terse 

I need to do the same in pgadmin

On 28 Aug 2015, at 13:17, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:

Hi Dave,

After setting the log_error_verbosity in postgres.conf have you reload the configuration of that server?


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Fri, Aug 28, 2015 at 5:30 PM, Dave Barter <dave@phased.co.uk> wrote:

On 28 Aug 2015, at 12:58, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:

Hi Dave,

You can change the logging settings for pgadmin using below mentioned menu:

File -> options -> Logging

There is a option to set No logging to prevent log messages of pgadmin.


Thanks, but this is not what I want. I need to change the log_error_verbosity but still see the log messages


Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Wed, Aug 26, 2015 at 12:51 AM, Dave Barter <dave.barter@gmail.com> wrote:

Is it possible to alter the pgadmin client settings for display of NOTICE/ERROR messages


I want to add log_error_verbosity=terse to prevent display of all of the context messages. 


I can set this in postgresql.conf server side and it works but pgadmin still displays the context messages client side.


For info. I am running pgadmin 1.20 on OS X