I would recommend that whenever you are trying to recover a database (be it WAL shipping or any other method), first change the port it is listening on, to something that your apps wouldn't assume the DB to be running on, and then start the recovery.
This way, even if there's a rogue application that you forgot to shut down, your recovering database wouldn't be bothered about it.
Then, when you are finished recovery, just change back the port to your default, and restart the server.
Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB
http://www.enterprisedb.com17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco *
http://gurjeet.frihost.netMail sent from my BlackLaptop device
On Dec 21, 2007 1:24 PM, Glyn Astill <
glynastill@yahoo.co.uk> wrote:
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@sss.pgh.pa.us > wrote:
> Glyn Astill <
glynastill@yahoo.co.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/>