Re: [BUGS] BUG #4267: initdb fails

2008-06-28 Thread Dave Page
Process Explorer has. > > Frustrating. Eh? Process Monitor certainly works on Vista (although I haven't used it on SP1 yet). I used it extensively when trying to figure out a rather nasty bug issue in our privilege-shedding code a while back. -- Dave Page EnterpriseDB UK: http://www.enterprise

Re: [BUGS] BUG #4267: initdb fails

2008-06-28 Thread Dave Page
On Sat, Jun 28, 2008 at 2:16 PM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Craig Ringer wrote: > > Sorry, I just re-read your mail and noticed you said process monitor, not > explorer. I did mean Process Explorer though :-). -- Dave Page EnterpriseDB UK: http://www.enterpri

Re: [BUGS] BUG #4303: insufficient privileges

2008-07-16 Thread Dave Page
sufficient privileges to start system services > > I am loged in as an administrator. > I searched forums etc... but found no clear answers... Is there anything in the event log, or in the pg_log directory in the data directory? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -

Re: [BUGS] BUG #4312: Installation fails

2008-07-17 Thread Dave Page
vent log, or the pg_log directory under the data directory? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4312: Installation fails

2008-07-18 Thread Dave Page
ctory? Are there any PostgreSQL-related entries in the system's event log? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4312: Installation fails

2008-07-18 Thread Dave Page
t how, it's been a long time since I did so - I think it's in the machine security policy) does it log any failures in the event log? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make change

Re: [BUGS] BUG #4321: 8.3 installer shortens allowable BASE_DIR path length?

2008-08-12 Thread Dave Page
it would be a good >> thing? >> Regards, >> Bob >> >> -- >> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-bugs > > -- > Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us > EnterpriseDB http://enterprisedb.com > > + If your life is a hard drive, Christ can be your backup. + > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs > -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Need default password for the user "sa"

2008-08-26 Thread Dave Page
. It won't let you continue without entering something. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [pgsql-www] [BUGS] win32 installer page in pgfoundry is wrong

2008-08-28 Thread Dave Page
:-) It was removed a while back as it was only ever supposed to be a temporary measure to help the new windows users when we released 8.0 ('cos apparently some people thought they wouldn't be able to navigate the FTP site with the same effectiveness as *nix users). -- Dave Page Enterp

Re: [BUGS] BUG #4399: List of Servers Cleared

2008-09-04 Thread Dave Page
ly happens for me with an external keyboard. In any case, I've committed a patch to SVN that should fix this. Thanks for the report. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4411: One click install broken

2008-09-08 Thread Dave Page
want to check for any occurrences of passwords in there and mask them out first. You'll also need to use sudo to access it from the command line as it has extremely restrictive permissions by default. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs

Re: [BUGS] BUG #4502: pgAdmin Display Refresh Rate cannot be less that 7 secs

2008-10-29 Thread Dave Page
ntrol size itself to the free space, which would hopefully increase the granularity as it would be much wider. In any case, the workaround is to exit pgAdmin, and edit ~/Library/Preferences/pgadmin3\ Preferences. Set the value for 'Refreshrate' under the [frmStatus] section to whatever you

Re: [BUGS] Behavior change of FK info query

2008-11-04 Thread Dave Page
2008/11/4 Hiroshi Saito <[EMAIL PROTECTED]>: > Furthermore, I think it good to use libpq by which 8.3.5 was released. > So, it is better to pack up 08.03.0310.? > > to Dave and Inoue-san. > What do you think? 08.03.0400 sounds better to me. -- Dave Page En

[BUGS] Per database connection limit buglet

2008-11-18 Thread Dave Page
name, datconnlimit from pg_database; datname | datconnlimit ---+-- template1 | -1 template0 | -1 postgres | 50 foo | 45 test | -999 (5 rows) 8.3 seems similarly afflicted - I haven't tested any furth

Re: [BUGS] BUG #4538: shared memory

2008-11-19 Thread Dave Page
(kern.sysv.shmall * 4096) should be greater than or equal to kern.sysv.shmmax. kern.sysv.shmmax must also be a multiple of 4096. Once you have edited (or created) the file, reboot before continuing with the installation. If you wish to check the settings currently being used by the kernel, you can

Re: [BUGS] BUG #4573: download problem

2008-12-09 Thread Dave Page
in the > listing. > > http://www.postgresql.org/ftp/binary/v8.2.4/win32/ Because most, if not all of the mirrors will no longer hold those files. Adam; use 8.2.11 - it's functionally identical to 8.2.4, just has numerous bug fixes that 8.2.4 doesn't. 8.2 is not supported on Vist

Re: [BUGS] BUG #4568: sporadic error doing COUNT(*) on empty table

2008-12-14 Thread Dave Page
providing the sender with any personal >> information" > > it must have been at your end, it arrived via the [bugs] list in my inbox > just fine. It happened for me too - I guess Gmail thought it was a phishing attempt for some reason. -- Dave Page EnterpriseDB UK: http://www.ent

Re: [BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Dave Page
On Mon, Dec 15, 2008 at 3:41 PM, Henrik Svensson wrote: > > The following bug has been logged online: > > Bug reference: 4581 > Logged by: Henrik Svensson > Email address: henrik.svens...@mydata.se > PostgreSQL version: 8.3.1 > Operating system: Windows XP SP2 > Description:

Re: [BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Dave Page
to grant trusted access to the database. Then, tell the server to reload it's configuration (the pause button on the services control panel applet should do this), and login as postgres using pgAdmin or psql. Change the password to something memorable, and then put pg_hba.conf back how it was and

Re: [BUGS] BUG #4584: PostgreSQL service doesn't start

2008-12-16 Thread Dave Page
Local Settings\Temp Make sure you replace any occurrences of the password you selected with or similar before you send the log. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Status of issue 4593

2009-01-05 Thread Dave Page
; without me being notified. We don't moderate bug reports, except to weed out spam. My guess is that yours was dropped in error. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscri

Re: [BUGS] Installation problem "...The database cluster initialization failed.."

2009-01-09 Thread Dave Page
ble.com/Installation-problem-%22...The-database-cluster-initialization-failed..%22-tp21343831p21364743.html > Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscript

Re: [BUGS] Installation problem "...The database cluster initialization failed.."

2009-01-09 Thread Dave Page
know where that is on your system, but on mine its: TEMP=C:\DOCUME~1\dpage\LOCALS~1\Temp -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Installation problem "...The database cluster initialization failed.."

2009-01-09 Thread Dave Page
On Fri, Jan 9, 2009 at 11:02 AM, aerkain wrote: > > Ok, Ive found it. It appears that initdb itself is failing. Is the data directory you are trying to use an existing (but empty) directory? If so, please try deleting it and re-installing. Also, what OS is this exactly - vista? -- Dav

Re: [BUGS] Installation problem "...The database cluster initialization failed.."

2009-01-12 Thread Dave Page
but when I try to > install it still display message that "The database cluster initialisation > failed." Can you run it manually? http://www.postgresql.org/docs/8.3/interactive/app-initdb.html -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via p

Re: [BUGS] postgres 8.4

2009-01-19 Thread Dave Page
3.1 for Perl 5.10? >> >> We won't be building against Perl 5.10 until at least 8.4.0. >> > Will this be true for 8.4, now that development binaries are being > made available? I'm not entirely sure what part of my answer you're asking about the truth of, but c

Re: [BUGS] BUG #4628: services doesn't start

2009-01-26 Thread Dave Page
ix as supporting beta versions of OS's is not a priority for the project. It is being worked on with the aim of offering full support for Windows 7 RTM however. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make cha

Re: [BUGS] Per database connection limit buglet

2009-01-26 Thread Dave Page
On Mon, Jan 26, 2009 at 12:26 PM, Heikki Linnakangas wrote: > Dave Page wrote: >> >> It's possible to set a per-database connection limit of < -1, which seems >> bogus: > > Yeah. That's simple to fix, but I'm having trouble wordsmithing the

Re: [BUGS] BUG #4635: postgres.exe crash when RAISE NOTICE during debugging of PL/pgSQL function in PgAdminIII

2009-02-04 Thread Dave Page
is a bug in the plpgsql debugger; which you'll need to > report to EDB. The core postgres project does not maintain that code. For info; this issue has been tracked down and a patch is being prepared. It'll be in the 8.3.7 installers (unfortunately it's too late for 8.3.6). I

Re: [BUGS] BUG #4635: postgres.exe crash when RAISE NOTICE during debugging of PL/pgSQL function in PgAdminIII

2009-02-27 Thread Dave Page
nd errm_var->isnull are not set correspondingly. This has been fixed in HEAD already - the attached patch is for 8.3.6 (and should probably be back-patched to at least 8.2). Credit goes to Ashesh Vashi for tracking this down. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com plpgsql

Re: [BUGS] BUG #4635: postgres.exe crash when RAISE NOTICE during debugging of PL/pgSQL function in PgAdminIII

2009-02-27 Thread Dave Page
believe so. I'm not that familiar with the plugin code. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4691: Installation error

2009-03-04 Thread Dave Page
use of Windows Embedded. I'm not sure if anyone has ever tested that - and personally I have no idea whether it may be cut down in ways that may affect Postgres. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4691: Installation error

2009-03-04 Thread Dave Page
On Wed, Mar 4, 2009 at 9:47 PM, Tom Lane wrote: > Dave Page writes: >> initdb will bail out before it gets to that point if it can't find >> postgres.exe. > > Hmm.  Maybe the complaints actually come from failing to load some DLL > that postgres.exe needs. We

Re: [BUGS] BUG #4705: Software developer

2009-03-14 Thread Dave Page
bly still there as the installer aborted - can you try running the command and see if there's any more helpful errors? The should also be an installation log in %TEMP% (look for bitrock*.log) which may shed some light on what's happened. Regards, Dave. -- Dave Page EnterpriseDB UK: http:/

Re: [BUGS] BUG #4705: Software developer

2009-03-14 Thread Dave Page
nform you administrator to fetch more details. I wasn't aware that there is a policy to disable the scripting host. The installer certainly won't work without it as it uses vbscript for most of the post-installation tasks. You could either enable it, or try the MSI installer which is built usin

Re: [BUGS] BUG #4705: Software developer

2009-03-14 Thread Dave Page
ally suited for deployment across a network using Group Policy. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4705: Software developer

2009-03-14 Thread Dave Page
27;t an installer in the '-no-installer.zip' file. Try the one that doesn't say -no-installer (or -symbols). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4705: Software developer

2009-03-14 Thread Dave Page
p is the multi-language version of the installer. > I was now able to install your software without problems and test myself by > trying using it! :-) > > Thank you very much for your time and your help! No problem. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sen

Re: [BUGS] BUG #4711: no mirror found in country selection for download

2009-03-17 Thread Dave Page
scription:        no mirror found in country selection for download > Details: > > there is no mirror flag for india provided in the country selection instead > ireland flag is redundant (i mean  repeated twice in selection) Thats because we don't have any mirrors in India

Re: [BUGS] BUG #4717: Installing PostGIS via StackBuilder gives an 'Error opening file' error

2009-03-19 Thread Dave Page
nv-2.dll so the copy always succeeded. Just hit the 'Ignore' button (and possibly on libintl-3.dll as well) and everything should work fine. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make chan

Re: [BUGS] BUG #4745: Errors in installing add-ons for postgresql-8.3.msi

2009-04-01 Thread Dave Page
solved. >  - PostGIS: Skipped: libiconv-2.dll That's a known issue with the current PostGIS installer. Skipping the file should work fine. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread Dave Page
> If there is one available, I would be most appreciative if you provided the > link. > Thank you again for your assistance in this matter. The correct site is: http://yum.pgsqlrpms.org/ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-b

Re: [BUGS] BUG #4770: Error initializing slon in command line and hence running Slony

2009-04-21 Thread Dave Page
msi It should be installed into the server directory - for example, C:\Program Files\PostgreSQL\8.3. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4763: postgres service unstable, even during install

2009-04-23 Thread Dave Page
On Thu, Apr 23, 2009 at 4:30 PM, Kevin Field wrote: > Is it possible it's looking for Perl in the wrong place?  (Hence the > "No such file..." error that somehow makes it back to my Perl script?) What version of perl do you have? -- Dave Page EnterpriseDB UK: http:/

Re: [BUGS] BUG #4763: postgres service unstable, even during install

2009-04-23 Thread Dave Page
On Thu, Apr 23, 2009 at 6:43 PM, Kevin Field wrote: > On Apr 23, 12:13 pm, dp...@pgadmin.org (Dave Page) wrote: >> On Thu, Apr 23, 2009 at 4:30 PM, Kevin Field >> wrote: >> > Is it possible it's looking for Perl in the wrong place?  (Hence the >> > "N

Re: [BUGS] BUG #4763: postgres service unstable, even during install

2009-04-24 Thread Dave Page
. In practice I'm not sure how you could do that, except by possibly modifying the per-user path setting for the service account. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to y

Re: [BUGS] BUG #4763: postgres service unstable, even during install

2009-04-24 Thread Dave Page
On Fri, Apr 24, 2009 at 2:12 PM, Kevin Field wrote: > On Apr 24, 8:40 am, dp...@pgadmin.org (Dave Page) wrote: >> > >> > So I need to keep my 5.8 around currently for other uses--how can I >> > hint at the correct location for it? >> >> In theory, b

Re: [BUGS] BUG #4763: postgres service unstable, even during install

2009-04-26 Thread Dave Page
On Fri, Apr 24, 2009 at 3:09 PM, Kevin Field wrote: > On Apr 24, 9:32 am, dp...@pgadmin.org (Dave Page) wrote: >> >> I don't know if there is any way we can solve it, except by reverting >> back to 5.8 or advising users to use only one version. > > I just had an i

Re: [BUGS] BUG #4785: Installation fails

2009-05-01 Thread Dave Page
taller - the MSI or one-click? What was the error message exactly? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4763: postgres service unstable, even during install

2009-05-04 Thread Dave Page
a fix for that (and the other PLs which were similarly afflicted). I've rebuilt the installer (using the existing binaries from the last build) and uploaded it to http://developer.pgadmin.org/~dpage/. Please give it a whirl. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- S

Re: [BUGS] BUG #4785: Installation fails

2009-05-06 Thread Dave Page
instances of your chosen password first). You should be able to find it in %TEMP%. Regards, Dave. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4785: Installation fails

2009-05-06 Thread Dave Page
rk = CreateObject("WScript.Network") WScript.Echo objNetwork.Username - Thanks. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4785: Installation fails

2009-05-07 Thread Dave Page
Is your computer on a domain? - Is your user account a domain or local account? - Are you a local administrator, domain administrator or member of the power users group (or anything similar?) - Do you have permissions to write to each directory in the path C:\Program Files\PostgreSQL\8.4\data ? - Is this

Re: [BUGS] BUG #4797: Uninstall : impossible to delete some files (base...)

2009-05-08 Thread Dave Page
ch problem to uninstall it. No, quite the opposite - it's a result of very careful consideration of the requirements to maximise the security of the server. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4797: Uninstall : impossible to delete some files (base...)

2009-05-08 Thread Dave Page
gt; not know what to do. I don't know what you mean by 'user key'. There's a fundamental difference between Linux and Windows though - on Linux, the root user can do *anything*. On Windows, that is not the case for administrators. File permissions can still keep them out o

Re: [BUGS] BUG #4785: Installation fails

2009-05-12 Thread Dave Page
ou have permissions to write to each directory in the path > C:\Program Files\PostgreSQL\8.4\data ? > Yes > - Is this an NTFS filesystem? > Yes So you have permission to write to those directories, but cacls fails if you try to change the permissions on them. Weird. Magnus; any ideas o

Re: [BUGS] BUG #4808: Rules on system catalogs are allowed but not executed.

2009-05-13 Thread Dave Page
rnal catalog updates, no. Shouldn't their creation be prevented in the first place, like triggers? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-15 Thread Dave Page
processes 2009-05-15 11:40:29 BST DEBUG: reaping dead processes 2009-05-15 11:40:29 BST LOG: all server processes terminated; reinitializing 2009-05-15 11:40:29 BST DEBUG: shmem_exit(1) 2009-05-15 11:40:29 BST DEBUG: invoking IpcMemoryCreate(size=37052416) -- Dave Page EnterpriseDB UK:

Re: [BUGS] BUG #4785: Installation fails

2009-05-15 Thread Dave Page
Magnus? Ping? On Tue, May 12, 2009 at 8:56 AM, Dave Page wrote: > On Tue, May 12, 2009 at 2:17 AM, Krimstock, Roger I (Roger) > wrote: >> >> Dave, >> Should the installer be the user "postgres"?  I've installed both as >> "rik" (g

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-15 Thread Dave Page
n in a crash situation ... is Windows dumb enough to try to run > the atexit hooks of a crashed process? Hmm, the MSDN docs don't say whether or not it will. A quick test, forcing a crash by writing beyond the end of a char array shows that it does follow spec and doesn't call the ho

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-15 Thread Dave Page
On Fri, May 15, 2009 at 3:47 PM, Tom Lane wrote: > Dave Page writes: >> On Fri, May 15, 2009 at 3:23 PM, Tom Lane wrote: >>> Ho, that's pretty curious.  The first two messages are the trace of the >>> atexit hook I recently installed, which means somethin

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-15 Thread Dave Page
On Fri, May 15, 2009 at 5:26 PM, Tom Lane wrote: > Dave Page writes: >> Couldn't the callback have been called by another process though? > > Hmm, maybe, if the messages got to the log out of order.  Try > reproducing it with %p added to log_line_prefix. I've been pl

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-16 Thread Dave Page
ine 165 + 0x7 bytes C postgres.exe!__tmainCRTStartup() Line 597 + 0x17 bytes C -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Perl 5.10 vs. PG 8.4 on Win32

2009-05-16 Thread Dave Page
On Sat, May 16, 2009 at 7:28 PM, Tom Lane wrote: > Dave Page writes: >> Ooh, sneaky. I like it. Not sure it helps much though: > >> postgres.exe!atexit_callback()  Line 228      C >>       msvcr80.dll!doexit(int code=0, int quick=0, int retcaller=1)  Line 553 >>

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-16 Thread Dave Page
On Sat, May 16, 2009 at 7:37 PM, Dave Page wrote: > BTW, I'm currently attempting to build perl myself so I can get a more > helpful backtrace. Strawberry perl exhibits the same crash and doesn't > come with symbols either. Hmm, that was easier than I expected:

Re: [BUGS] Perl 5.10 vs. PG 8.4 on Win32

2009-05-17 Thread Dave Page
On Sun, May 17, 2009 at 1:01 AM, Tom Lane wrote: > Dave Page writes: >> Hmm, that was easier than I expected: > >>       perl510.dll!PerlIOUnix_refcnt_inc(int fd=0)  Line 2339  C >>       perl510.dll!PerlIOUnix_setfd(interpreter * my_perl=0x, >> _PerlIO *

Re: [BUGS] BUG #4820: PostgreSQL service won't start after using Tuning Wizard

2009-05-21 Thread Dave Page
e logs in the pg_log directory was > written that gave any clue as to why the server wouldn't start. The current version of the wizard doesn't support 8.4. An update is currently in qa. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4763: postgres service unstable, even during install

2009-05-22 Thread Dave Page
On Fri, May 22, 2009 at 9:28 AM, Kevin Field wrote: > On May 8, 9:11 am, Kevin Field wrote: >> On May 4, 2:10 pm, dp...@pgadmin.org (Dave Page) wrote: >> >> > The installer is  still looking for perl58.dll, whilst the server >> > needs perl510.dll. I've c

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread Dave Page
nd errors reading postgresql.conf that a couple of people have reported recently. Regards, Dave. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Delayed Write Failed

2009-06-02 Thread Dave Page
ou can, and then run a full disk check. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] New install Error : FATAL: could not create lock file "postmaster.pid"

2009-06-03 Thread Dave Page
n the data directory, check that postres has permission to modify that file. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4842: Doesn't install

2009-06-07 Thread Dave Page
r account on your PC, or you're using a mode designed for ISVs who need to embed the installer in their own. If you have an existing postgres user, it should always be visible in the computer management MMC snapin, but iirc the home versions of windows intentionally make it har

Re: [BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Dave Page
wnership of it first), and then try the updated installer build at http://developer.pgadmin.org/~dpage/postgresql-8.4.0-1b2-windows.exe Regards, Dave -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To

Re: [BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Dave Page
upgrade to later releases. For production use, you should use PostgreSQL 8.8.7 which is the current stable release. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4846: Error reading file: config

2009-06-10 Thread Dave Page
ry this method too) You can do that either in the psql command line, or the pgAdmin query tool. But if you're in pgAdmin anyway, it's much easier to just right-click Databases in the treeview, and select the New Database option. -- Dave Page EnterpriseDB UK: http://www.enterprise

Re: [BUGS] BUG #4861: Incorrect log_line_prefix default value in postgresql.conf

2009-06-19 Thread Dave Page
are >> using. > > The line looks like that after using the One-click installer available here > - http://www.enterprisedb.com/products/pgdownload.do. > > Probably should be sorted out by EnterpriseDB. Thanks - on it. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.co

Re: [BUGS] BUG #4785: Installation fails

2009-06-22 Thread Dave Page
enterprisedb.com/download.php?file=fd66bbc24b3b7105a22f54b11447eeea -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4881: KDE 4.2 not running any more when installing one click installer from Enterprise DB

2009-06-25 Thread Dave Page
em is in more depth. There was a library somewhere it shouldn't have been in the RC1 installer. This should be resolved for the release. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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 #4882: One-click installer crashes with certain service account passwords

2009-06-25 Thread Dave Page
percent signs, creatuser.exe crashes inside a formatted-printing routine. > > validateuser.exe suffers from this same problem. > > Workaround: for every literal percent sign in the desired password, the user > must type two percent signs. Thanks - investigating. -- Dave Page Enterp

Re: [BUGS] BUG #4886: Password Crash

2009-06-26 Thread Dave Page
idence given the amount of time this code has been out there, this was also reported yesterday :-). A fix is being tested as I type - thanks for the report. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to

Re: [BUGS] Unknown winsock error 10061

2009-07-06 Thread Dave Page
ware that's installed (particularly anti-virus or firewall packages), windows service pack level, domain membership, particular hardware? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Unknown winsock error 10061

2009-07-06 Thread Dave Page
that don't see the problem? I'll grant you those 4 are pretty different though. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Unknown winsock error 10061

2009-07-07 Thread Dave Page
by DLLs > loaded or not by the processes, I suggest you try to find out which ones > are attached to each process, when it works and when it doesn't.  Is > there a difference? Also, try removing the plugin_debugger.dll from shared_preload_libraries in postgresql.conf to eli

Re: [BUGS] Unknown winsock error 10061

2009-07-07 Thread Dave Page
s that we try putting a retry loop in PGSharedMemoryReAttach() and see if the error is a transient thing. Any other ideas? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Unknown winsock error 10061

2009-07-07 Thread Dave Page
shows up in the re-mapping of the shared memory. What distribution are you running? I'll see if I can hack up a build with the extra debugging, but I need to get the integer_datetimes option right for your database. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bu

Re: [BUGS] Unknown winsock error 10061

2009-07-07 Thread Dave Page
6963a5f It's PG84, and includes some DEBUG2's in PGSharedMemoryCreate, PGSharedMemoryReAttach and restore_backend_variables, all prefixed with *** It should work with the dependencies that come with the 8.4 installer - it'll probably be easiest to just drop in postgres.exe to an

Re: [BUGS] Unknown winsock error 10061

2009-07-08 Thread Dave Page
 the original problem. The stars are just text in the message. I tried using elog(INFO...) but that didn't work either. Not sure why, and I don't really have time to figure that out. fprintf(stderr...) does work for me however, please try this: http://uploads.enterprisedb.com/download.php?f

Re: [BUGS] Unknown winsock error 10061

2009-07-08 Thread Dave Page
ST PID:9952 LOCATION:  ShowTransactionStateRec, > .\src\backend\access\transam\xact.c:4111 > 2009-07-08 14:26:01 CEST PID:9952 DEBUG:  0: parse : SHOW > TRANSACTION ISOLATION LEVEL > 2009-07-08 14:26:01 CEST PID:9952 LOCATION:  exec_parse_message, > .\src\backend\tcop\p

Re: [BUGS] Unknown winsock error 10061

2009-07-08 Thread Dave Page
.enterprisedb.com/download.php?file=abb85b99acc1cf1668e3ff35bdb665ee It has DEBUG_VQ defined. Wojciech - can you give it a try please? Thanks Yamada-san. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription:

Re: [BUGS] BUG #4951: installation dir wrong for libpq compilation

2009-07-29 Thread Dave Page
vista c:\program files is a protected directory, and writes to > that directory may end up somewhere else in a virtual store if the program > does not have a vista-compatible manifest. We've done a lot of work to ensure that is never a problem, and after hundreds of thousands of downloads

Re: [BUGS] Malfunction in dropping database with pgAdmin

2009-08-14 Thread Dave Page
rious what is causing this. No link offhand, but what I said was that we just do a "drop database" via libpq, exactly the same as dropdb would do, or as would happen via psql. The only possible difference I could see was the database used for the connection, but that shouldn't m

Re: [BUGS] BUG #4994: Silent Installation

2009-08-19 Thread Dave Page
started and >> then stopped. Some services stop automatically if they have no work to do, >> for example, the Performance Logs and Alerts service. > > ^ This says 8.0. It gets better: > SERVICENAME="PostgreSQL Database Server 8.1" SUPERPASSWORD="cts_user

Re: [BUGS] BUG #5020: Stackbuilder not functioning

2009-08-28 Thread Dave Page
k that may be redirecting the http request someplace else? (for example, a redirect as you might get at a hotel to prompt you to accept their T&Cs before allowing you net access). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgr

Re: [BUGS] BUG #5057: Binaries missing

2009-09-15 Thread Dave Page
On Tue, Sep 15, 2009 at 9:21 AM, Andreas Kuckartz wrote: > > The following bug has been logged online: > > Bug reference:      5057 > Logged by:          Andreas Kuckartz > Email address:      a.kucka...@ping.de > PostgreSQL version: 8.2.14 > Operating system:   Windows > Description:        Binar

Re: [BUGS] Porblem running on Windows 2003 server

2009-09-24 Thread Dave Page
nning setup.bat, which meant that your system had no runtimes installed at all. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- 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] Porblem running on Windows 2003 server

2009-09-24 Thread Dave Page
mail you referenced was discussing a custom build of pgagent I made for someone to test a bug fix. It was built on an entirely different machine than any of the core postgresql binaries in the release packages. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via

Re: [BUGS] Porblem running on Windows 2003 server

2009-09-24 Thread Dave Page
them, as originally intended (as described at http://www.postgresql.org/ftp/binary/v8.3.8/win32/). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] to_char issue?

2009-09-28 Thread Dave Page
This was posted as a documentation comment: to_char(interval '0d 0h 12m 44s', 'DD HH MI SS'); with HH and HH12 will return 12 instead of 0. Testing on 8.4.1, it does seem to be the case that you get "00 12 12 44". Seems bogus to me, but am I and the OP mis

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-16 Thread Dave Page
to figure it out :-). > The patch: > > --begin patch-- :-(. Unfortunately inlining the patch in the email has munged it beyond usability. Can you resend it as an attachment please? Thanks! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-bugs m

Re: [BUGS] Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

2009-10-19 Thread Dave Page
On Fri, Oct 16, 2009 at 7:03 PM, Jesse Morris wrote: >> -Original Message- >> From: Dave Page [mailto:dp...@pgadmin.org] >> Sent: Friday, October 16, 2009 2:14 AM >> To: Jesse Morris >> Cc: pgsql-bugs@postgresql.org >> Subject: Re: [BUGS]

  1   2   3   4   5   >