0 like 0 dislike
516 views
asked in PostgreSQL Database Forum by (4k points)  
tdba@hostanme:/data/tdba> ps -ef|grep postgres
tdba   3493     1  0 May02 ?        00:00:03 /opt/9.6.3/bin/postgres -D /data/tdba
tdba   3494  3493  0 May02 ?        00:00:00 postgres: logger process
tdba   3496  3493  0 May02 ?        00:00:00 postgres: checkpointer process                                                                                                                                                                
tdba   3497  3493  0 May02 ?        00:00:00 postgres: writer process
tdba   3498  3493  0 May02 ?        00:00:02 postgres: wal writer process
tdba   3499  3493  0 May02 ?        00:00:03 postgres: autovacuum launcher process
tdba   3500  3493  0 May02 ?        00:00:01 postgres: archiver process   failed on 00000001000000000000008C

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (4k points)  

Issue is directory not found in tdba instead of given archive_logs here it is archive_log  after that  created directory of archive_logs Now issue is fixed without restarting the server.
 

postgres=# show archive_command;
                  archive_command
----------------------------------------------------
cp %p /arch/tdba/archive_logs/%f
(1 row)

tdba@hostanme:/data/tdba> ps -ef|grep postgres
pginsta   3493     1  0 May02 ?        00:00:03 /opt/9.6.3/bin/postgres -D /data/tdba
pginsta   3494  3493  0 May02 ?        00:00:00 postgres: logger process
pginsta   3496  3493  0 May02 ?        00:00:00 postgres: checkpointer process
pginsta   3497  3493  0 May02 ?        00:00:01 postgres: writer process
pginsta   3498  3493  0 May02 ?        00:00:02 postgres: wal writer process
pginsta   3499  3493  0 May02 ?        00:00:03 postgres: autovacuum launcher process
pginsta   3500  3493  0 May02 ?        00:00:01 postgres: archiver process   last was 000000010000000000000095
pginsta   3501  3493  0 May02 ?        00:00:05 postgres: stats collector process

 

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
0 answers
...