Re: "Other users on Template1" when there aren't any

"John D. Tiedeman" <jdtiede(at)sstar(dot)com> writes:
> I have 8.0 on a Linux machine and a w2k box but only have this
> problem on w2k. I have rebooted in case an earlier effort left a loose
> end but that didn't help. I haven't been able to create a db at all on
> the w2k but have one on Linux. This is my first experience with pgsql on
> win32.

You haven't actually said what the problem was ...

Doing my best Carnac the Magnificent impersonation, I'm going to guess
that you have some problem with two successive connections to template1
wherein the first backend hasn't managed to exit by the time the second
one checks for concurrent connections. But since you have not told us
what exactly you are doing, that's strictly a guess.

There are some tips at
http://www.postgresql.org/docs/8.0/static/bug-reporting.html
about creating useful problem reports.

regards, tom lane