From: Stephen Frost <sfrost@snowman.net>
To: Rambabu V <ram.wissen@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: need meta data table/command to find query log
Date: Tue, 6 Mar 2018 08:24:25 -0500
Message-ID: <20180306132425.GM2416@tamriel.snowman.net> (raw)
In-Reply-To: <CADtiZxo7QHnv+A63Xnuh-XUujeRtWckwxkOCshXUqXg_Ysd0bA@mail.gmail.com>
References: <CADtiZxo7QHnv+A63Xnuh-XUujeRtWckwxkOCshXUqXg_Ysd0bA@mail.gmail.com>
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.wissen@gmail.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
Attachments:
[application/pgp-signature] signature.asc (818B, ../20180306132425.GM2416@tamriel.snowman.net/2-signature.asc)
download
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-performance@postgresql.org
Cc: sfrost@snowman.net, ram.wissen@gmail.com
Subject: Re: need meta data table/command to find query log
In-Reply-To: <20180306132425.GM2416@tamriel.snowman.net>
* 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