| 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: | Whole Thread | Raw Message | 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? |