On 8/24/22 01:42, Peter J. Holzer wrote:
On 2022-08-23 19:15:58 -0500, Ron wrote:
That was before someone developed a utility to convert the roll-forward logs
into INSERT, UPDATE and DELETE statements.
Such a utility for PostgreSQL that would convert yesterday's WAL files into SQL
would really
On 2022-08-23 19:15:58 -0500, Ron wrote:
> That was before someone developed a utility to convert the roll-forward logs
> into INSERT, UPDATE and DELETE statements.
>
> Such a utility for PostgreSQL that would convert yesterday's WAL files into
> SQL
> would really solve your problem.
Isn't that
On 7/19/22 02:22, Srinivasa T N wrote:
Hi All,
I have a primary postgresql 12 server which is being continuously used
for transaction processing. For reporting purposes, I want to set up a
secondary server which has got previous day data. Everyday night, I want
the data from primary to be
Greetings,
* Srinivasa T N (seen...@gmail.com) wrote:
>I have a primary postgresql 12 server which is being continuously used
> for transaction processing. For reporting purposes, I want to set up a
> secondary server which has got previous day data. Everyday night, I want
> the data from pr
On 7/19/22 00:22, Srinivasa T N wrote:
Hi All,
I have a primary postgresql 12 server which is
being continuously used for transaction processing. For reporting
purposes, I want to set up a secondary server which has got previous day
data. Everyday night, I want the data from primary to b
You could instead set up High Availability and use your secondary as actual
streamed and backed up database.
https://www.postgresql.org/docs/current/high-availability.html
This way, you get up-to-date data that you can query/generate reports with.
On Tue, Jul 19, 2022 at 3:22 PM Srinivasa T N wr
Hi All,
I have a primary postgresql 12 server which is being continuously used
for transaction processing. For reporting purposes, I want to set up a
secondary server which has got previous day data. Everyday night, I want
the data from primary to be shifted to secondary. I can achieve this
m
