pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
need meta data table/command to find query log 2+ messages / 2 participants [nested] [flat]
* need meta data table/command to find query log @ 2018-03-06 11:38 Rambabu V <ram.wissen@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Rambabu V @ 2018-03-06 11:38 UTC (permalink / raw) To: pgsql-performance Hi Team, 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. 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. Regards, Rambabu Vakada, PostgreSQL DBA. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: need meta data table/command to find query log @ 2018-03-06 13:24 Stephen Frost <sfrost@snowman.net> parent: Rambabu V <ram.wissen@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Stephen Frost @ 2018-03-06 13:24 UTC (permalink / raw) To: Rambabu V <ram.wissen@gmail.com>; +Cc: 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.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-03-06 13:24 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-03-06 11:38 need meta data table/command to find query log Rambabu V <ram.wissen@gmail.com> 2018-03-06 13:24 ` Stephen Frost <sfrost@snowman.net>
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