pg_receivewal configuration issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Expert's 

I am using pg_receivewall feature to replicate wal segments on different location on same server. here is my configuration .

postgres version 11.2 

parameters in postgresql.conf

archive_mode = on 
archive_command = 'cp %p /oradbaudit/pg_archive/5400/%f' 
wal_level = replica 
max_wal_senders = 9 
max_replication_slots = 10

added entry in pg_hba.conf 

host    replication     postgres        all                        trust




I have created physical replication slot 

select * from pg_create_physical_replication_slot('5400_xlog_4_recovery');

executed pg_receivewal command ...

pg_receivewal -D /oraworkspace/pg_stream_xlog/5400 -s 5400_xlog_4_recovery -h localhost -p 5400 -U postgres

when i look at the status of physical replication slots, it shows inactive . Am i doing anything wrong?

postgres=# select * from  pg_replication_slots;
      slot_name       | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
----------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 5400_xlog_4_recovery |        | physical  |        |          | f         | f      |            |      |              |             |
(1 row)

but when i check the wal segments, those are getting created under replication slot location "/oraworkspace/pg_stream_xlog/5400"

[postgres@sl73osodbd008:/oradbaudit/pg_data_dir/pg_wal ] $ psql
psql (11.2)
Type "help" for help.

postgres=#  select * from  pg_replication_slots;
      slot_name       | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
----------------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 5400_xlog_4_recovery |        | physical  |        |          | f         | f      |            |      |              |             |
(1 row)

postgres=# select pg_walfile_name(pg_switch_wal());
     pg_walfile_name
--------------------------
 000000020000000C0000001A
(1 row)

postgres=# \! ls -lart /oradbaudit/pg_data_dir/pg_wal/|tail -5  >>>> Actual wal segement locaiton 

-rw-------.  1 postgres postgres 16777216 May  7 21:37 000000020000000C00000019
-rw-------.  1 postgres postgres 16777216 May  7 21:38 000000020000000C0000001A >>>> 
-rw-------.  1 postgres postgres    28810 May  7 21:38 nohup.out
drwx------.  2 postgres postgres      199 May  7 21:38 archive_status
-rw-------.  1 postgres postgres 16777216 May  7 21:38 000000020000000C0000001B >>> 
postgres=# \! ls -lart /oraworkspace/pg_stream_xlog/5400|tail -5     >>>>> replication wal location  
-rw-------. 1 postgres postgres 16777216 May  7 21:27 000000020000000C00000018
-rw-------. 1 postgres postgres 16777216 May  7 21:37 000000020000000C00000019
-rw-------. 1 postgres postgres 16777216 May  7 21:38 000000020000000C0000001A
drwxr-xr-x. 2 postgres postgres     4096 May  7 21:38 .
-rw-------. 1 postgres postgres 16777216 May  7 21:38 000000020000000C0000001B.partial >>>>
postgres=#


if replication slot is not active, how come wal segments are creating in replication location ?
Am i doing anything wrong ?

please advise ..


Thank you... 

--
Regards,

#!  Pavan Kumar
----------------------------------------------
-
Sr. Database Administrator..!

NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux