Re: need meta data table/command to find query log

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Rambabu V <ram(dot)wissen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: need meta data table/command to find query log
Date: 2018-03-06 13:24:25
Message-ID: 20180306132425.GM2416@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greetings,

These questions are not appropriate for the 'performance' mailing list
but should be either on 'admin' or 'general'. Please use the
appropriate list for asking questions in the future.

* Rambabu V (ram(dot)wissen(at)gmail(dot)com) wrote:
> Please help us to get the query log details from meta data table/command in
> postgresql. aw we are not maintaining log files more than 2 days due to
> lack of space.

It's entirely unclear what you are asking for here when you say "meta
data." Information about tables is stored in the system catalog,
particularly the "pg_class" and "pg_attribute" tables, but that's
independent from the WAL. To read the WAL files, you can use pg_waldump
(or pg_xlogdump on older versions), though that's not 'meta' data.

> And also please provide document or sop for database upgrade from 9.3 to
> 9.6, as our database size was 4.5 tb and having table spaces as well. as it
> was production database system we do-not want to take any risk, please help
> us on this as well.

You'll likely want to use pg_upgrade to perform such an upgrade:

https://www.postgresql.org/docs/10/static/pgupgrade.html

Thanks!

Stephen

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rambabu V 2018-03-06 13:27:18 Re: by mistake dropped physical file dropped for one table.
Previous Message Stephen Frost 2018-03-06 13:21:24 Re: by mistake dropped physical file dropped for one table.