From: | ning chan <ninchan8328(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Streaming Replication |
Date: | 2013-01-15 02:05:19 |
Message-ID: | CAG0k5vAuhc-X2vNQkHjG8iw4qb_jPrN6z2YeAY=0PvJ00OU9pQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am new to PG Streaming Replication and I have a simple question hopefully
someone can answer this easily.
I setup a Primary Hot Standby and they are connecting each other without
problem.
Looking at the wal sender process, both servers pointing to the same
location as follow:
Primary:
postgres 3018 0.0 0.1 203888 3024 ? Ss 19:25 0:00 postgres:
wal sender process postgres 10.89.94.31(43169) streaming 0/D913018
Standby:
postgres 3645 0.0 0.1 212556 3096 ? Ss 19:25 0:00 postgres:
wal receiver process streaming 0/D913018
My question is when looking at the standby processes, I see startup process
as follow:
postgres 3320 0.0 0.0 203048 2084 ? Ss 18:11 0:00 postgres:
startup process recovering 00000001000000000000000D
What is that suppose to mean?
Is it really recovering some data from WAL record in the pg_xlog folder?
Thanks~
Ning
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2013-01-15 04:45:18 | Re: reducing number of ANDs speeds up query RESOLVED |
Previous Message | T. E. Lawrence | 2013-01-14 23:36:40 | Re: Linux Distribution Preferences? |