[BUGS] BUG #4449: allows "pg_ctl restart" to terminate idle processes
The following bug has been logged online: Bug reference: 4449 Logged by: Kevin M. Kilbride Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Gentoo GNU/Linux 2008.0 Description:allows "pg_ctl restart" to terminate idle processes Details: Because a very large number of clients now habitually establish permanent connections to PGSQL in order to alleviate startup overhead, the "smart" restart mode of pg_ctl has become nearly useless because it will not terminate idle processes. It would be nice if pg_ctl were updated so that the "smart" restart mode simply terminated idle processes (a la "fast mode"), but waited for active processes to finish transactions before terminating them. This would restore "low-impact restart" functionality to those systems with clients that establish permanent connections...which is virtually everybody, these days. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #4450: Postgres do not ask for passord
The following bug has been logged online: Bug reference: 4450 Logged by: Carlos Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: linux Description:Postgres do not ask for passord Details: I have one user that is a superuser. The pg_hba.conf is set to use md5 specific to this user. When I connect the postgresql do not ask for the password. If I change the pg_hba.con to reject, it works. Do you know what is the problem? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4450: Postgres do not ask for passord
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Oct 05, 2008 at 02:42:31PM +, Carlos wrote: > > The following bug has been logged online: > > Bug reference: 4450 > Logged by: Carlos > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 > Operating system: linux > Description:Postgres do not ask for passord > Details: > > I have one user that is a superuser. The pg_hba.conf is set to use md5 > specific to this user. When I connect the postgresql do not ask for the > password. If I change the pg_hba.con to reject, it works. Do you know what > is the problem? Maybe you still have an entry like local all all trust somewhere in pg_hba.conf? Regards - -- tomás -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFI6O0kBcgs9XrR2kYRAnYHAJ40uG8aDUGazJInKvscyuIlgDDEDACfcr1Q SFXPA0Q4JW8Y04HRsstiYOc= =lIC2 -END PGP SIGNATURE- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4410: Indexes not seen right away
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > > > Does it have pg_index.indcheckxmin = true? If so, see README.HOT. > >> Yes, that was probably it. Is this worth noting in the documentation >> somewhere >> (other than the technical bowels of HOT)? Perhaps in the CREATE INDEX >> docs? ... > I have attached the scripts I used for testing. I don't think it is > worth documenting this until we have 8.4 released and people start using > it. I'm not following this, Bruce. HOT came out in 8.3, not 8.4, so why would we wait on documenting the problem? > I believe a mention in the manual would require quite complex wording. Seems something would be better than nothing. Example: "Note: In versions 8.3 and higher, indexes may not be immediately visible due to the way HOT chains work. For more information, please see ." It might be nice to upgrade README.HOT to a real documentation page as well. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200810051758 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAkjpOKkACgkQvJuQZxSWSshJ/QCgzeTdyP7tEZnYc+4GZZhyTPJ2 8IQAoJDmkbBDdGYlUoF7W3pcJSNvInW6 =aStx -END PGP SIGNATURE- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4450: Postgres do not ask for passord
On Sun, Oct 5, 2008 at 10:06 PM, <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Sun, Oct 05, 2008 at 02:42:31PM +, Carlos wrote: > > > > The following bug has been logged online: > > > > Bug reference: 4450 > > Logged by: Carlos > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.2 > > Operating system: linux > > Description:Postgres do not ask for passord > > Details: > > > > I have one user that is a superuser. The pg_hba.conf is set to use md5 > > specific to this user. When I connect the postgresql do not ask for the > > password. If I change the pg_hba.con to reject, it works. Do you know > what > > is the problem? > > Maybe you still have an entry like > > local all all trust > > somewhere in pg_hba.conf? Posting both your versions of pg_hba.conf would help. (Strip out the commented lines). Best regards, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device
