Thanks for all your suggestions, I will be trying this... :)
BTJ
On Thu, 2003-07-31 at 20:27, scott.marlowe wrote:
> On Thu, 31 Jul 2003, Paul Ramsey wrote:
>
> > Voot! Not necessary! :)
> > This is a minor version upgrade, so data can remain in place. For a 7.2
> > -> 7.3 upgrade you would have to dump-and-restore.
> > My upgrade procedure is:
> > tar xvfz postgresql-7.3.4.tar.gz ; cd postgresql-7.3.4
> > ./configure ; make ; make install
> > pg_ctl stop ; pg_ctl start
>
> Actuall, it's a really good idea to do:
>
> make
> pg_ctl stop
> make install
> pg_ctl start
>
> I.e. you shouldn't have a service that's running when you do a 'make
> install'.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
