Thread: Infrastructure

Infrastructure

From
Poul Kristensen
Date:
Hi ! 

Is it possible to configure Postgres to "pg_log" specific "linked" to  a specific database on a specific tablepace?

A lot off databases on a lot tablespaces in the same pg_log would make i 
quit a work to solve possible problems in a specific database on a specific tabelspace.

  
Does anyone have a suggestion?

TIA 

Poul
  


Re: Infrastructure

From
Scott Mead
Date:


On Fri, Oct 7, 2016 at 8:11 AM, Poul Kristensen <bcc5226@gmail.com> wrote:
Hi ! 

Is it possible to configure Postgres to "pg_log" specific "linked" to  a specific database on a specific tablepace?

No, there's no concept of separating logs in this way.
 

A lot off databases on a lot tablespaces in the same pg_log would make i 
quit a work to solve possible problems in a specific database on a specific tabelspace.

Take a look at pgBadger.  It does all of the work for you.

--Scott

 

  
Does anyone have a suggestion?

TIA 

Poul
  





--
--
Scott Mead
Sr. Architect
OpenSCG