Christophe Chauvet wrote:
> Hi Dave
>
> The only solution i see to beat this problem is to add a delay before connect
> to the PostgreSQL
> Database with a new option (for exemple -d).
>
> options
> -d <delay> Add delay (in second) before connect to the database.
>
> pgAgent INSTALL pgAgent -d 10 -u postgres ....
>
> What do you think about this ?
I expect to fix the problem properly in PostgreSQL tomorrow - I'm just
finishing off a patch to pg_ctl that implements the -w (wait) option in
pg_ctl when run in service mode. This will ensure that it doesn't report
the service as running until recovery has completed and connections are
possible.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
