Test_find_max_lsn_from_datafiles.txt

-- Test case 1
drop table if exists tbl;

create table tbl(f1 int, f2 varchar(10), f3 float, f4 char(200));

insert into tbl values(1,'postgres',2.1,'test');
insert into tbl values(3,'bangalore',4.1,'test');
insert into tbl values(2,'kiran',3.1,'test');
insert into tbl values(4,'india',5.1,'test');
checkpoint;

-- stop the server

-- run the following command
pg_resetxlog -P data

-- Validate the LSN number and WAL fileid, segid currently running in pg_xlog folder.

-- start the server and execute the following

drop table tbl;



-- Test case 2
drop table if exists tbl;

create table tbl(f1 int, f2 varchar(10), f3 float, f4 char(200));

insert into tbl values(1,'postgres',2.1,'test');
insert into tbl values(3,'bangalore',4.1,'test');
insert into tbl values(2,'kiran',3.1,'test');
insert into tbl values(4,'india',5.1,'test');
checkpoint;

-- stop the server

-- run the following command
pg_resetxlog -p base/12557 data

-- Validate the LSN number and WAL fileid, segid currently running in pg_xlog folder.

-- start the server and execute the following

drop table tbl;

-- Test case 3
drop table if exists tbl;

create table tbl(f1 int, f2 varchar(10), f3 float, f4 char(200));

insert into tbl values(1,'postgres',2.1,'test');
insert into tbl values(3,'bangalore',4.1,'test');
insert into tbl values(2,'kiran',3.1,'test');
insert into tbl values(4,'india',5.1,'test');

--Find the relfile node
select relfilenode from pg_class where relname='tbl';

checkpoint;

-- stop the server

-- run the following command with displayed refilenode 
pg_resetxlog -p base/12557/16384 data

-- Validate the LSN number and WAL fileid, segid currently running in pg_xlog folder.

-- start the server and execute the following

drop table tbl;