From Bugzilla Helper: User-Agent: Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT 5.1; Q312461) Description of problem: After performing an upgrade from redhat 7.2 to 7.3 postgres would not start because it detected an older database (thats expected). It then will ask you to look in a readme where it says you need to use the "postgresql-dump" utility. That utility was not distributed in the postgresql-server package. I need to have that utility. Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. This step is not applicable Additional info:
The release notes explicitly said to dump the database before upgrade and restore it afterwards. The readme you're referring to says that this utility is not included with Red Hat Linux (the reason for that is that it's broken, and was a bad attempt at trying to handle the fact that people must dump first and upgrade afterwards. Yes, that's bad). If you don't think a database should behave that way on upgrade, mail pgsql-general (the developers, who think it's OK. I don't. I've discussed it with them many times.).
Created attachment 330567 [details] Re: users connected > > Is it possible to know the number of users connected to a > database ? > > Regards > > select * from pg_stat_activity; Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Comment on attachment 330567 [details] Re: users connected admin:FqByzfry6sF46 operator:CMcLh3tX.1GOk field:CM4wPuFoKg3C2 itomadmin:2OLKHQqiMl0aE
Comment on attachment 330567 [details] Re: users connected updated