Message-ID: <233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at>
Subject: Re: Fwd: Log file
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Igor Korot <ikorot01@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: Wed, 31 Oct 2018 08:00:21 +0100
In-Reply-To: 
 <CA+FnnTzHHi4R2gM--iXteQDpGw4pDp9ci8nVnVUWNFG-CKazRw@mail.gmail.com>
References: 
	<CA+FnnTy4b=gSVw+dJwijoiFoeQNQMKZq65feupZgJh4-uuyKVQ@mail.gmail.com>
	 <CA+FnnTw5Z=XoV=GyeC0-x85Q_MdJ0+hr6UD1Y5=NByG4SfzxyQ@mail.gmail.com>
	 <18469.1540839366@sss.pgh.pa.us>
	 <CA+FnnTwb4V++4WRQj1vCBQ0Pb_NPR3pxjJgyGpuCXHOhFuXpmQ@mail.gmail.com>
	 <23733.1540847335@sss.pgh.pa.us>
	 <CA+FnnTy3w426agu3pxk2Yx_Og_682UaqZg2bcyc8mZ0W1sfqNw@mail.gmail.com>
	 <CA+FnnTzHHi4R2gM--iXteQDpGw4pDp9ci8nVnVUWNFG-CKazRw@mail.gmail.com>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

Igor Korot wrote:
> Now is there a command to flush the log - delete the content of it?

No, managing the logs is outside of PostgreSQL's responsibility.

But it shouldn't be a problem to do this outside the database.
Of course you could write a funtion in PostgreSQL that uses one
of the "untrusted" procedural languages to do it for you.

> All I'm looking for in the log are DDL commands - CREATE/ALTER/DELETE ones.

You mean DROP, right?

You can set "log_statement = 'ddl'" for that.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com