Glyn Astill wrote:
> What about the "postgres: startup process" ? Should this always be
> visibile on a system reading WALs? Nobody has answered that yet.
Yes. In fact it is the only process that reads WAL.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreS
Hi Artis,
I'm using debian. We discovered another postgres on the network was
trying to connect.
What about the "postgres: startup process" ? Should this always be
visibile on a system reading WALs? Nobody has answered that yet.
Glyn
--- Artis Caune <[EMAIL PROTECTED]> wrote:
> Glyn Astill wrot
Glyn Astill wrote:
> FATAL: the database system is starting up
> FATAL: the database system is starting up
> FATAL: the database system is starting up
>
>
> As far as I know theres nothing else trying to connect.
I think you are using FreeBSD, and default pg_ctl flags in rc.d contains
"-w" o
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 t
Hi chaps,
Indeed you were correct!
I enabled the good stuff in the log and sure enough one of the old
testbed machines which is running postgres and slony was trying to
connect!
However I'd never even referenced the new machine on the old testbed
so how on earth could it have been trying to conn
Glyn Astill <[EMAIL PROTECTED]> writes:
> Is there a way I can check what it is?
log_connections would help...
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Dec 2007 13:24:01 -0800 (PST)
Glyn Astill <[EMAIL PROTECTED]> wrote:
> Is there a way I can check what it is?
Change your log line prefix to show connections and ip addresses.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, ht
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/0S 0:0
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
---
Hi people,
I've set up a warm standby system using WAL shipping, partially
following the guide here (My setup ios on two physically separate
servers)
http://archives.postgresql.org/sydpug/2006-10/msg1.php
I'm using an NFS share on the main server that is then mounted in
fstab on the backup.
10 matches
Mail list logo
