On Feb 8, 2005, at 9:29 AM, Vivek Khera wrote:

>
> On Feb 8, 2005, at 7:41 AM, Postgres Learner wrote:
>
>> Now the problem is that I can't figure out how to measure the time
>> taken to replicate/resync after slony daemon restarts. Basically I
>> want to know the window after which one server can safely go down
>>
>
> Check the status of the replication.  Something like this:
>
> echo 'SELECT * FROM _setname.sl_status;' | psql -U postgres -x dbname
>
> where "setname" is the name of your replication set as configured when 
> you set it up, and dbname is the name of the db, obviously.

One followup: you need to direct that query to the origin server, not 
the replica, so a suitable "-h ORIGIN_HOST" to psql would do it.  
dbname is the name of the db on the origin.