[GENERAL] PostgreSQL Code of Conduct Draft
The revised draft of the proposed Code of Conduct for the PostgreSQL community is at https://wiki.postgresql.org/wiki/Code_of_Conduct. This updated draft incorporates comments and suggestions from the community received at PgCon Ottawa and subsequent discussion. We will not be monitoring the mailing lists for comments or suggested changes. If you have comments, please email them to coc-comme...@postgresql.org no later than 2017-03-05, 11:59PM GMT for the committee to review. Regards, Dave. -- Dave Page PostgreSQL Core Team http://www.postgresql.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?
Sandeep, how much effort is it to do this? On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer cr...@2ndquadrant.com wrote: Hi I've just noticed that the EDB-produced installer for Pg omits a number of components required to build things that're fully compatible with libpq if they also use some of the same libs as libpq, like libintl, openssl, etc. The specific case of interest to me is psqlODBC, which I've been doing some work on recently. I just realised that a crash I've been encountering is caused by linking to the OpenSSL binaries from http://slproweb.com/products/Win32OpenSSL.html when libpq is using its own different OpenSSL. libeay32.lib is not in the Pg binary distribution for Windows so it's not possible to link directly to the same libeay32.dll that libpq uses. Ideally, every .dll that's shipped should be accompanied by the corresponding .lib, so people compiling against PostgreSQL can use the same OpenSSL, libintl, etc that were used when compiling Pg. The headers for those libraries should really also be bundled, e.g. have an include\openssl dir. That might add a little weight to the installer package, but probably not much - and that's clearly not a huge concern given that it already includes some fat .pdb debug symbols. If trimming the installer is a concern, it'd be reasonable to split the .lib files, includes, and pdb files into a separate PostgreSQL development component. The biggest issue - the missing libintl.h - was fixed a while ago, so it's possible to compile simple programs against libpq and have them work properly. Now it's only an issue if your app also needs to use OpenSSL, gettext, etc its self. Thoughts? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?
I think the point is that Craig is asking for the headers and import libraries for all deps, not just OpenSSL. On Thu, Jul 3, 2014 at 9:35 AM, Sandeep Thakkar sandeep.thak...@enterprisedb.com wrote: Shouldn't be a big deal. Just a change in the installer file and the build script. Do we want to add all the OpenSSL header files? That must be around 75.. On Thu, Jul 3, 2014 at 1:24 PM, Dave Page dp...@pgadmin.org wrote: Sandeep, how much effort is it to do this? On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer cr...@2ndquadrant.com wrote: Hi I've just noticed that the EDB-produced installer for Pg omits a number of components required to build things that're fully compatible with libpq if they also use some of the same libs as libpq, like libintl, openssl, etc. The specific case of interest to me is psqlODBC, which I've been doing some work on recently. I just realised that a crash I've been encountering is caused by linking to the OpenSSL binaries from http://slproweb.com/products/Win32OpenSSL.html when libpq is using its own different OpenSSL. libeay32.lib is not in the Pg binary distribution for Windows so it's not possible to link directly to the same libeay32.dll that libpq uses. Ideally, every .dll that's shipped should be accompanied by the corresponding .lib, so people compiling against PostgreSQL can use the same OpenSSL, libintl, etc that were used when compiling Pg. The headers for those libraries should really also be bundled, e.g. have an include\openssl dir. That might add a little weight to the installer package, but probably not much - and that's clearly not a huge concern given that it already includes some fat .pdb debug symbols. If trimming the installer is a concern, it'd be reasonable to split the .lib files, includes, and pdb files into a separate PostgreSQL development component. The biggest issue - the missing libintl.h - was fixed a while ago, so it's possible to compile simple programs against libpq and have them work properly. Now it's only an issue if your app also needs to use OpenSSL, gettext, etc its self. Thoughts? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sandeep Thakkar Senior Software Engineer Phone: +91.20.30589505 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?
It shouldn't be an issue for psqlODBC itself as users of that link against the driver manager not the driver. I suspect what Craig is trying to do is build the driver against our server installation, which means he may need OpenSSL now, and other dependencies in the future (and don't forget we support platforms other than Windows). On Thu, Jul 3, 2014 at 10:35 AM, Sandeep Thakkar sandeep.thak...@enterprisedb.com wrote: Okay. For psqlODBC, the dependencies only include gettext and OpenSSL. On Thu, Jul 3, 2014 at 2:08 PM, Dave Page dp...@pgadmin.org wrote: I think the point is that Craig is asking for the headers and import libraries for all deps, not just OpenSSL. On Thu, Jul 3, 2014 at 9:35 AM, Sandeep Thakkar sandeep.thak...@enterprisedb.com wrote: Shouldn't be a big deal. Just a change in the installer file and the build script. Do we want to add all the OpenSSL header files? That must be around 75.. On Thu, Jul 3, 2014 at 1:24 PM, Dave Page dp...@pgadmin.org wrote: Sandeep, how much effort is it to do this? On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer cr...@2ndquadrant.com wrote: Hi I've just noticed that the EDB-produced installer for Pg omits a number of components required to build things that're fully compatible with libpq if they also use some of the same libs as libpq, like libintl, openssl, etc. The specific case of interest to me is psqlODBC, which I've been doing some work on recently. I just realised that a crash I've been encountering is caused by linking to the OpenSSL binaries from http://slproweb.com/products/Win32OpenSSL.html when libpq is using its own different OpenSSL. libeay32.lib is not in the Pg binary distribution for Windows so it's not possible to link directly to the same libeay32.dll that libpq uses. Ideally, every .dll that's shipped should be accompanied by the corresponding .lib, so people compiling against PostgreSQL can use the same OpenSSL, libintl, etc that were used when compiling Pg. The headers for those libraries should really also be bundled, e.g. have an include\openssl dir. That might add a little weight to the installer package, but probably not much - and that's clearly not a huge concern given that it already includes some fat .pdb debug symbols. If trimming the installer is a concern, it'd be reasonable to split the .lib files, includes, and pdb files into a separate PostgreSQL development component. The biggest issue - the missing libintl.h - was fixed a while ago, so it's possible to compile simple programs against libpq and have them work properly. Now it's only an issue if your app also needs to use OpenSSL, gettext, etc its self. Thoughts? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sandeep Thakkar Senior Software Engineer Phone: +91.20.30589505 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sandeep Thakkar Senior Software Engineer Phone: +91.20.30589505 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
[GENERAL] Anyone from the US coming to FOSDEM?
If you're from the US and are planning to come to FOSDEM in February, can you ping me please? Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: Fw: [GENERAL] Postgresql on Windows 8
Hi - Original Message - From: Heine Ferreira Sent: 11/21/12 01:53 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Postgresql on Windows 8 Hi Do you have any plans to put the Windows version of Postgresql on the Windows 8 app store? Also for PGAdmin and database drivers? No, there are no plans to do so. Aparantly there are major issues with sideloading in windows 8. We've seen no problems in our testing, and I haven't seen anything on the -bugs list. If you see any specific issues, please report them there. Thanks. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] EDB installer should check for valid %COMSPEC%
Hi On Mon, Nov 19, 2012 at 4:29 AM, Craig Ringer cr...@2ndquadrant.com wrote: Hi folks Some recent discussion on Stack Overflow has revealed another exciting way for Windows computers to be subtly broken. For as yet unknown reasons - probably related to security/virus scanner software, since everything else seems to be - some Windows machines have an invalid COMSPEC environment variable. Two variants have been sighted in the wild: %SystemRoot%\system32\cmd.exe; (note the trailing semicolon), and: C:\Windows\System32 Both will produce the delightfully helpful initdb failure: initdb: could not execute command C:/Program Files/PostgreSQL/9.2/bin/postgres.exe --boot -x1 -F : No error while running: cscript //NoLogo C:\Program Files\PostgreSQL\9.2/installer/server/initcluster.vbs NT AUTHORITY\NetworkService postgres C:\Program Files\PostgreSQL\9.2 C:\Program Files\PostgreSQL\9.2\data 5432 DEFAULT which will exit with: Script exit code: 1 In the one I was looking into, fixing COMSPEC in the System control panel's Environment Variables page by removing the trailing semicolon corrected the issue. It can be verified as correct by opening a new command prompt after you've changed the variable (not just re-using an existing already-open one) and running: %COMSPEC% /C echo test ok which should print: test ok not something like: 'C:\Windows\System32\cmd.exe;' is not recognized as an internal or external command, operable program or batch file. Since I can find several reports of this spanning over a couple of years, I'd love to see a test for this integrated into the EDB installer. Just verify that popen() actually works before running the initdb script, and if it doesn't, check %COMSPEC% to see if it really points to cmd.exe . Interesting - thanks for the info Craig. Sandeep; can you please look into adding such a check to the installer. We already test the VBscript interpreter, so this should go in the same place. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file?
[Please keep the mailing list CC'd] On Fri, Aug 17, 2012 at 11:52 AM, Loughrey, Hugh hugh.lough...@hoopleltd.co.uk wrote: Hi Dave, Thanks for the message below. The script you forwarded looks to be for an instance in which the DB is running of a windows box, apologies I should have mentioned, we currently run PostgreSQL on a Linux box. Does this mean calling pg_ctl is not an option? Or do we need to install additional drivers? pg_ctl only checks the status of an instance running on the local machine. To check on a remote linux box from windows using pg_ctl, you'd have to run pg_ctl on the linux box, probably over SSH (look for Putty for an SSH client for Windows). An easier option might be to run a psql command on the remote database. Just run something like SELECT 1 and check you actually get a 1 back, and not a connection error. We'd be using FME to push data from other databases into PostgreSQL, however before running our FME scripts we'd want to check the DB is up and running. If the DB is running, then run the FME scripts, if not...don't run the FME scripts. All of this needs to be controlled via a windows server 2008 box. I appreciate your help. Regards Hugh -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: 15 August 2012 16:30 To: Bruce Momjian Cc: Loughrey, Hugh; pgsql-general@postgresql.org Subject: Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file? On Wed, Aug 15, 2012 at 4:04 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Aug 15, 2012 at 09:52:17AM +, Loughrey, Hugh wrote: Hi All, I want to write a MS-DOS command to check that the PostgreSQL database is up and running and able to accept data being pushed to it. From a bit of reading I’ve identified the pg_ctl status command, but can this be incorporated into a *.bat file and can the resulting status be recorded in a *.txt file? If so does anyone have a command which would enable this? As I remember it is pretty tricky to call pg_ctl from a Windows batch file. I know the Windows installers do it somehow --- you might want to downlaod it and see if you can find the shell script they use. Dave Page might know more --- CC'ing him. You shouldn't try to start/stop the server with pg_ctl if it's configured to run as a service (use net start xxx, net stop xxx for that), but you can check the status: C:\C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe -D C:\Program Files\PostgreSQL\9.2\data status pg_ctl: server is running (PID: 1040) C:/Program Files/PostgreSQL/9.2/bin/postgres.exe -D C:/Program Files/PostgreSQL/9.2/data C:\net stop postgresql-x64-9.2 The postgresql-x64-9.2 service is stopping. The postgresql-x64-9.2 service was stopped successfully. C:\C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe -D C:\Program Files\PostgreSQL\9.2\data status pg_ctl: no server running -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company “Any opinion expressed in this e-mail or any attached files are those of the individual and not necessarily those of Hoople Ltd. You should be aware that Hoople Ltd. monitors its email service. This e-mail and any attached files are confidential and intended solely for the use of the addressee. This communication may contain material protected by law from being passed on. If you are not the intended recipient and have received this e-mail in error, you are advised that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please contact the sender immediately and destroy all copies of it. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PG Installer - Licensing Issues
On Wed, Aug 15, 2012 at 3:17 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Aug 15, 2012 at 11:45:21AM +0100, Andrew Hastie wrote: As I understand it, I am allowed to redistribute Postgres so long as I include the copyright notice plus paragraphs as detailed on http://www.postgresql.org/about/licence/. What I want to confirm is that the one-click installer (which I understand was supplied by EnterpriseDB) can also be redistributed such that I can bundle Postgres with my product, and also use the non-interactive installer (http://www.enterprisedb.com/resources-community/pginst-guide#interactive) such that I can make the installation as easy as possible for my users. I've scanned the EnterpriseDB site, but I see nothing that confirms or denies my thoughts. I dug into this and found this at the top of the installation notes file that is created once you install the product, at /opt/PostgreSQL/9.1/doc/installation-notes.html: Legal Bits First the boring legal stuff. The software bundled together in this package is released under a number of different Open Source licences. By using any component of this installation package, you agree to abide by the terms and conditions of it's licence. The PostgreSQL Server and pgAdmin are released under the PostgreSQL License. This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit. (http://www.openssl.org/) I also found this: http://www.enterprisedb.com/products-services-training/products-overview/licensing http://www.enterprisedb.com/ba/foss-licenses Now, this doesn't directly mention the installer, which is gone at the time this is installed. I know it has the same license as Postgres, but where is that documented. Dave, any ideas? The installer code uses the PostgreSQL licence. I'll clarify the installation notes doc. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file?
On Wed, Aug 15, 2012 at 4:04 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Aug 15, 2012 at 09:52:17AM +, Loughrey, Hugh wrote: Hi All, I want to write a MS-DOS command to check that the PostgreSQL database is up and running and able to accept data being pushed to it. From a bit of reading I’ve identified the pg_ctl status command, but can this be incorporated into a *.bat file and can the resulting status be recorded in a *.txt file? If so does anyone have a command which would enable this? As I remember it is pretty tricky to call pg_ctl from a Windows batch file. I know the Windows installers do it somehow --- you might want to downlaod it and see if you can find the shell script they use. Dave Page might know more --- CC'ing him. You shouldn't try to start/stop the server with pg_ctl if it's configured to run as a service (use net start xxx, net stop xxx for that), but you can check the status: C:\C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe -D C:\Program Files\PostgreSQL\9.2\data status pg_ctl: server is running (PID: 1040) C:/Program Files/PostgreSQL/9.2/bin/postgres.exe -D C:/Program Files/PostgreSQL/9.2/data C:\net stop postgresql-x64-9.2 The postgresql-x64-9.2 service is stopping. The postgresql-x64-9.2 service was stopped successfully. C:\C:\Program Files\PostgreSQL\9.2\bin\pg_ctl.exe -D C:\Program Files\PostgreSQL\9.2\data status pg_ctl: no server running -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [pgeu-general] FOSDEM booth volunteer
On Sun, Jan 29, 2012 at 7:33 PM, Andreas 'ads' Scherbaum adsm...@wars-nicht.de wrote: Hi all, if you are attending FOSDEM next week in Brussels and are willing to help on the PostgreSQL booth, please respond to me directly. We are planning to print badges for everyone. In your reply, please include any (human) language which you are familiar with. There will be a small icon with the language on your badge. I'll be there as you know. I speak English (UK, none of that US variant :-p ). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Wednesday, October 5, 2011, Thomas Kellerer spam_ea...@gmx.net wrote: Dave Page, 04.10.2011 21:46: We updated our build system to use BitRock 7 today (for unrelated reasons) which has new features for ACL management. We're going to investigate replacing cacls/icacls with those features tomorrow and will create some test builds ASAP. If you can provide the test builds publicly, I will be happy to test them and see if that behaves differently on my system. Thanks, we will. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
[GENERAL] PostgreSQL Conference Europe: Are you ready?
PostgreSQL Conference Europe 2011 (http://2011.pgconf.eu/) starts 2 weeks from today in the beautiful city of Amsterdam in the Netherlands. This is the fourth annual conference hosted by PostgreSQL Europe, following on from extremely successful events in Prato (Italy), Paris and Stuttgart, and is aimed at developers, DBAs, technologists and decision makers either using, or considering using the world's most advanced Open Source database. This year we have four days on the schedule, with a kick-off day of training sessions hosted by respected PostgreSQL developers such as Greg Smith, Bruce Momjian, Magnus Hagander, Guillaume Lelarge and more. Topics will cover performance tuning, application development, database administration, replication high availability and geospatial. The training sessions are available on their own, or as part of a regular conference attendance at additional - but very reasonable - cost. We had a record number of talk proposals submitted this year but we've resisted the urge to host even more sessions in parallel - in fact we've reduced the number of parallel sessions to three as we all know how frustrating it can be when more than one that you want to see are at the same time. Instead we've extended the conference by a day to accomodate over 40 different sessions, which has the added bonus of allowing an additional night of social activities - always a great way to discuss the latest technologies, trends and ideas with other Postgres users over a beer or two. We've got a great range of topics for this year, covering new features in PostgreSQL 9.1 and beyond, developing applications, running Postgres in the cloud, hacking PostgreSQL internals, tools and add-on products and managing large databases, presented by a wide cross-section of users and developers, including a number of this year's Google Summer of Code students who will talk about their work. You can view the complete schedule on the conference website: http://www.postgresql.eu/events/schedule/pgconfeu2011/ Our opening keynote this year will be presented by Ram Mohan, EVP and CTO of Afilias who manage the .info, .org and .mobi top level domains using Postgres. Ram will be discussing the business decisions and strategy around their use of PostgreSQL. Our closing keynote will be presented by Ed Boyajian, President and CEO of EnterpriseDB who will discuss PostgreSQL's role in the post-Oracle era. So, if you haven't done so already, head on over to the website at http://2011.pgconf.eu/registration/ to register as an attendee to avoid missing out on what promises to be an outstanding conference in an fantastic location. See you in Amsterdam! -- Dave Page PostgreSQL Europe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Mon, Oct 3, 2011 at 2:15 PM, Dave Page dp...@pgadmin.org wrote: On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer spam_ea...@gmx.net wrote: Dave Page wrote on 03.10.2011 10:11: Karl; can you please provide precise details of your Windows version, and anything unusual about your disk configuration? I know this doesn't happen on any of the installations of Windows 7 that we use for testing (which tend to be the MSDN builds, running on local NTFS disks), so I wonder if there's an icacls bug in a specific build or rev of Windows, or when used on a certain type of filesystem. I have reported this as well some weeks ago. For me this happened on a Windows7 64 bit system that is part of a domain (all current MS patches applied) UAC is turned off, I was logged in as a local administrator (*not* a domain administrator). I have a ProcessMonitor trace that shows the behaviour of what icacls is doing when started by the installer. It is available here: http://www.sql-workbench.net/icacls_trace.zip Thanks Thomas. That certainly doesn't look like it's doing what it was told to :-s We've been looking at this today, and whilst we haven't found icacls changing any ACLs that it shouldn't, we have no seen it reading the ACLs of files on the entire disk. I've also found a couple of similar reports on the net. We updated our build system to use BitRock 7 today (for unrelated reasons) which has new features for ACL management. We're going to investigate replacing cacls/icacls with those features tomorrow and will create some test builds ASAP. Oh, the joys of supporting Windows :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Wednesday, October 5, 2011, Craig Ringer ring...@ringerc.id.au wrote: On 10/05/2011 03:46 AM, Dave Page wrote: Oh, the joys of supporting Windows :-) It's funny: for an OS with so relatively few flavours and versions, the number of quirks and bizarre behaviors is quite remarkable. I guess the text matrix isn't small, though: Windows XP / Vista / 7 / [8] You forgot 2003, 2003R2, 2008 and 2008R2 32-bit / 64-bit Basic / Home / Pro or Business / Enterprise / Ultimate / Embedded Standard, Enterprise and Datacenter for the server editions. On a domain / standalone Local admin account / non-admin account / UAC admin account Domain admin. [too many different antivirus products to list] Service packs *endless* possible group policy configurations ... so it's not too surprising to see hard-to-reproduce weirdness popping up. That last one is one of the worst - I've seen all sorts of weird policies from government users and large companies - they can take a *lot* of figuring out. That's why we have 4 developers who work on the installers (not all the time of course, but often in busy bursts for a few days or more, and often in parallel, like today with 3 guys working on this issue), along with 2 QA guys when we're building releases. It's easy to think building and maintaining installers is easy - unfortunately, that can be very far from the case for a product like Postgres. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Mon, Oct 3, 2011 at 8:59 AM, Magnus Hagander mag...@hagander.net wrote: On Fri, Sep 30, 2011 at 15:34, Karl Wright daddy...@gmail.com wrote: I saw a thread where somebody saw icacls.exe being called by the one-click installer. I'm having the same thing - the installer has been running for 45 minutes now and is basically going to have to be stopped because I'm out of time waiting for it. Looking at process monitor, it is clear that icacls.exe is going through every file on the entire system and changing its permissions. The process tree indicates that it is a child of the installer, and that it is running the command: icacls C:\ /grant kawright:RX Clearly this won't do at all and should be considered a severe installer bug. If it does, it certainly sounds like a very bad bug. However, according to the documentation for icacls (http://technet.microsoft.com/en-us/library/cc753525(WS.10).aspx), you should use /t to get it to traverse into subdirectories, and clearly it's not doing that. So I wonder why it would go across the whole filesystem - might tbere be a bug in icacls? Yes - that's how it's supposed to work (ie. *not* using /t). The purpose of that code is to ensure that the entire path leading up to the data/installation directories is readable by the users that need it. We've had a number of reported installation failures in the past caused by weirdness where read or execute permissions weren't available for (for example) the service account user, which caused somewhat mysterious failures. Or maybe it has something to do with inheritance? The way inheritance-permissions works on ntfs is, um, let's call it interesting. Maybe it needs to specify the (NP) flag to not propagate inheritance or something? Sachin/Ashesh; can one of you investigate this please? Karl; can you please provide precise details of your Windows version, and anything unusual about your disk configuration? I know this doesn't happen on any of the installations of Windows 7 that we use for testing (which tend to be the MSDN builds, running on local NTFS disks), so I wonder if there's an icacls bug in a specific build or rev of Windows, or when used on a certain type of filesystem. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
Thanks Karl. Is SP1 installed? Sachin, Ashesh - anything else you can think of that would be useful? On Mon, Oct 3, 2011 at 1:48 PM, Karl Wright daddy...@gmail.com wrote: Sorry for the delay - it's been a busy morning. The Windows 7 system I'm using is a laptop with a standard basic Nokia image. To the best of my knowledge there have been no OEM modifications of any kind. It describes itself as Windows 7 Enterprise, and says it is 32-bit. That's it. Anything else you'd want me to check? Karl On Mon, Oct 3, 2011 at 4:11 AM, Dave Page dp...@pgadmin.org wrote: On Mon, Oct 3, 2011 at 8:59 AM, Magnus Hagander mag...@hagander.net wrote: On Fri, Sep 30, 2011 at 15:34, Karl Wright daddy...@gmail.com wrote: I saw a thread where somebody saw icacls.exe being called by the one-click installer. I'm having the same thing - the installer has been running for 45 minutes now and is basically going to have to be stopped because I'm out of time waiting for it. Looking at process monitor, it is clear that icacls.exe is going through every file on the entire system and changing its permissions. The process tree indicates that it is a child of the installer, and that it is running the command: icacls C:\ /grant kawright:RX Clearly this won't do at all and should be considered a severe installer bug. If it does, it certainly sounds like a very bad bug. However, according to the documentation for icacls (http://technet.microsoft.com/en-us/library/cc753525(WS.10).aspx), you should use /t to get it to traverse into subdirectories, and clearly it's not doing that. So I wonder why it would go across the whole filesystem - might tbere be a bug in icacls? Yes - that's how it's supposed to work (ie. *not* using /t). The purpose of that code is to ensure that the entire path leading up to the data/installation directories is readable by the users that need it. We've had a number of reported installation failures in the past caused by weirdness where read or execute permissions weren't available for (for example) the service account user, which caused somewhat mysterious failures. Or maybe it has something to do with inheritance? The way inheritance-permissions works on ntfs is, um, let's call it interesting. Maybe it needs to specify the (NP) flag to not propagate inheritance or something? Sachin/Ashesh; can one of you investigate this please? Karl; can you please provide precise details of your Windows version, and anything unusual about your disk configuration? I know this doesn't happen on any of the installations of Windows 7 that we use for testing (which tend to be the MSDN builds, running on local NTFS disks), so I wonder if there's an icacls bug in a specific build or rev of Windows, or when used on a certain type of filesystem. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer spam_ea...@gmx.net wrote: Dave Page wrote on 03.10.2011 10:11: Karl; can you please provide precise details of your Windows version, and anything unusual about your disk configuration? I know this doesn't happen on any of the installations of Windows 7 that we use for testing (which tend to be the MSDN builds, running on local NTFS disks), so I wonder if there's an icacls bug in a specific build or rev of Windows, or when used on a certain type of filesystem. I have reported this as well some weeks ago. For me this happened on a Windows7 64 bit system that is part of a domain (all current MS patches applied) UAC is turned off, I was logged in as a local administrator (*not* a domain administrator). I have a ProcessMonitor trace that shows the behaviour of what icacls is doing when started by the installer. It is available here: http://www.sql-workbench.net/icacls_trace.zip Thanks Thomas. That certainly doesn't look like it's doing what it was told to :-s -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe
On Mon, Oct 3, 2011 at 2:39 PM, mgo...@isstrucksoftware.net wrote: I am running Windows 7 x64 (version 6.1.7601). My copy is also from the MSDN with latest updates applied. When I get to the end of the postgres install I get a error: Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed. I very much doubt that s the issue being discussed here. I'd suggest starting a new thread on pgsql-bugs and including your installation logs from %TEMP%. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company top.letterhead
[GENERAL] PostgreSQL Core Team
I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the native Windows port, quickly becoming a committer to help with his efforts. He's one of the project's webmasters and sysadmins and also contributes to related projects such as pgAdmin. In his spare time, he serves as President of the Board of PostgreSQL Europe. Regards, Dave. -- Dave Page PostgreSQL Core Team http://www.postgresql.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)
On Sun, Dec 5, 2010 at 1:43 PM, Stefan Keller sfkel...@gmail.com wrote: I've recently installed newest Postgres 9.1 Alpha 1 (postgresql-9.1alpha1-windows-binaries.zip from http://www.enterprisedb.com/products/pgbindownload.do ) and got a similar question around this: There's pgAdmin3 v.1.13 included but it still complains when opening a 9.1alpha db saying: Warning: This version of pgAdmin has only been tested with PostgreSQL version 9.0 (...). Please upgrade pgAdmin. But when I look at http://www.pgadmin.org/download/windows.php it only shows pgAdmin v1.12.1 (even source code is'nt newer). So Please upgrade... is just a standard text? Yes, until we get to the point in development when we're happy to call the new version supported in any way. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Just 2 days left to register for PGDay.EU 2010
Yup, you heard correctly - there are just two (and a bit) days left to register for the annual European PostgreSQL Conference, pgDay.EU 2010, being held in Stuttgart on December 6th and 7th, with a day of training sessions on the 8th. http://2010.pgday.eu/ With over 40 talks in a mix of English and German, this is an event not to be missed if you're a PostgreSQL user, developer, hobbyist, or are considering a deployment. There are a wide range of topics including talks on GIS, interoperability and migration, high availability and monitoring, business around PostgreSQL and case studies, as well as more academic topics. On day three we have a number of training courses available, including a two part course on PostGIS, presented by one of the leading developers, Mark Cave-Ayland from Sirius, deployment of applications in the Cloud with Servoy presented by Robert Ivens from Roclasi, and a two part PostgreSQL administration course (in German) given by Andreas Scherbaum for EnterpriseDB. Finally, as attendees from previous PGDay's will have come to expect, EnterpriseDB will be hosting a party for everyone on Monday night - definitely not one to miss! So, talk to the boss, fill out those pesky travel requisition forms, and head on over to the registration page! http://2010.pgday.eu/register -- Dave Page PostgreSQL Europe http://www.postgresql.eu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Why facebook used mysql ?
On Tue, Nov 9, 2010 at 9:28 AM, Andy angelf...@yahoo.com wrote: Any upgrades that are based on the MySQL source code will be legally required to be released under GPL too. That's the beauty of GPL. Upgrades released by Oracle *do not* have be under GPL. They own all the IP, and can release future versions under whatever terms they see fit. Other entities, do have to use the GPL if they release their own updates. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Why facebook used mysql ?
On Tue, Nov 9, 2010 at 5:45 PM, Andy angelf...@yahoo.com wrote: Not true. As a condition of getting European Commission's approval of its acquisition of Sun/MySQL, Oracle had to agree to continue the GPL release. And there are non-Oracle upgrades from Google, facebook, Percona, etc. So no one is beholden to Oracle. It is true. The EU commitments are entirely independent of the licencing. Also note that the commitments (http://www.oracle.com/us/corporate/press/042364) are pretty loosely worded. For example, Oracle would be fulfilling them if they released a new Enterprise version with 1000 new features, and a corresponding community version with just one of those features. And after 5 years (nearer to 4 now I guess), those commitments get thrown away entirely. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)
On Mon, Nov 8, 2010 at 3:06 PM, Richard Broersma richard.broer...@gmail.com wrote: I'm interested in playing with some of the features in the Alpha 2. Is there an ETA for the release for the one-click installer? I'm not sure if I'll get time to build them this time. Unfortunately the release of the tarballs coincided with PGWest, so I couldn't do them then and now have to catch up on a bunch of work. To make matters worse, the pgAdmin build has changed somewhat on Windows and requires some effort to update the installers to work again. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Linux
On Thu, Nov 4, 2010 at 8:00 AM, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: I know that this is probably a religion issue but we are looking to move Postgres to a Linux server. We currently have a Windows 2008 R2 active directory and all of the other servers are virtualized via VMWare ESXi. One of the reasons is that we want to use a 64 bit Postgres server and the UUID processing contrib module does not provide a 64 bit version for Windows. I would also assume that the database when properly tuned will probably run faster in a *inx environment. What and why should I look at certain distributions? It appears from what I read, Ubanta is a good desktop but not a server. Whilst I won't discourage you from a move to Linux, which I think is a good idea in general (and personally, my choice is RHEL - or CentOS if you want free - for a production server), I will note that Hiroshi Saito has ported ossp-uuid to Win64 now, and we're working on getting it included in the next update of PG 9.0. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Please Help...
On Thu, Nov 4, 2010 at 1:58 AM, Gavin Burrows gavin_burr...@yahoo.com wrote: Hi I'm sure you have had this question many times before but I feel as though I have genuinely exhausted all of my option and followed all the advise I can find online. During installation of Postgresql at the time when it tries to create the account I get the message ' user account postgress cannot be created because the password is too short or not complex enough' at which point the install is terminated. This is driving me nuts as it even says this when it chooses the password for you which just seems bizarre. If it's generating the password for you, I assume you're using the older MSI installers which are largely obsolete now? In any case, the issue is that for some reason, Windows is refusing to allow the user account to be created. That's normally because it's not in compliance with a security policy on the system - almost always related to password complexity, or age/reuse. You could try creating the account manually in advance. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unhandled exception in PGAdmin when opening 16-million-record table
On Sat, Oct 30, 2010 at 2:45 PM, Peter Geoghegan peter.geoghega...@gmail.com wrote: On 30 October 2010 11:26, Dmitriy Igrishin dmit...@gmail.com wrote: Hey all, Why not to use MVC approach by implementing a model, which uses, e.g. scrollable cursors? I believe that wxWidgets supports MVC. I've seen that behaviour before in similar applications, but it had a major downside: the number of rows returned was not known in advance of scrolling down to the last one. So you couldn't visualise the size of the record set based on the size and relative position of the scrollbar. That is basically how it works (MVC), albeit without using cursors; for both the reason you state and because part of the point of the tool is to tune queries and using cursors to do that completely messes up any timings we might get. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unhandled exception in PGAdmin when opening 16-million-record table
On Sat, Oct 30, 2010 at 4:14 PM, Dmitriy Igrishin dmit...@gmail.com wrote: Do you mean that cursors (regular, not holdable) live only inside a transactions? But it is possible to check transaction status from another part of pgAdmin or even make the window with result set modal ? No, I mean that the tool was developed to help tune application queries, in which the data transfer time can be just as important as the query execution time. With cursors, you lose that information. Of course, patches to make optional use of cursors would be interesting to us. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 9.0.1-1 windows install VC++ 2008 redistributalbe warning
On Fri, Oct 29, 2010 at 2:40 PM, David Balažic xerc...@gmail.com wrote: Hi! http://get.enterprisedb.com/postgresql/postgresql-9.0.1-1-windows.exe Upon starting the abov installer, I get a dialog titled Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4148 It lists the window titles of some processes, like MS Outlook, Firefox, Eclipse and has 3 buttons: Cancel, Retry and Ignore 1.) It does not say what it wants or why did it appear. 2.) It looks like the these programs should be closed before I can continue dialogs, in which case: Why is for example Eclipse needed to close to install a VC++ library? Eclipse is a Java program. Thats the Microsoft runtime installer, which is included in the PostgreSQL installer. Unfortunately, as it's written and supplied by Microsoft, we don't have any idea how or why it works as it does. We just know we need the runtimes it installs. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Missing uuid_generate_v1()
On Mon, Oct 25, 2010 at 1:12 PM, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: Is there a patch being worked on which will allow this contrib module to work properly under Windows 64 bit machines using the 64 bit Postgres server? We need to be able to support both Windows and Linux servers running Postgres. It's not a PostgreSQL issue - the underlying library ossp-uuid doesn't support 64 bit Windows. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGDay Europe 2010 schedule announced
I'm pleased to be able to say that the schedule for this year's PGDay Europe conference in Stuttgart, Germany on the 6th - 8th December 2010 is now available. We have a bumper crop of talks this year, with 13 sessions in German, 26 in English, 2 keynotes and a key signing party! We're pleased to welcome Free and Open Source veteran, Simon Phipps as the presenter of our opening keynote. Simon is well known for his involvement with various organisations including GNOME, OpenSolaris and OpenJDK and will be talking about some of the changes we've been seeing in the Open Source world recently as projects evolve and corporate involvement changes. He is perhaps best known for his role as Chief Open Source Officer at Sun Microsystems where he oversaw the companies Open Source activities. Of course, we also have some great technical talks lined up for developers, DBAs and people considering using or deploying Postgres, on topics such as PostGIS, application development, PostgreSQL internals, clustering and replication and more all in the comfortable surroundings of a top hotel. For the first time we've also added a day of training sessions to the schedule this year (at extra cost). Training will be available on PostgreSQL administration, application development and PostGIS, with some courses in German and some in English. As always, we reserve the right to adjust the schedule in the event of unforeseen circumstances. So, if you haven't done so already, head on over to the website and register your attendance at the conference. You won't regret it! Website: http://2010.pgday.eu/ Schedule: http://2010.pgday.eu/schedule Registration: http://2010.pgday.eu/register See you in Stuttgart! -- Dave Page PostgreSQL Core Team http://www.postgresql.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] createlang plpythonu fails on 64bit windows
On Sun, Oct 24, 2010 at 10:02 AM, Massa, Harald Armin c...@ghum.de wrote: (which translated to english is roughly: createlang: Installation of language failed: ERROR: could not load library »C:/Program Files/PostgreSQL/9.0/lib/plpython.dll« : %1 is not a valid Win32 application. Should'nt plplython.dll be a valid win32_x64 application when being loaded into PostgreSQL 64bit? Could this be the source of the error? (as in: plpython.dll is 32 bit, PostgreSQL is 64bit, so no loading of 32-bit-module into 64-bit-process?) plpython.dll is unlikely to be 32bit unless you're using the 32bit Postgres build (it's built along with the rest of the server, so...). What version of Python do you have? A quick glance at the build script shows we're using 2.6, and we always use the ActiveState builds. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 9.0 SSL renegotiation failure restoring data
On Thu, Oct 21, 2010 at 2:40 PM, Bruce Momjian br...@momjian.us wrote: Andrus wrote: Uh, we don't ship SSL in the server. We ship code that _uses_ ssl, so I would look at your operating system to see what version of SSL you have, and perhaps update that. I installed postgres 9.0 RC in Windows from official link and looked into bin: Directory of C:\Program Files\PostgreSQL\9.0\bin 15.11.2009 16:37 200_704 ssleay32.dll 15.11.2009 16:37 1_017_344 libeay32.dll How to update them so that they match with linux server ? Oh, interesting. So we install SSL with our Win32 install, and I assume that is a new/correct version of ssl. Dave, this person says they are getting disconnected regularly and we thought it was ssl renegotiation, but not I am unclear what is causing the disconnection. It's possible - it depends on what version of OpenSSL was available at the time we started testing 9.0. Dharmendra, can you please check and upgrade the build servers if necessary? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need some help setting up pgAgent
On Sun, Oct 17, 2010 at 2:32 PM, Mike Christensen m...@kitchenpc.com wrote: Okay my required n00b question of the week, hopefully this'll be an easy one.. I decided to give pgAgent a shot, because there's this stored sproc (sorry, function) I need to run nightly and I think spending hours figuring out pgAgent would somehow be better than the 3 minutes it would take to add a cron job that calls psql.. I'm following the directions at: http://www.pgadmin.org/docs/1.6/pgagent-install.html Why such an old version? Try http://www.pgadmin.org/docs/1.12/pgagent-install.html However, the heading Daemon installation on *nix needs me to believe that running pgagent from the command line should install the daemon, and then things should be happily running in the background. However, when I run the command line as instructed, it just sits there and does nothing. I never get returned to the bash prompt, it's as if the daemon is just running in interactive mode until I stop the process.. Did you use the -f option? Maybe I'm missing something, or I have to add that command line to some config file. I'm not a unix guru but from my past experiences, I can usually run daemons with /etc/init.d/blah start - pgAgent doesn't seem to be installed in that manner. If you built from source, it's up to you to create the startup script. The pgAgent source tree doesn't contain OS-specific startup scripts. Second, assuming the daemon is running in interactive mode, like.. now what? The docs have no next steps. How do I create a new job to run my SQL function every night? From some documentation from Postgres Plus, I was led to believe that there should be a Jobs tree in pgAdmin created.. But I see nothing. Thanks! Did you setup the database per the part of the docs prior to that section? The next steps are most certainly there - see the index page at http://www.pgadmin.org/docs/1.12/pgagent.html -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need some help setting up pgAgent
On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen m...@kitchenpc.com wrote: Sorry, it looks like it defaulted to the wrong DB. I created the schema in the postgres database and now I see a Jobs node.. :-) One last question - How do I configure pgAgent to start automatically? You'll need to put together a startup script for your OS, if the debian/ubuntu packager hasn't done so already. I'd suggest copying one from /etc/init.d and tweaking it as required. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need some help setting up pgAgent
On Mon, Oct 18, 2010 at 10:41 AM, Mike Christensen m...@kitchenpc.com wrote: On Mon, Oct 18, 2010 at 2:34 AM, Dave Page dp...@pgadmin.org wrote: On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen m...@kitchenpc.com wrote: Sorry, it looks like it defaulted to the wrong DB. I created the schema in the postgres database and now I see a Jobs node.. :-) One last question - How do I configure pgAgent to start automatically? You'll need to put together a startup script for your OS, if the debian/ubuntu packager hasn't done so already. I'd suggest copying one from /etc/init.d and tweaking it as required. This is a bit outside my comfort zone, do you have a startup script you can share with me? I can copy it into /etc/init.d - Thanks! No I don't (I use a Mac - and never start pgagent automatically anyway). Can you copy the PostgreSQL script and make appropriate changes? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need some help setting up pgAgent
On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen m...@kitchenpc.com wrote: Okay I found one that I can use.. One question.. Should the connection string in the script have the password for root hard coded in it? Or will it use a password from ~/.pgpass automatically? If so, what user account will it find the .pgpass file under? Thanks! Have the script start pgagent under the postgres account eg; su - postgres -c 'p/path/to/pgadmin' Then it should be able to use postgres' pgpass file. Don't put the password in the connection string! -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need some help setting up pgAgent
On Mon, Oct 18, 2010 at 11:34 AM, Mike Christensen m...@kitchenpc.com wrote: On Mon, Oct 18, 2010 at 3:07 AM, Dave Page dp...@pgadmin.org wrote: On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen m...@kitchenpc.com wrote: Okay I found one that I can use.. One question.. Should the connection string in the script have the password for root hard coded in it? Or will it use a password from ~/.pgpass automatically? If so, what user account will it find the .pgpass file under? Thanks! Have the script start pgagent under the postgres account eg; su - postgres -c 'p/path/to/pgadmin' Then it should be able to use postgres' pgpass file. Don't put the password in the connection string! Ok, that worked.. I can at least start and stop it now, and it remains running when I'm logged off.. So does anything in /etc/init.d get automatically run when the server boots? No, you have to enable it. On redhat based distros, you'd do something like chkconfig servicename on. On Debian based distros, I believe you use the update-rc.d command. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Understanding PostgreSQL Storage Engines
On Wed, Oct 13, 2010 at 12:29 PM, Ron Mayer rm...@cheapcomplexdevices.com wrote: Pavel Stehule wrote: 2010/10/8 Carlos Mennens carlos.menn...@gmail.com: I know that MySQL uses MyISAM storage engine by default... what storage engine does PostgreSQL use by default ... PostgreSQL supports and uses just only one storage engine - PostgreSQL. That said, ISTM one of Postgres's bigger strengths commercially seems to be that vendors can reasonably easily plug in different storage engines. That depends on how you define reasonably easily. It's not even remotely close to the ease with which you can plugin a different storage engine in MySQL, and would take a significant amount of engineering expertise and effort. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Understanding PostgreSQL Storage Engines
On Wed, Oct 13, 2010 at 1:11 PM, Thom Brown t...@linux.com wrote: On 13 October 2010 12:35, Dave Page dp...@pgadmin.org wrote: On Wed, Oct 13, 2010 at 12:29 PM, Ron Mayer rm...@cheapcomplexdevices.com wrote: Pavel Stehule wrote: 2010/10/8 Carlos Mennens carlos.menn...@gmail.com: I know that MySQL uses MyISAM storage engine by default... what storage engine does PostgreSQL use by default ... PostgreSQL supports and uses just only one storage engine - PostgreSQL. That said, ISTM one of Postgres's bigger strengths commercially seems to be that vendors can reasonably easily plug in different storage engines. That depends on how you define reasonably easily. It's not even remotely close to the ease with which you can plugin a different storage engine in MySQL, and would take a significant amount of engineering expertise and effort. And I don't think other storage engines bring anything but unnecessary code maintenance overhead and complexity. Plus, reading MySQL's documentation, you can see notes scattered everywhere about how features behave differently, or aren't compatible with certain storage engines. This not only increases the number of gotchas, but also means supporting all these engines requires an extra level of knowledge. I think focus on a single storage engine means it's extremely mature, predictable and stable... IMHO. And allows extremely tight integration with the rest of the system - something I've heard the MySQL engine vendors all complain about (the rigidity of being behind a defined API that doesn't meet everyones needs). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] NoSQL -vs- SQL
On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai pe...@simons-rock.edu wrote: On 2010-10-11 05:57:37PM -0600, David Boreham wrote: On 10/11/2010 5:46 PM, Carlos Mennens wrote: Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. http://www.xtranormal.com/watch/6995033/ (warning: may not be sfw). Someone should (or probalby has) made one that sounds exactly the same, except for replacign the Mongo guy with MySQL and the MySQL guy with PostgreSQL. That might be more apopros all around ;) Someone did indeed do that: http://nigel.mcnie.name/blog/mysql-is-a-database (also nsfw, iirc) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgreSQL for Windows 7
On Thu, Oct 7, 2010 at 12:28 PM, quickinfo quickinfo quickinfo...@gmail.com wrote: Dear Friends, I have installed windows 7 on my system. Previous I used postgreSQL 8.0 on XP. I tried install postgres 8.3 on windows 7. but it is not installing properly. After installtion am not able to find out pg_hba.conf files. pgadmin III is opening fine and am able to create new database also. What would be the problems. I'm unclear on what the problem is, other than you cannot find pg_hba.conf (which will be wherever you chose as a data directory). The fact that pgAdmin runs and you can create databases implies that the server is at least installed and running. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGDay.EU 2010 Call for Papers ending soon!
This years European PostgreSQL Conference is due to be held on the 6 - 8th December 2010 in Stuttgart Germany (http://2010.pgday.eu/). Following on from last years extremely successful event in Paris, we hope to make the show bigger and better than before, with: * A 4 star hotel venue (with spa facilities in the complex) * A special guest keynote speaker (to be announced Real Soon Now :-) ) * Multiple talk tracks in English and German * Talks for PostgreSQL hackers and users, as well as decision makers * A day of training sessions Of course, to make that happen we need talk proposals from our community members and users. We're looking for presentations aimed at developers, users and decision makers on topics such as: - Developing applications for PostgreSQL - Administering large scale PostgreSQL installations - Case studies of PostgreSQL deployments - PostgreSQL tools and utilities - PostgreSQL hacking - Community user groups - Tuning the server - Migrating from other systems - Scaling/replication - Benchmarking hardware - PostgreSQL related products - Deployment of PostgreSQL from a business perspective - Applications and FOSS projects that use PostgreSQL So if you can make it to Germany in December, please take a look at the call for papers page on the website (http://2010.pgday.eu/callforpapers), and send in your proposal before the 11th October! Please forward this message to any colleagues or friends that you believe may be interested in presenting at the conference. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
On Thu, Oct 7, 2010 at 9:43 AM, Dr. Peter Voigt pvo...@uos.de wrote: Although I have not yet received any feedback from the BitRock support, I closed the ticket with them - we know what the problem was in your case, and we have enough info to try to put some additional checks in the installer to prevent it biting people in future releases (or at least give a more useful error message). I have meanwhile done some further tests. Most important result is that the installer finished flawlessly after I changed the TEMP and TMP variables back to the default %USERPROFILE%\AppData\Local\Temp. Thats good to hear. I am interested to hear how the installer is intended to handle links under Windows, because a link might also be contained within a non-default installation path. It does handle the links OK, it's just that those particular ones have an unusual ACL on them which caused our pre-installation actions to go haywire. If such a problem occurs with the installation path, you should get a regular permission denied error. Regards, Dave. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Missing uuid_generate_v1()
On Thu, Oct 7, 2010 at 3:56 AM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Christensen m...@kitchenpc.com writes: On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16 to that instead of carrying a separate file. So now what you're saying is if it's not broke, fix it till it is :) Well, it's hard to argue with that position ;-). But I'll try anyway: the platform-provided version of the library will be updated for bug fixes, compatibility rebuilds, etc. Your private copy won't be, unless you remember to do it. Eventually that's gonna bite ya. Of course the best fix would be for EDB to ship a build of Postgres that actually follows the platform-standard naming convention for this library. I'm still wondering why they're linking to libuuid.so. Dave? Because that's what comes with ossp-uuid 1.6.2, and I assume is what configure chooses when we use --with-ossp-uuid: [buildf...@bf2-linux ~]$ uuid-config --libs -luuid FYI, there was also a bug in the installer which didn't copy the library properly, which has been fixed for 9.0.2. -- Dave Page PostgreSQL Core Team http://www.postgresql.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Problem installing 9.0.1 on Windows 7 x64
On Tue, Oct 5, 2010 at 6:34 PM, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: I'm trying to install 9.0.1 32 bit on Windows 7 x64. I cannot use the 64 bit server because we use the UUID contrib module and it evidently isn't compatible with Windows 64 bit libraries. When I try and install the 32 bit server I get the following error message. Problem running the post-install step. Installation may not complete correctly. The database initialisation failed. I've tried this using my normal account which has administrator rights and the system administrator account. Can you post the installation log from %TEMP% please? See http://wiki.postgresql.org/wiki/Troubleshooting_Installation#Collect_the_installer_log_file for details. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Problem installing 9.0.1 on Windows 7 x64
[CC'ing the list to close the loop] On Tue, Oct 5, 2010 at 7:43 PM, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: Dave, I found the problem. For some reason icacls.exe can't be found, in fact none of the executable files in system32 can be found from the c:\. I'm not sure what's up because when I look at my path statement it shows c:\windows\system32 when I do either a path or set from the command line run inside CMD.exe. At least I know that it's not a Postgres issue now. Very odd. Permissions perhaps? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin from 9.0RC1 in 8.2.4 status cannot cast type xid to text error
2010/10/4 Andrus kobrule...@hot.ee: I ran PgAdmin from 9.0RC1 in windows and selected Tools/Server status for 8.2.4 server After that messagebox with error --- pgAdmin III --- An error has occurred: ERROR: cannot cast type xid to text LINE 1: SELECT transaction::text, gid, prepared, owner, database FRO... ^ --- OK --- occurs after every few seconds After some time there are hundreds of messageboxes in screen. Message boxes continue to apper even if status window is closed. How to fix ? Run pgAdmin 1.12.1, not a release candidate. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
For the benefit of the list, I've raised this issue with the people who supply the installer technology, as I can't see any reason why our code would get this wrong. On Thu, Sep 30, 2010 at 9:53 PM, Dr. Peter Voigt pvo...@uos.de wrote: Dave Page dp...@pgadmin.org writes: A couple of questions for you Peter (and thanks for bearing with us while we figure this out): - How are you running the installer? Are you logged in as Administrator, or are you using Run As Administrator or something similar? I am logged in as Administrator when running the installer. - What's the output from the SET command when run in the same user environment as the installer (ie. from an Administrator command prompt, or one launched however you've escalated your privileges). Please find the environment of user Administrator attached: ACR_BIN=C:\Program Files (x86)\Adobe\Reader 9.0\Reader ALLUSERSPROFILE=C:\ProgramData APACHE2_HOME=C:\Program Files\Apache Group\Apache22 APACHESRC=C:\Programme\Apache Group\Apache22 APPDATA=C:\Users\Administrator\AppData\Roaming asl.log=Destination=file;OnFirstLog=command,environment,parent BIBINPUTS=D:\home\pvoigt\tex\texsty BSTINPUTS=D:\home\pvoigt\tex\texsty CATALINA_HOME=C:\Program Files\tomcat60 CLASSPATH=.;C:\Programme\mysql-connector-java-5.1.10\mysql-connector-java-5.1.10-bin.jar;C:\Programme\sqljdbc_1.1_deu\sqljdbc.jar;C:\Program Files\tomcat60\lib\servlet-api.jar;d:\home\pvoigt\java\vog-libs\VogSystem.jar;d:\home\pvoigt\java\vog-libs\VogIO.jar;d:\home\pvoigt\java\vog-libs\MyIO.jar;d:\home\pvoigt\java\vog-libs\VogDbUtil.jar;d:\home\pvoigt\java\vog-libs\VogTime.jar CommonProgramFiles=C:\Program Files\Common Files CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files CommonProgramW6432=C:\Program Files\Common Files COMPUTERNAME=TIGER2008 ComSpec=C:\Windows\system32\cmd.exe CURL_CA_BUNDLE=D:\temp\ca-bundle.crt EASY_INSTALL_BIN=C:\Programme\Python26\Scripts EDITOR=C:\Program Files\vim\vim73\gvim.exe EMACS_OPTS=-geometry 80x45 --reverse-video FOP_HOME=C:\Program Files\fop FP_NO_HOST_CHECK=NO FRD_BIN=D:\local\bin FTPROOT=E:\srv\ftp GNUPGHOME=D:\home\pvoigt\.gnupg GNUWIN32_BIN=D:\local\GnuWin32\bin GSV_BIN=C:\Program Files\ghostgum\gsview GS_BIN=C:\Program Files\gs\gs8.64\bin GS_LIB=C:\Program Files\gs\gs8.64\lib;C:\Program Files\gs\fonts HEISE=D:\home\pvoigt\ct-ix\inhalt.frm HOME=D:\home\pvoigt HOMEDIR=D:\home\pvoigt\.gnupg HOMEDRIVE=C: HOMEPATH=\Users\Administrator INFODIR=D:\local\Emacs\emacs\info;D:\local\Emacs\emacs\site-info INFOPATH=D:\local\Emacs\emacs\info;D:\local\Emacs\emacs\site-info JAVA_HOME=C:\Program Files\Java\jdk KLEOPATRA_LOGDIR=D:\home\pvoigt\.gnupg\kleopatra LANG=DE LESS=-I -N -M -S LOCALAPPDATA=C:\Users\Administrator\AppData\Local LOCAL_BIN=D:\local\bin LOGONSERVER=\\TIGER2008 LYNX_CFG=C:\Program Files (x86)\Lynx\lynx.cfg LYNX_LSS=C:\Program Files (x86)\Lynx\lynx.lss MIKTEX_BIN=D:\local\MiKTeX\miktex\bin MINGW_HOME=D:\local\MinGW MSYS_HOME=D:\local\msys\1.0 MYSQL_JDBC_HOME=C:\Program Files\mysql-connector-java-5.1.10 NUMBER_OF_PROCESSORS=2 OPENSSL=C:\Program Files (x86)\openssl OPENSSL_CONF=D:\home\pvoigt\certs\ca\my_openssl.config OPENSSL_INC=C:\Program Files (x86)\openssl\include OPENSSL_LIB=C:\Program Files (x86)\openssl\lib OS=Windows_NT Os2LibPath=%Os2LibPath% PAGER=D:/local/gnuwin32/bin/less.exe Path=C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\PC Connectivity Solution\;C:\Program Files\ImageMagick;D:\local\MiKTeX\miktex\bin;c:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\GNU\GnuPG\pub;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\Common Files\Microsoft Shared\Windows Live;D:\local\tex4ht\bin\win32;D:\local\tex4ht\bin\ht\win32;C:\Program Files (x86)\openssl\bin;C:\Programme\gnutls\bin;d:\local\bin;d:\local\gnuwin32\bin;D:\home\pvoigt\ct-ix;C:\Program Files (x86)\Emacs\emacs\bin;C:\Program Files (x86)\GNU\GnuPG;C:\Program Files\Java\jdk\bin;C:\Program Files\Python27;C:\Program Files\Python27\Scripts;C:\Program Files\vim\vim73;C:\Program Files\perl\bin;C:\Program Files (x86)\lynx;C:\Program Files (x86)\Adobe\Reader 9.0\Reader;C:\Program Files (x86)\php;D:\home\pvoigt\python;C:\Program Files\ghostgum\gsview;C:\Program Files\MySQL\MySQL Server 5.1\bin;C:\Program Files\7-Zip;C:\Programme\Python26\Scripts;C:\Program Files (x86)\wget;C:\Program Files (x86)\curl;C:\Program Files\curl;C:\Program Files\ant\bin;C:\Program Files (x86)\NTP\bin;C:\Program Files (x86)\Mozilla Firefox PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=AMD64 PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 15 Stepping 11, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=0f0b ProgramData=C:\ProgramData ProgramFiles=C
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
On Fri, Oct 1, 2010 at 11:01 AM, Christian Ullrich ch...@chrullrich.net wrote: * Dave Page wrote: So, it sounds like there are two questions for me to figure out - why is the installer not able to follow the link and find the files (which is probably a question for BitRock), and why isn't it using the actual Temp subdirectory as it's supposed to. It can't follow the link because these links (actually, junctions) have ACLs that deny FILE_READ_DATA, which means you cannot enumerate the contents of the target directory through the link. See http://technet.microsoft.com/en-us/magazine/ee851567.aspx for an explanation of the ACLs. Interesting, thanks for the link. The OP indicates in his reply to your message that his %TEMP% path is C:\Users\ADMINI~1\LOKALE~1\Temp , which is using one of these junctions. This is definitely not the default value set when the Administrator profile is created during installation; that value would be C:\Users\Administrator\AppData\Local\Temp . I would recommend to change the user environment variables (TEMP and TMP) to the correct value and retry. Agreed. Of course, even if it works, this does not answer two questions: 1. How did TEMP end up with this value? 2. Why does the installer use the wrong directory? There are two things I can think of with regard to 1. The more likely one is that there is some logon script or group policy that applies to the local Administrator account, which was written for XP clients and therefore uses XP paths. The other idea is that his system may have been upgraded from XP by way of Vista and somehow kept the old paths intact. I would lean towards the former - the upgrade issue seems like something Microsoft would have ensured works correctly, though it's possible that a pre-upgrade installation might be in an unexpected state. As for 2, I suspect that somewhere in the installer, it walks down the path to the TEMP directory, and fails at the junction because it cannot read the contents of its target directory. I've asked BitRock to confirm or deny that. I'm thinking we should add a pre-installation check to ensure we can write to $TEMP, and execute what we've written. Will look into that... -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
On Fri, Oct 1, 2010 at 1:06 PM, Craig Ringer cr...@postnewspapers.com.au wrote: On 10/01/2010 06:30 PM, Dave Page wrote: As for 2, I suspect that somewhere in the installer, it walks down the path to the TEMP directory, and fails at the junction because it cannot read the contents of its target directory. I've asked BitRock to confirm or deny that. It should be pretty trivial to test with Process Monitor. As I don't think my (English) system will have that junction point, I'm not sure I can observe the results with junction points, but I can certainly see if the installer is trying to walk the path. [clickety click] Yes, the installer walks the path. For each directory it does: FASTIO_NETWORK_QUERY_OPEN (QueryOpen) FASTIO_QUERY_INFORMATION (QueryOpenNetworkInformation) IRP_MJ_DIRECTORY_CONTROL (QueryDirectory) (see the attached screenshot) IRP_MJ_DIRECTORY_CONTROL is documented in MSDN as: http://msdn.microsoft.com/en-us/library/ff548658(VS.85).aspx The rest, I have no idea about. I don't do Windows innards by choice. You would think it would walk backwards in the event of an error rather than the other way round. Anyway, BitRock should be able to tell us, unless it's their underlying toolkit/language/SDK that's doing it. I wonder why it's walking the path? Such things are rarely a good idea, unless you're trying to backtrack on an access denied error to find out at what level of a path you lost access. Right :-) I really should read to the end before commenting. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
On Fri, Oct 1, 2010 at 2:24 PM, Andrus kobrule...@hot.ee wrote: Will it set optimal configuration so that manual editing of postgresql.conf is not required ? It will generate a starter configuration, that will be based on your selected workload type and machine resources. That may be fine for your needs, or you may need to tune it to more precisely meet the needs of your actual workload. It doesn't claim to eliminate the need for any future manual tuning. How to configure automatically Linux and Mac servers ? Run the tuning wizard on them? How to configure remote servers where only port 5432 is open ? You can't. Why pgAdmin postgresql.conf editor does not contain automatic configurator ? Because it can't examine the server spec remotely through libpq, and because noone wrote it yet. And I'm not sure we'd want it in pgAdmin anyway as such functionality is somewhat outside the realm of what pgAdmin does. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
On Fri, Oct 1, 2010 at 3:04 PM, Andrus kobrule...@hot.ee wrote: How to configure automatically Linux and Mac servers ? Run the tuning wizard on them? Where to find installation packages for Debian and Ubuntu ? Installers can be downloaded in StackBuilder. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
On Fri, Oct 1, 2010 at 3:13 PM, Andrus kobrule...@hot.ee wrote: Where to find installation packages for Debian and Ubuntu ? Installers can be downloaded in StackBuilder. How to run StackBuilder from Debian bash command line ? On RHEL/CentOS, I'd use the following from a root command prompt: /opt/PostgreSQL/9.0/stackbuilder/bin/stackbuilder I assume the same would work on Debian, though you might need to use sudo as with Ubuntu. The installers aren't supported on Debian though, so I don't know if it'll work. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt pvo...@uos.de wrote: Hi Dharmendra, thanks for your reply. This kind of errors, which cannot be reproduced on other machines are bad and leave no chance for developers to solve them. Unfortunately the installer does not leave any log files. Please look for any logfiles in %TEMP% starting with bitrock. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ossp-uuid missing from one click windows x64 builds
On Thu, Sep 30, 2010 at 5:57 PM, Cheetah fast...@gmail.com wrote: I just installed a copy of PostgreSQL 9.0 on Windows 7 x64 using the one click installer, and found that the uuid-ossp contrib module is missing. I took a look at the zip archives, and the uuid-ossp files are in the 32 bit build, but not the 64 bit build. Is this an oversight, or is there some problem with the library on Windows x64? The underlying uuid-ossp library isn't supported on Win64, so we can't build the contrib module unfortunately. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
On Thu, Sep 30, 2010 at 7:41 PM, Dr. Peter Voigt pvo...@uos.de wrote: Dave Page dp...@pgadmin.org writes: On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt pvo...@uos.de wrote: Hi Dharmendra, thanks for your reply. This kind of errors, which cannot be reproduced on other machines are bad and leave no chance for developers to solve them. Unfortunately the installer does not leave any log files. Please look for any logfiles in %TEMP% starting with bitrock. Well, the installer does not leave any file starting with bitrock in my %TEMP% directory. I am using the default %TEMP% value as created during system installation. Its value is (German operating system) C:\Users\Administrator\Lokale Einstellungen\Temp or in 8.3 notation C:\Users\ADMINI~1\LOKALE~1\Temp. The subdir Lokale Einstellungen is a link to C:\Users\Administrator\AppData\Local: administra...@tiger2008:C:\Users\Administrator dir /a |grep -i lokale 28.08.2010 15:22 VERBINDUNG Lokale Einstellungen [C:\Users\Administrator \AppData\Local] However, a scan of my whole system partition reveales a file bitrock.log under C:\Users\Administrator\AppData\Local. I have just re-created it with a fresh installation attempt. Please find it attached. I have tried to interpret the error in the log. The installer complains about not finding file C:\Users\Administrator\Lokale Einstellungen\postgresql_installer\installruntimes.vbs. I suppose it is important for you to know that this file installruntimes.vbs is present - but under C:\Users\Administrator\AppData\Local. This is the same directory where I finally found the log. Thats very odd, but it explains why things are going wrong - essentially, the prerequisites are being unpacked to: C:\Users\Administrator\AppData\Local But the installer expects to find them in: C:\Users\Administrator\Lokale Einstellungen\ Which is a link to the first folder. I (as the guy the wrote the original version of the installer) expect them to be in: C:\Users\Administrator\Lokale Einstellungen\Temp\ So, it sounds like there are two questions for me to figure out - why is the installer not able to follow the link and find the files (which is probably a question for BitRock), and why isn't it using the actual Temp subdirectory as it's supposed to. A couple of questions for you Peter (and thanks for bearing with us while we figure this out): - How are you running the installer? Are you logged in as Administrator, or are you using Run As Administrator or something similar? - What's the output from the SET command when run in the same user environment as the installer (ie. from an Administrator command prompt, or one launched however you've escalated your privileges). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe scott_r...@killerbytes.com wrote: On Sep 28, 2010, at 11:50 AM, Dave Page wrote: You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? That's irrelevant. The 32-bit vs 64-bit default is for the kernel and extensions, not for applications. On 64-bit hardware, apps can be run as 64-bit, and will be if there's a 64-bit executable, regardless of which mode the kernel is booted into. Thanks for the clarification. I thought it was only Snow Leopard/Snow Leopard Server and Leopard Server that could run the 64 bit images. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
2010/9/29 Andrus kobrule...@hot.ee: I installed PostgreSql 9.0 Win 64 standard distro. Stack builder offered in end of installation does not contain postgresql.conf optimization wizard. We updated it for Win64, but it looks like the stackbuilder catalog wasn't updated to allow it to be downloaded on that platform. I've fixed that - it should be available within an hour or so. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition
On Wed, Sep 29, 2010 at 11:37 AM, Andrus kobrule...@hot.ee wrote: We updated it for Win64, but it looks like the stackbuilder catalog wasn't updated to allow it to be downloaded on that platform. I've fixed that - it should be available within an hour or so. I just installed 9.0 x64 Is it sufficient to run Program files / PostgreSql 9.0 / Application Stack Builder from this installation to get it ? Yes, in an hour or so. Will it set optimal configuration so that manual editing of postgresql.conf is not required ? It will generate a starter configuration, that will be based on your selected workload type and machine resources. That may be fine for your needs, or you may need to tune it to more precisely meet the needs of your actual workload. It doesn't claim to eliminate the need for any future manual tuning. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Missing path in pg_config
On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J jjtur...@statestreet.com wrote: Hello, I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and I’m trying to install the temporal extension module available in pg_Foundry. One problem I can see that I’m running into is that the path defined for PGXS in pg_config does not exist: PGXS = c:/program files/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk I have a path up to the “…/lib” but nothing after that. Do I need to re-install something or run a script to flesh things out? It seems when I follow the instructions for the temporal module install (as found here), it bombs out when it tries to find this path while running make install PGXS doesn't work with the VC++ build we use for Windows. I wonder if that output from pg_config should be #ifdef'd out until such time as we can figure out a way to make it work - if that's even possible. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski lar...@emailplus.org wrote: Hi - I use Dave Page's one-click installers for Mac OS X: http://www.enterprisedb.com/products/pgdownload.do#osx I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: grumble. That's a PITA. We build on Snow Leopard now, because we were getting more requests for x86_64 support than PPC. even though the plperl.so I built looks ok: $ file plperl.so plperl.so: Mach-O bundle i386 Has anyone else run into this? Anybody have any suggestions? I could understand that if it's running the 64 bit image in the binary, but that shouldn't be the case on Leopard I don't think - unless this is Leopard Server? If so, you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken
On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski lar...@emailplus.org wrote: On Tue, 28 Sep 2010 13:35 +0100, Dave Page dp...@pgadmin.org wrote: I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load because it is looking for Perl 5.10 in the System dirs and I only have 5.8.8: grumble. That's a PITA. We build on Snow Leopard now, because we were getting more requests for x86_64 support than PPC. [snip] you could try building the 64 bit binary: CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk -mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure Excellent! Looks like that worked fine. I just added the --with-perl option to configure. Thanks Dave! You're welcome. I guess it is running the 64bit image - is your machine Leopard Server? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Database Cluster Initialisation Failed error during PostgreSQL install
On Mon, Sep 27, 2010 at 6:30 AM, Padmanabha, Shruthi (UMKC-Student) sp...@mail.umkc.edu wrote: Hello, I was unable to install PostgreSQL 8.4.4 successfully. The error I received was “Database Cluster Initialisation Failed error during PostgreSQL install”. I selected the windows version from the link http://www.enterprisedb.com/products/pgdownload.do#windows . on running the .exe file I get the above error message. Please can this matter be resolved for me as soon as possible. Can you post the logfile from %TEMP% please? Also, please include details of the target system. What OS is it, is it on a domain etc? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Database Cluster Initialisation Failed error during PostgreSQL install
Please keep the thread on the mailing list. On Mon, Sep 27, 2010 at 5:59 PM, Padmanabha, Shruthi (UMKC-Student) sp...@mail.umkc.edu wrote: Hello Dave, I was trying to install PostgreSQl 8.4.4-1 on my Windows 64bit Vista machine. The machine does not have Microsoft Visual C++ installed on it . I did not find any log file C:\Users\SHRUTH~1\AppData\Local\Temp I have also attached a screen shot of my error message and inspite of the error I have a folder PostgreSQL in C:\Program Files (x86)\PostgreSQL as a result of my intallation. Please can you help me out with this. The logfile may have a name starting bitrock_, if the installer didn't get a chance to rename it to install-postgresql.log. Without it, there's not really anything I can suggest. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing Contrib Modules with a Precompiled Binary
On Mon, Sep 20, 2010 at 7:06 PM, Aram Fingal fin...@multifactorial.com wrote: I'm using the OS X precompiled binary from EnterpriseDB and want to add the tablefunc contrib module. I haven't been able to find any documentation about how to do this or even whether modules can be added to this binary version. It's the same as the source version except you don't need to build the binary - just run the SQL script from the share/ subdirectory of the installation. I suppose that it may be a good idea to export my databases and compile from source anyway. I see that Postgres is running as a 32-bit application while I have a 64-bit machine and OS (OS X, Snow Leopard.) The 9.0 release supports 32 and 64 bit Intel machines. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Installing Contrib Modules with a Precompiled Binary
On Mon, Sep 20, 2010 at 8:20 PM, Aram Fingal fin...@multifactorial.com wrote: So that means something like: psql -d dbname -f /Library/PostgreSQL/8.4/share/postgresql/contrib/tablefunc.sql Yup. I suppose that I will have to export and re-import the databases when I upgrade? Hmm, yes - interesting point. pg_upgrade won't work, because OSX will automatically run the 64bit part of the Universal binaries with 9.0, where the 8.3 or 8.4 versions would have been 32bit. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] configure: error: header file libxml/parser.h is required for XML support
On Wed, Sep 15, 2010 at 10:57 AM, Peter Roethlisberger peter.roethlisber...@gmail.com wrote: Hi there, I try to configure postgres: /configure --prefix=/usr/local/postgresql-8.4.4/ \ --without-docdir \ --with-openssl \ --with-libxml \ --with-libxslt \ --with-libraries=/usr/local/openssl:/lib:/lib64:/usr/local/readline/lib:/usr/local/zlib/lib:/usr/local/openssl/lib64:/usr/local/libxml2/lib:/usr/local/libxslt/lib \ --with-includes=/usr/local/readline/include:/usr/local/zlib/include:/usr/local/openssl/include:/usr/local/libxml2/include/libxml2/libxml:/usr/local/libxslt/include Now even though parser.h can be found in the includes path it claims: configure: error: header file libxml/parser.h is required for XML support Your include path contains /usr/local/libxml2/include/libxml2/libxml, so Postgres is probably looking for /usr/local/libxml2/include/libxml2/libxml/libxml/parser.h, which I suspect is wrong. Try removing the extra /libxml from the include path. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] configure: error: header file libxml/parser.h is required for XML support
Hi Peter On Wed, Sep 15, 2010 at 12:46 PM, Peter Roethlisberger peter.roethlisber...@gmail.com wrote: Hey Dave, Thanks for the quick reply. The path is correct: # ls -l /usr/local/libxml2/include/libxml2/libxml/parser.h -rw-r--r-- 1 root root 39556 Sep 15 10:07 /usr/local/libxml2/include/libxml2/libxml/parser.h But the path you have is: /usr/local/libxml2/include/libxml2/libxml and the included file is libxml/parser.h Put those together and you get: /usr/local/libxml2/include/libxml2/libxml/libxml/parser.h *not* /usr/local/libxml2/include/libxml2/libxml/parser.h Regards, Dave I first used /usr/local/libxml2/include/ which did not work. Doing a find for parser.h made me change the include path. Could possibly the version of libxml2 be an issue: 2-2.7.7 ??? Thx: Peter On Wed, Sep 15, 2010 at 12:18 PM, Dave Page dp...@pgadmin.org wrote: On Wed, Sep 15, 2010 at 10:57 AM, Peter Roethlisberger peter.roethlisber...@gmail.com wrote: Hi there, I try to configure postgres: /configure --prefix=/usr/local/postgresql-8.4.4/ \ --without-docdir \ --with-openssl \ --with-libxml \ --with-libxslt \ --with-libraries=/usr/local/openssl:/lib:/lib64:/usr/local/readline/lib:/usr/local/zlib/lib:/usr/local/openssl/lib64:/usr/local/libxml2/lib:/usr/local/libxslt/lib \ --with-includes=/usr/local/readline/include:/usr/local/zlib/include:/usr/local/openssl/include:/usr/local/libxml2/include/libxml2/libxml:/usr/local/libxslt/include Now even though parser.h can be found in the includes path it claims: configure: error: header file libxml/parser.h is required for XML support Your include path contains /usr/local/libxml2/include/libxml2/libxml, so Postgres is probably looking for /usr/local/libxml2/include/libxml2/libxml/libxml/parser.h, which I suspect is wrong. Try removing the extra /libxml from the include path. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- ___ Peter Roethlisberger Suldhaltenstrasse 4 3703 Aeschi Switzerland 46°39'14 N 7°41'47 E Mobile: +41 (0)79 785 79 35 Fix: +41 (0)33 654 04 39 Skype:PeterRoethlisberger peter.roethlisber...@gmail.com -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres 32bit on Windows 64bit, related components
On Wed, Sep 8, 2010 at 9:29 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, Sep 8, 2010 at 03:31, Brendan Hill brend...@jims.net wrote: We're about to purchase a new server for our Postgres 8.4 database. We’d like to go with Windows 64bit for possible future developments, but are happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL, slony2 and libxml2, libpq. Also note that PostgreSQL 9.0 will be available natively 64-bit on Windows. Yeah, but Slony/PostGIS won't. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] PGDay.EU Logo required!
Hi, We need some help to either design a new logo, or spruce up the existing logo for PGDay.EU 2010. the European PostgreSQL conference. It needs to be related to PostgreSQL in some way of course, and needs to be in colours that will work when converted to black and white or when printed onto a T-Shirt. Otherwise, we're open to pretty much any idea - though of course, the final decision on what will be used will be down to the conference team. Does anyone want to give it a go? I've attached last year's logo in SVG (doesn't display well in some browsers, but does work in Inkscape) and PNG formats, updated with this years info as a starting point. Please let me know if you're going to work on something. Thanks! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company attachment: pgday.2010.draft2.pngattachment: pgday.2010.draft2.svg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Rescue data after power off
On Mon, Jul 19, 2010 at 5:57 PM, tuanhoanganh hatua...@gmail.com wrote: I have checked SHOW fsync, It is ON. When I view table dmvt on PgAdmin, it only has 1332 rows, but command SELECT count(*) FROM dmvt return 2449 rows. By default pgAdmin shows the number of rows listed in pg_class, which is not always accurate (for all but the smallest of tables). Right-click the table and select the count options to get an exact count. Normally, a large mismatch between those two values is a sign you need to vacuum the table. That may well not be the case if you're suffering from corruption though. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] simple functions, huge overhead, no cache
On Mon, Jul 12, 2010 at 7:06 AM, Craig Ringer cr...@postnewspapers.com.au wrote: It seems like a profiler, which is designed to filter and organize the collected data, and which can be attached only to specific functions that you want to know about, might be a better job. As there's already a PL/PgSQL debugger, some of the infrastructure required is already present. There's already a profiler in the same source tree. It just needs to be given a little love. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to download Non-Installer (ZIP) Postgres 8.3 for Windows?
On Fri, Jul 9, 2010 at 9:14 AM, Thomas Kellerer spam_ea...@gmx.net wrote: Hi, I'm trying to download the ZIP archive for Postgres 8.3 on Windows, but I can't find a download location where I do not need to register with EnterpriseDB When I go to http://www.enterprisedb.com/products/download.do and click on the Windows link for Postgres 8.3 I end up on the Please register page. Yes. That's because you didn't follow a link from postgresql.org. When I follow the download link from http://www.postgresql.org/download/ I wind up at http://www.enterprisedb.com/products/pgbindownload.do but there is no link to version 8.3 So how do I download the binaries only (no installer) bundle of Postgres 8.3 for windows? EnterpriseDB don't produce one for 8.3. There is a copy from the old MSI installer at http://www.postgresql.org/ftp/binary/v8.3.11/win32/, but it's not binary-compatible with the one-click installers (different integer-datetime settings). -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Problems with Vista and Windows 7
2010/7/8 el dorado do_ra...@mail.ru: Thank you for your answers. Well, the beginning of the story in details is here (http://archives.postgresql.org/pgsql-general/2010-06/msg01135.php). Shortly, I tried to use functions from my own dll, but got an error Could not open relation base\16123\16222: No such file or directory. Later I found out, using 'Process Monitor', that for some reason process 'postgres.exe' looked for this relation not in 'C:\PostgreSQL\8.4\data\base\16123\16222' but in 'C:\Users\postgres\AppData\Roaming\MyApplicationName\base\16123\16222' - certainly, there is no such file. Did you check, that registry key Data Directory is set properly in HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 folder? Usually I don't use standard Windows Installer but take binaries. So there is no such branch in registry. When I tried to make test and install it from Installer I got the same result. :( Data Directory was set to PG-specific application dir. So this is an issue with an extension of your own? Can you post the code? You'll have to excuse us being skeptical about PostgreSQL being fundamentally broken in the way you describe. The Windows installer alone is downloaded tens of thousands of times per week, so I'm pretty sure someone would have reported such an issue before now. And that's ignoring the vast amount of testing that goes into every release, including on 32 and 64 bit versions of XP through 7 and 2003 through 2008R2. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] CREATE PROCEDURAL LANGUAGE plpythonu on windows, with EDB's 8.4.2 installer causes error
On Thu, Jul 8, 2010 at 12:30 PM, Sim Zacks s...@compulab.co.il wrote: Postgresql 8.4 on windows (stackbuilder install) is compiled against Python 2.6, it is probably looking for the dll python26.dll and can't find it. To get it to work, you need to install python 2.6. Correct. We use the ActiveState distros of Python, Perl and TCL on Windows (and on the Linux builds from 9.0), but others should work too, provided they're the correct major version. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Open Source Forum Software using PostgreSQL?
On Sun, Jul 4, 2010 at 3:22 PM, CaT c...@zip.com.au wrote: On Sun, Jul 04, 2010 at 03:10:36PM +0100, Andre Lopes wrote: Hi, I need to use an Forum Software. There is any Open Souce Forum Script using PostgreSQL? phpBB3 off the top of my head. If using the one-click PostgreSQL installers, you can run StackBuilder to automatically install preconfigured builds of Apache, PHP and phpBB to work with the PG installation. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Looking for multithreaded build of libpq for Windows
On Tue, Jun 29, 2010 at 8:28 PM, MD mingdeng2...@gmail.com wrote: I found out the libpq.lib come with Postgres installer (8.4.4) is not thread-safe. Where can I find a thread-safe build? It's always thread-safe on Windows. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql
On Fri, Jun 25, 2010 at 12:04 AM, Wang, Mary Y mary.y.w...@boeing.com wrote: Hi, I'm trying to find some write-ups about the differences between Postgres and MySql. A lot of stuff showed up on Google, but most of them are old. I saw this wiki over here http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and plan to watch a recent webcast on PostgreSQL vs. MySQL that was offered by EnterpriseDB. If you mean the one from last week, then that would be a good choice. It's got our chief architect discussing the topic with our newest member of the EDB team, Robin Schumacher, who spent many years working in a senior product management position at MySQL. http://www.enterprisedb.com/learning/postgresql_vs_mysql.do -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql
On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wult...@gmail.com wrote: MySQL has several full text search solutions. The built in MyISAM solution is the best known, but there is also an engine for using sphinx. ... And there are features that MySQL has that PG does not. Index only queries is a massive feature. Pluggable backend storage engines are another. Some might argue that is not a feature. Sure, it means you can have different types of storage, but it means the feature set gets fragmented - for example, if you want text search, you use MyISAM, but if you want relational integrity you have to use InnoDB or some other backend. You want both? Oh. Hmmm. It could also be argued that having a storage engine API means that the query planner/optimiser cannot have nearly as much knowledge about how the data is stored and what access characteristics it may have thus preventing it from being as well optimised as Postgres. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql
On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown thombr...@gmail.com wrote: Didn't PostgreSQL used to have more than 1 storage engine in the past? I thought I read somewhere it did, but it was decided it was a compromise on stability and/or quality, so ended up using a single kick-ass engine? Yes, many, many moons ago. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql
On Fri, Jun 25, 2010 at 10:22 AM, A. Kretschmer andreas.kretsch...@schollglas.com wrote: In response to Dave Page : On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown thombr...@gmail.com wrote: Didn't PostgreSQL used to have more than 1 storage engine in the past? I thought I read somewhere it did, but it was decided it was a compromise on stability and/or quality, so ended up using a single kick-ass engine? Yes, many, many moons ago. Really? Do you have a link? Hmm, I think I misread Thom's question. The smgr API used to be far more rigidly designed as I understand it, to allow the possibility of having different storage engines (for example, maybe one that used raw devices). I don't know that any other storage engines were ever actually written though. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql
On Fri, Jun 25, 2010 at 2:02 PM, Jim Montgomery monty1...@hotmail.com wrote: Remove me from your email chain. You need to unsubscribe from the mailing list. Until now your weren't explicitly included on any of the messages that I can see. http://www.postgresql.org/community/lists/ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Hide the code from users postgres
On Thu, Jun 24, 2010 at 10:08 PM, Joshua D. Drake j...@commandprompt.com wrote: On Fri, 2010-06-25 at 00:00 +0300, Allan Kamau wrote: Seems akp would like to hide/protect (including his name) his hard earned code/IP which may have consumed some man-hours, which to run, requires well built and generously given PostgreSQL code which has taken man-decades to develop. And what is wrong with that? PostgreSQL has a licence that is intended to work well with open and closed source works, and it is up to the individual user to decide how they want to licence their apps built on it. I have no problem with him trying to protect his hard earned work. I just think he is trying to solve the wrong problem. It's a real problem faced by many businesses and solved by most commercial DBMSs. Of course, it's basically impossible to solve in the Open Source world, as there's nowhere to hide a key or obfuscation algorithm. If akp geek is able to use EnterpriseDB builds of Postgres, then he may want to look at PL/Secure, which will obfuscate his pl/pgsql code: http://www.enterprisedb.com/products/pl_secure_standard_server.do -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Hide the code from users postgres
On Thu, Jun 24, 2010 at 10:20 PM, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2010-06-24 at 22:18 +0100, Dave Page wrote: I have no problem with him trying to protect his hard earned work. I just think he is trying to solve the wrong problem. It's a real problem faced by many businesses and solved by most commercial DBMSs. Of course, it's basically impossible to solve in the Open Source world, as there's nowhere to hide a key or obfuscation algorithm. If akp geek is able to use EnterpriseDB builds of Postgres, then he may want to look at PL/Secure, which will obfuscate his pl/pgsql code: http://www.enterprisedb.com/products/pl_secure_standard_server.do That's interesting... does it just turn it into bytecode? No, it runs it through a few different obfuscation algorithms to make it very difficult to decode without knowledge of them. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Hide the code from users postgres
On Thu, Jun 24, 2010 at 10:59 PM, Allan Kamau kamaual...@gmail.com wrote: Perhaps (I could be wrong here), there may be a way (even though I don't really support the obfuscation, vendor lockup etc... idea). 1)Use a commercial DB (as mentioned previously), they seem to have provided for this. 2)Use PostgreSQL and write all code into C functions and complied to a given PostgreSQL installation. You could do that. It's not exactly productive to write/rewrite all your functions in C if pl/pgsql will work though, plus it means you need to compile separate binaries for each for each platform your customers use, and upgrades can no longer be pure SQL scripts, as you'll also need to ship new object files and install them on the database server. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] libpython - cannot open shared object file
On Wed, Jun 23, 2010 at 9:52 AM, Tom Wilcox hungry...@gmail.com wrote: Hi, I have not used python2.3 on this machine at all (to my knowledge). It is a fresh install of the latest Ubuntu 64 which comes with Python 2.6 and 3.1. The build I want to run is the 64-bit PostgreSQL download for Linux x86-64 from Entreprise DB (http://www.enterprisedb.com/products/pgdownload.do) as I don't know how else to ensure that the build I am installing is a 64-bit version of PostgreSQL (I want to use 4GB of RAM in one session). Is the best way to ensure compatibility for me to build from source? If you want it to use the version of Python installed with your OS, then you should just use the OS packages. The installer needs to run on a wide variety of distros, so is built on a much older platform which happens to have Python 2.3. FYI, the 9.0 installers are being built against ActiveState's Perl, Python and TCL distros, so it will be easier to use those PLs in the future. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] libpython - cannot open shared object file
On Wed, Jun 23, 2010 at 10:19 AM, Tom Wilcox hungry...@gmail.com wrote: Hi, If I use the apt-get facility on Ubuntu is that supposed to get the appropriate postgres version for my OS setup (i.e. 64-bit and Python 2.6) ? I would assume so. I'm more of a Redhat guy though. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unable to install pg in Win (MVR error)
On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote: Hi All, As shown in the following screenshot I couldn't install pg in Windows because it couldn't install Microsoft VC++ Runtime! How I can fix this issue? If you already have the right version (VC++ 2005 SP1) of the runtimes installed, you could run the installer with the option: --install_runtimes 0 to skip the runtime installation. If you don't have them, or have the wrong version, the installer will almost certainly fail later on. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company
Re: [GENERAL] Unable to install pg in Win (MVR error)
On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote: On 14/06/2010 08:43 م, Dave Page wrote: On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote: Hi All, As shown in the following screenshot I couldn't install pg in Windows because it couldn't install Microsoft VC++ Runtime! How I can fix this issue? If you already have the right version (VC++ 2005 SP1) of the runtimes installed, you could run the installer with the option: --install_runtimes 0 to skip the runtime installation. I tried to run pg installer with --install_runtimes 0 but I got warning message tell me that database cluster failed does this problem related to wrong MVR? if yes how I can fix this issue? do I need to remove installed MVR (I didn't find it in Add or Remove Programs list)? Install the correct runtimes version (you don't need to uninstall any existing ones). This should do: http://www.microsoft.com/downloads/details.aspx?displaylang=enFamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647 BTW, what language does your copy of Windows run in? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company
Re: [GENERAL] Unable to install pg in Win (MVR error)
On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote: Wow, I catch installer bug. This problem related to executing .vbs files because of that whole installing process failed. In the attachment will find that Bitrock installer unable to run .vbs script because in my PC I specified .vbs file association with notepad. For that I could install pg successfully on another PC. I think this problem should not be exists in the installer because many script editors associate .vbs files by default, is it right? If yes where I can report a bug for this issue? I'm not sure it's the file association that is causing the problem, because we explicitly pass the filename to the script interpreter rather than relying on ShellExecute. If that were the issue, you would see the script pop up in notepad. However, the log does perhaps give us a clue. Ashesh - would you mind investigating further please? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company Log started 06/15/10 at 01:01:06 Preferred installation mode : qt Trying to init installer in mode qt Mode qt successfully initialized Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Data Directory. Setting variable iDataDirectory to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Base Directory. Setting variable iBaseDirectory to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Service ID. Setting variable iServiceName to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Service Account. Setting variable iServiceAccount to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Super User. Setting variable iSuperuser to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Branding. Setting variable iBranding to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Version. Setting variable brandingVer to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 Shortcuts. Setting variable iShortcut to empty value Could not find registry key HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4 DisableStackBuilder. Setting variable iDisableStackBuilder to empty value [01:01:55] Existing base directory: [01:01:55] Existing data directory: [01:01:55] Using branding: PostgreSQL 8.4 [01:01:55] Using Super User: postgres and Service Account: postgres [01:01:56] Using Service Name: postgresql-8.4 Executing cscript //NoLogo C:\Documents and Settings\Bashir\Local Settings\Temp\postgresql_installer\installruntimes.vbs C:\Documents and Settings\Bashir\Local Settings\Temp\postgresql_installer\vcredist_x86.exe Script exit code: 1 Script output: Input Error: There is no script engine for file extension .vbs. Script stderr: Program ended with an error exit code An error occured executing the Microsoft VC++ runtime installer. attachment: admin.vcf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb
On Mon, Jun 7, 2010 at 11:24 AM, Amber guxiaobo1...@gmail.com wrote: Hi , The installer has an error dealing with directory separator char on windows platform, it seems the installer causes the server looking for configuration file path with /, it should be \. Hoping Enterprisedb engineers can see this message. / works just fine on Windows. What is the actual problem you are seeing, as opposed to the perceived cause? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb
Ashesh, Can you take a look at this please? I wonder is there's an issue with the data directory being on the D drive. Thanks. On Mon, Jun 7, 2010 at 11:41 AM, Amber guxiaobo1...@gmail.com wrote: When running the installer, there is a warning, Problem running post-install step. Installation may not complete correctly Error reading file D:/amber/program/postgresql/8.4/data/postgres.conf When start the service, the following entry is written in windows event log D:/Amber/Program/PostgreSQL/8.4/data/postgresql.conf: No such file or directory On Mon, Jun 7, 2010 at 6:28 PM, Dave Page dp...@pgadmin.org wrote: On Mon, Jun 7, 2010 at 11:24 AM, Amber guxiaobo1...@gmail.com wrote: Hi , The installer has an error dealing with directory separator char on windows platform, it seems the installer causes the server looking for configuration file path with /, it should be \. Hoping Enterprisedb engineers can see this message. / works just fine on Windows. What is the actual problem you are seeing, as opposed to the perceived cause? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about Beta for Windows 64 bits
On Thu, May 13, 2010 at 3:03 PM, Igor Neyman iney...@perceptron.com wrote: Will 9.0 also have 64-bit ODBC driver? Eventually. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about Beta for Windows 64 bits
Psqlodbc already supports 64bit. We just need to package it for win64. On 5/13/10, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2010-05-13 at 19:08 +0200, Magnus Hagander wrote: On Thu, May 13, 2010 at 7:01 PM, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2010-05-13 at 15:15 +0100, Dave Page wrote: On Thu, May 13, 2010 at 3:03 PM, Igor Neyman iney...@perceptron.com wrote: Will 9.0 also have 64-bit ODBC driver? Eventually. What would be the benefit? We considered it with ODBCng but couldn't find any real suitable purpose. Linking it into 64-bit applications would be the obvious one, no? True. I think it is going to be tough to get on going support for a 64bit driver. Shrug :) Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about Beta for Windows 64 bits
On Wed, May 12, 2010 at 1:41 AM, Luis Guillermo Dangel luisguillermo.dan...@gmail.com wrote: Hi guys. I downloaded the windows installer for the Beta version, and noticed when installing that it was installing in the 32 bits program files folder. Is there an installer of PostgreSQL 64 bits for windows? Not yet. It's being worked on. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about Beta for Windows 64 bits
On Wed, May 12, 2010 at 4:12 PM, Igor Neyman iney...@perceptron.com wrote: Dave, Are there any plans to build 8.4... As 64 bit for Windows? 8.4 cannot be built for 64 bit Windows. Thats only supported with 9.0 and above. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgres crashes - could not reattach to shared memory
On Sun, May 2, 2010 at 8:27 AM, Sofer, Yuval yuval_so...@bmc.com wrote: Hi Postgres crashes with - PG FATAL: could not reattach to shared memory (key=5432001, addr=0210): Invalid argument. The version is 8.2.4, the platform is win32 Does someone know the reason/workaround ? This was fixed in 8.3.8 and 8.4.1. I'm not entirely sure why it didn't get backpatched to 8.2 - it was mentioned in the discussion about the patch, but I don't see any reason for not back patching it stated. http://archives.postgresql.org/pgsql-hackers/2009-07/thrd5.php#00782 Even if it were fixed, you would need a much newer build than 8.2.4. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgres crashes - could not reattach to shared memory
On 5/2/10, Tom Lane t...@sss.pgh.pa.us wrote: Dave Page dp...@pgadmin.org writes: On Sun, May 2, 2010 at 8:27 AM, Sofer, Yuval yuval_so...@bmc.com wrote: PG FATAL: could not reattach to shared memory (key=5432001, addr=0210): Invalid argument. The version is 8.2.4, the platform is win32 This was fixed in 8.3.8 and 8.4.1. I'm not entirely sure why it didn't get backpatched to 8.2 - it was mentioned in the discussion about the patch, but I don't see any reason for not back patching it stated. http://archives.postgresql.org/pgsql-hackers/2009-07/thrd5.php#00782 The patch that was being worked on at the time wouldn't have come close to applying to 8.2, because the win32 shmem code got rearranged very substantially for 8.3. However, AIUI it's the same underlying technology, so in principle it could be fixed the same way. Right - thats what i was expecting to see. If we take seriously the proposition that we're still supporting 8.2 on Windows, we probably ought to do something about that. If we don't, we need to officially deprecate that version. That's the last non-msvc++ version. Personally I'd love to drop it so i can get rid of mingw/msys and move entirely to vc++ for Win32 and Win64. I'm not so sure it's fair to the users though. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general