Hello List
I have been a user since 7.x version. My current server version is 8.1.2.
As many of you know the disk usage keeps growing for postgresql unless one
regularly reindex and/or fully vacuum. The problem with either method is that
they lock the tables and it is not practical for databa
Thanks all for the replies.
Mr. Wu Zong-min
---(end of broadcast)---
TIP 6: explain analyze is your friend
Dear List,
As many of you know every time one wants to upgrade to a major server version,
as I want to do now, there is a need for pg_dumpall and restore. This is a
huge undertaking and requires lots of testing and planning. I do hope that in
the future this requirement will be dropped.
I am
> OK. If you're not in a hurry, and can wait a few months 8.3 will be out.
I am moving the database to a new physical server and it makes sense to move to
the latest version now.
>>for template0 all the
>> time? Why won't pg_dump include a line to accept connection for
>> template0 just before
You are right. I have now corrected that and
I believe that should fix the problem.
>
>AFAICS it would not be issuing that unless you'd made template0
>connectable on t
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
