From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Gerhard Hintermayer <gerhard(dot)hintermayer(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: log entries while bringing a streaming replication standby server to life |
Date: | 2011-04-01 12:28:26 |
Message-ID: | AANLkTimk19ib5aykH9WBFyPBJWWJpYmknXBJFc_-eqYO@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Apr 1, 2011 at 1:04 PM, Gerhard Hintermayer
<gerhard(dot)hintermayer(at)gmail(dot)com> wrote:
> I managed to set up a streaming replication with 9.0.3. This works like a charm.
> When I pull the trigger - I mean create the trigger file ;-) - I find
> the following entries in the server log, is this normal or am I doing
> something nasty ?
>
> [ @]LOG: streaming replication successfully connected to primary
> (this is the last message from startup)
> ....
> [ @]LOG: trigger file found: /var/lib/postgresql/9.0/data/trigger
> [ @]FATAL: terminating walreceiver process due to administrator command
> [ @]LOG: redo done at 1/DC00D53C
> [ @]LOG: last completed transaction was at log time 2011-04-01
> 13:46:35.679163+02
> rsync: link_stat "/0000000100000001000000DC" (in postgresql-wals)
> failed: No such file or directory (2)
> rsync error: some files/attrs were not transferred (see previous
> errors) (code 23) at main.c(1518) [Receiver=3.0.8]
> rsync: link_stat "/00000002.history" (in postgresql-wals) failed: No
> such file or directory (2)
> rsync error: some files/attrs were not transferred (see previous
> errors) (code 23) at main.c(1518) [Receiver=3.0.8]
> [ @]LOG: selected new timeline ID: 2
> rsync: link_stat "/00000001.history" (in postgresql-wals) failed: No
> such file or directory (2)
> rsync error: some files/attrs were not transferred (see previous
> errors) (code 23) at main.c(1518) [Receiver=3.0.8]
> [ @]LOG: archive recovery complete
> [ @]LOG: autovacuum launcher started
> [ @]LOG: database system is ready to accept connections
>
> I think the error message for the WAL is normal, as the file name is
> increased until no WAL files to replay are found, and this log entries
> I also get, when I bring up the standby from a base backup.
> But what about the *.history entries ? Are they something to worry about ?
>
> BTW, my recovery.conf is:
>
> 'rsync -pog aprol1::postgresql-wals/%f %p'
> trigger_file = '/var/lib/postgresql/9.0/data/trigger'
> standby_mode = 'on'
> primary_conninfo = 'host=10.5.17.40 port=5432 user=postgres'
>
> thanks for any input.
That all looks normal to me, as far as I can tell.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Glyn Astill | 2011-04-01 12:46:03 | Index fillfactor changed in pg9? |
Previous Message | bilal ghayyad | 2011-04-01 12:11:33 | Fedora core 10: tcpip_socket = True |