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, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17° 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.net Mail sent from my BlackLaptop device On Dec 21, 2007 1:24 PM, Glyn Astill <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > Glyn Astill <[EMAIL PROTECTED]> 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/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ >
