Re: Warm standby system - FATAL: the database system is starting up

Is there a way I can check what it is?

I see no reason why anything would be trying to connect, any ideas?

Could it be the autovacuum as I suggested?

Also something I omitted to point out in my original post, the
processes running on the machine (ps -ax) are as follows

3467 pts/0 S 0:00 /usr/local/pgsql/bin/postgres -D
/data/postgres/
3468 ? Ss 0:02 postgres: startup process
4858 ? S 0:00 /bin/bash /data/postgres/restore.sh
/mnt/archive/000000010000001A00000087 pg_xlog/RECOVERYXLOG
6371 ? S 0:00 sleep 1

Notice the "postgres: startup process", does that just mean we're in
WAL reading mode? Or does it mean it's not working.

I know Tom, you said it will be working, but does this extra info
change that?

Thanks
Glyn

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> writes:
> > I see in my log on the backup machine:
> > FATAL: the database system is starting up
> > Does this mean the backup is not working?
>
> No, it means something's trying to connect to the backup
> postmaster.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

___________________________________________________________
Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/