pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Igor Korot <ikorot01@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Fwd: Log file
Date: Wed, 31 Oct 2018 08:00:21 +0100
Message-ID: <233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at> (raw)
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>

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





view thread (26+ messages)  latest in thread

Message-ID: <233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at>
Permalink:  ../233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at/
Also on:    postgresql.org/message-id/233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: laurenz.albe@cybertec.at, ikorot01@gmail.com, tgl@sss.pgh.pa.us
  Subject: Re: Fwd: Log file
  In-Reply-To: <233be564bfa8cba4084e8d1a031880b777b43d37.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox