Re: [BUGS] pg_autovacuum fails to run as a windows service (beta4)

2004-12-10 Thread Matthew T. O'Connor
Just a quick guess, the user account that you are logged in as while attempting to install the service, is it an admin account that has the required privileges? Steve McWilliams wrote: I am unable to run pg_autovacuum as a windows service. I am using 8.0.0beta4 on Windows XP Pro. When I execut

[BUGS] BUG #1345: pgsql character comparison bug

2004-12-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1345 Logged by: Sir Ki-Sirk Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: WINDOW 2003 Enterprise Description:pgsql character comparison bug Details: I am a C++ and pgsql

Re: [BUGS] Beta4 postgres.exe crash "...terminated by signal 5"

2004-12-10 Thread Tom Lane
"John Kennedy" <[EMAIL PROTECTED]> writes: > Was incommunicado for a while...but just to close, FYI I have verified the > bug is fixed in both Beta 5 and RC1. > Another bug I spotted in Beta4 (variables in functions having their values > changing for no apparent reason) has also been fixed in be

[BUGS] Unable to specify a log file when running pg_ctl as a windows service?

2004-12-10 Thread Steve McWilliams
I tried posting this to pgsql-hackers-win32 originally but for some reason it hasn't gone through, so I am reposting it to pgsql-bugs (though it may not be a bug but rather a missing feature): Hello, I am running Postgresql-8.0.0beta4 and would like to know if there is any recommended way of spec

[BUGS] bug at build_dummy_tuple

2004-12-10 Thread Alvaro Herrera
People, This is a weird bug. In a freshly initialized database, or just after deleting the pg_internal.init relcache file, SELECT 16854::regclass; crashes the backend. (Apparently any Oid not belonging to a regclass does the trick.) The following assertion is failed: TRAP: FailedAssertion(«!

[BUGS] Problems with "-w" option on pg_ctl.exe running as a service

2004-12-10 Thread Steve McWilliams
Hello, I tried mailing this to the pgsql-hackers-win32 list but for some reason it hasn't gone through, so I will send it to pgsql-bugs as well: I am using Postgresql-8.0.0beta4 on Windows XP Pro and have noticed that attempts to run pg_ctl as a service fail when the "-w" option is included. So

Re: [BUGS] pg_autovacuum fails to run as a windows service (beta4)

2004-12-10 Thread Steve McWilliams
Yes, when I register pg_autovacuum.exe I am logged in with admin privileges. The account I am specifying pg_autovacuum.exe to run under however is a non-admin account with "logon as service" privileges on windows xp pro. > Just a quick guess, the user account that you are logged in as while > att

[BUGS] PostgreSQL memory bug

2004-12-10 Thread [EMAIL PROTECTED]
Dear Developer Team! I use the PostgreSQL 7.4.5 on SLES9.0 and PostgreSQL 7.4.3 on SuSE 9.0 (I think this problem exists in 8.0 too). If you make 'create user' and 'alter group' sql command on existing users, and make it many times, the server doesn't release the memory. After 6-7000 calls the s

[BUGS] problem while installitn PSQL 8.0 (win)

2004-12-10 Thread Jarosław Marciniak
While installing both 8.0 beta, 5.o beta and RC1 everything seems to go ok until the following stage: Activating procedural languages, when the installation stops. PostgreSQL server's service initializes correctly. My OS is Windows XP SP2. The reason why the situation appears is that PostgreSQL

[BUGS] pg_autovacuum fails to run as a windows service (beta4)

2004-12-10 Thread Steve McWilliams
I am unable to run pg_autovacuum as a windows service. I am using 8.0.0beta4 on Windows XP Pro. When I execute the following to try to install it as a service: pg_autovacuum.exe -I -N os_user -W os_pword -U db_user -p 15432 -L my_log It fails to show up in the services list. The log file shows

Re: [BUGS] Beta4 postgres.exe crash "...terminated by signal 5"

2004-12-10 Thread John Kennedy
Hi again. Was incommunicado for a while...but just to close, FYI I have verified the bug is fixed in both Beta 5 and RC1. Another bug I spotted in Beta4 (variables in functions having their values changing for no apparent reason) has also been fixed in beta 5. You fixed it before I had time to