I'd like to read individual rows from the pages as they are updated and stream them to a server to create a copy of the data. The data will be rewritten to columnar format for analytics queries.
On Tue, Mar 19, 2024 at 7:58 PM Alexander Korotkov <aekorot...@gmail.com> wrote: > Hi > > On Tue, Mar 19, 2024 at 4:23 PM Sushrut Shivaswamy > <sushrut.shivasw...@gmail.com> wrote: > > I'm trying to build a postgres export tool that reads data from table > pages and exports it to an S3 bucket. I'd like to avoid manual commands > like pg_dump, I need access to the raw data. > > > > Can you please point me to the postgres source header / cc files that > encapsulate this functionality? > > - List all pages for a table > > - Read a given page for a table > > > > Any pointers to the relevant source code would be appreciated. > > Why do you need to work on the source code level? > Please, check this about having a binary copy of the database on the > filesystem level. > https://www.postgresql.org/docs/current/backup-file.html > > ------ > Regards, > Alexander Korotkov >
