psql --quiet

Started by Leo Baltusover 10 years ago6 messagesgeneral
Jump to latest
#1Leo Baltus
Leo.Baltus@npo.nl

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been archived

--quiet does not seem to suppress it, what does?

I really hate to redirect stderr to /dev/null.

--
Leo Baltus, internetbeheerder
NPO ICT Internet Services
Bart de Graaffweg 2, 1217 ZL Hilversum
servicedesk@omroep.nl, 035-6773555

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Melvin Davidson
melvin6925@gmail.com
In reply to: Leo Baltus (#1)
Re: psql --quiet

The only other option would be to redirect to a file.
EG:

psql -q --o some_file_to_send_output_to.log

On Tue, Oct 27, 2015 at 10:16 AM, Leo Baltus <Leo.Baltus@npo.nl> wrote:

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been
archived

--quiet does not seem to suppress it, what does?

I really hate to redirect stderr to /dev/null.

--
Leo Baltus, internetbeheerder
NPO ICT Internet Services
Bart de Graaffweg 2, 1217 ZL Hilversum
servicedesk@omroep.nl, 035-6773555

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

#3David Steele
david@pgmasters.net
In reply to: Leo Baltus (#1)
Re: psql --quiet

On 10/27/15 3:16 PM, Leo Baltus wrote:

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been archived

--quiet does not seem to suppress it, what does?

This should work:

set client_min_messages='warning';

This must be done in the same session as the pg_start_backup().

--
-David
david@pgmasters.net

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Leo Baltus (#1)
Re: psql --quiet

On 10/27/2015 07:16 AM, Leo Baltus wrote:

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been archived

--quiet does not seem to suppress it, what does?

test=> set client_min_messages = 'warning';
SET

test=> show client_min_messages;
client_min_messages
---------------------
warning

test=> select pg_stop_backup();

http://www.postgresql.org/docs/9.4/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN

I really hate to redirect stderr to /dev/null.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5David Steele
david@pgmasters.net
In reply to: David Steele (#3)
Re: psql --quiet

On 10/27/15 3:32 PM, David Steele wrote:

On 10/27/15 3:16 PM, Leo Baltus wrote:

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been
archived

--quiet does not seem to suppress it, what does?

This should work:

set client_min_messages='warning';

This must be done in the same session as the pg_start_backup().

Ugh, pg_stop_backup() rather.

--
-David
david@pgmasters.net

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#6Leo Baltus
Leo.Baltus@npo.nl
In reply to: David Steele (#3)
Re: psql --quiet

Op 27/10/2015 om 15:32:46 +0100, schreef David Steele:

On 10/27/15 3:16 PM, Leo Baltus wrote:

postgresql-9.4.5

When running pg_stop_backup() psql outputs on stderr:

NOTICE: pg_stop_backup complete, all required WAL segments have been archived

--quiet does not seem to suppress it, what does?

This should work:

set client_min_messages='warning';

This must be done in the same session as the pg_start_backup().

Sweet.

Thanks David.

--
Leo Baltus, internetbeheerder
NPO ICT Internet Services
Bart de Graaffweg 2, 1217 ZL Hilversum
servicedesk@omroep.nl, 035-6773555

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general