pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PITR partial timing
2+ messages / 2 participants
[nested] [flat]

* PITR partial timing
@ 2023-10-16 17:08 Rama Krishnan <raghuldrag@gmail.com>
  2023-10-17 13:39 ` Re: PITR partial timing Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Rama Krishnan @ 2023-10-16 17:08 UTC (permalink / raw)
  To: pgsql-general

Hi team,

I  m testing PITR

1.if I am doing full recovery what ever the new tables were create will not
be appear how to handle it

2. I have given my logs which time log I have to choose for PITR partial
recovery


2023-10-16 16:22:35 UTC [16561]: [13-1] user=postgres,db=postgresLOG:
 statement: create database pumastore;
2023-10-16 16:22:35 UTC [16561]: [14-1] user=postgres,db=postgresLOG:
 duration: 70.433 ms
2023-10-16 16:23:02 UTC [16561]: [15-1] user=postgres,db=postgresLOG:
 statement: CREATE TABLE categories (
   category integer NOT NULL,
   categoryname character varying(50) NOT NULL
);
2023-10-16 16:23:02 UTC [16561]: [16-1] user=postgres,db=postgresLOG:
 duration: 6.328 ms
2023-10-16 16:23:28 UTC [16561]: [17-1] user=postgres,db=postgresLOG:
 statement: COPY categories (category, categoryname) FROM stdin;
2023-10-16 16:23:41 UTC [16561]: [18-1] user=postgres,db=postgresLOG:
 duration: 12695.122 ms
2023-10-16 16:23:52 UTC [16561]: [19-1] user=postgres,db=postgresLOG:
 statement: table categories;
2023-10-16 16:23:52 UTC [16561]: [20-1] user=postgres,db=postgresLOG:
 duration: 0.573 ms
2023-10-16 16:24:20 UTC [16561]: [21-1] user=postgres,db=postgresLOG:
 statement: select pg_switch_wal();
2023-10-16 16:24:20 UTC [16561]: [22-1] user=postgres,db=postgresLOG:
 duration: 61.904 ms

2023-10-16 16:26:25 UTC [16561]: [23-1] user=postgres,db=postgresLOG:
 statement: drop table categories;
2023-10-16 16:26:25 UTC [16561]: [24-1] user=postgres,db=postgresLOG:
 duration: 5.165 ms

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PITR partial timing
  2023-10-16 17:08 PITR partial timing Rama Krishnan <raghuldrag@gmail.com>
@ 2023-10-17 13:39 ` Ron <ronljohnsonjr@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ron @ 2023-10-17 13:39 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

Don't write your own PITR.  Use PgBackRest, barman, etc.

On 10/16/23 12:08, Rama Krishnan wrote:
> Hi team,
>
> I  m testing PITR
>
> 1.if I am doing full recovery what ever the new tables were create will 
> not be appear how to handle it
>
> 2. I have given my logs which time log I have to choose for PITR partial 
> recovery
>
>
> 2023-10-16 16:22:35 UTC [16561]: [13-1] user=postgres,db=postgresLOG: 
>  statement: create database pumastore;
> 2023-10-16 16:22:35 UTC [16561]: [14-1] user=postgres,db=postgresLOG: 
>  duration: 70.433 ms
> 2023-10-16 16:23:02 UTC [16561]: [15-1] user=postgres,db=postgresLOG: 
>  statement: CREATE TABLE categories (
>    category integer NOT NULL,
>    categoryname character varying(50) NOT NULL
> );
> 2023-10-16 16:23:02 UTC [16561]: [16-1] user=postgres,db=postgresLOG: 
>  duration: 6.328 ms
> 2023-10-16 16:23:28 UTC [16561]: [17-1] user=postgres,db=postgresLOG: 
>  statement: COPY categories (category, categoryname) FROM stdin;
> 2023-10-16 16:23:41 UTC [16561]: [18-1] user=postgres,db=postgresLOG: 
>  duration: 12695.122 ms
> 2023-10-16 16:23:52 UTC [16561]: [19-1] user=postgres,db=postgresLOG: 
>  statement: table categories;
> 2023-10-16 16:23:52 UTC [16561]: [20-1] user=postgres,db=postgresLOG: 
>  duration: 0.573 ms
> 2023-10-16 16:24:20 UTC [16561]: [21-1] user=postgres,db=postgresLOG: 
>  statement: select pg_switch_wal();
> 2023-10-16 16:24:20 UTC [16561]: [22-1] user=postgres,db=postgresLOG: 
>  duration: 61.904 ms
>
> 2023-10-16 16:26:25 UTC [16561]: [23-1] user=postgres,db=postgresLOG: 
>  statement: drop table categories;
> 2023-10-16 16:26:25 UTC [16561]: [24-1] user=postgres,db=postgresLOG: 
>  duration: 5.165 ms
>

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-10-17 13:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-16 17:08 PITR partial timing Rama Krishnan <raghuldrag@gmail.com>
2023-10-17 13:39 ` Ron <ronljohnsonjr@gmail.com>

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