[GENERAL] PostgreSQL Code of Conduct Draft

2017-02-14 Thread Dave Page
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

Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?

2014-07-03 Thread Dave Page
, 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

Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?

2014-07-03 Thread Dave Page
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

Re: [GENERAL] Windows releases - Bundle OpenSSL includes and .libs in the installer?

2014-07-03 Thread Dave Page
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

[GENERAL] Anyone from the US coming to FOSDEM?

2012-12-06 Thread Dave Page
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

Re: Fw: [GENERAL] Postgresql on Windows 8

2012-11-22 Thread Dave Page
? 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

Re: [GENERAL] EDB installer should check for valid %COMSPEC%

2012-11-19 Thread Dave Page
% 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

Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file?

2012-08-17 Thread Dave Page
. 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

Re: [GENERAL] PG Installer - Licensing Issues

2012-08-15 Thread Dave Page
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

Re: [GENERAL] Check PostgreSQL status using MS-DOS bat file?

2012-08-15 Thread Dave Page
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

Re: [GENERAL] [pgeu-general] FOSDEM booth volunteer

2012-01-29 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-05 Thread Dave Page
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

[GENERAL] PostgreSQL Conference Europe: Are you ready?

2011-10-04 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-04 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-04 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-03 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-03 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-03 Thread Dave Page
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

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-03 Thread Dave Page
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

[GENERAL] PostgreSQL Core Team

2011-04-27 Thread Dave Page
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

Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)

2010-12-05 Thread Dave Page
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

[GENERAL] Just 2 days left to register for PGDay.EU 2010

2010-11-24 Thread Dave Page
, 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

Re: [GENERAL] Why facebook used mysql ?

2010-11-09 Thread Dave Page
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

Re: [GENERAL] Why facebook used mysql ?

2010-11-09 Thread Dave Page
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

Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)

2010-11-08 Thread Dave Page
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

Re: [GENERAL] Linux

2010-11-04 Thread Dave Page
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

Re: [GENERAL] Please Help...

2010-11-04 Thread Dave Page
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

Re: [GENERAL] Unhandled exception in PGAdmin when opening 16-million-record table

2010-10-30 Thread Dave Page
. 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

Re: [GENERAL] Unhandled exception in PGAdmin when opening 16-million-record table

2010-10-30 Thread Dave Page
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

Re: [GENERAL] 9.0.1-1 windows install VC++ 2008 redistributalbe warning

2010-10-29 Thread Dave Page
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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-25 Thread Dave Page
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] PGDay Europe 2010 schedule announced

2010-10-25 Thread Dave Page
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

Re: [GENERAL] createlang plpythonu fails on 64bit windows

2010-10-24 Thread Dave Page
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

Re: [GENERAL] 9.0 SSL renegotiation failure restoring data

2010-10-21 Thread Dave Page
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

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
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

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
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

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
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

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
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

Re: [GENERAL] Need some help setting up pgAgent

2010-10-18 Thread Dave Page
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

Re: [GENERAL] Understanding PostgreSQL Storage Engines

2010-10-13 Thread Dave Page
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

Re: [GENERAL] Understanding PostgreSQL Storage Engines

2010-10-13 Thread Dave Page
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

Re: [GENERAL] NoSQL -vs- SQL

2010-10-12 Thread Dave Page
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

Re: [GENERAL] postgreSQL for Windows 7

2010-10-08 Thread Dave Page
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

[GENERAL] PGDay.EU 2010 Call for Papers ending soon!

2010-10-07 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-10-07 Thread Dave Page
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

Re: [GENERAL] Missing uuid_generate_v1()

2010-10-07 Thread Dave Page
-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

Re: [GENERAL] Problem installing 9.0.1 on Windows 7 x64

2010-10-05 Thread Dave Page
. 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

Re: [GENERAL] Problem installing 9.0.1 on Windows 7 x64

2010-10-05 Thread Dave Page
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

Re: [GENERAL] pgadmin from 9.0RC1 in 8.2.4 status cannot cast type xid to text error

2010-10-04 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-10-01 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-10-01 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-10-01 Thread Dave Page
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

Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

2010-10-01 Thread Dave Page
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

Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

2010-10-01 Thread Dave Page
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

Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

2010-10-01 Thread Dave Page
: /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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-09-30 Thread Dave Page
. 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

Re: [GENERAL] ossp-uuid missing from one click windows x64 builds

2010-09-30 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

2010-09-30 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken

2010-09-29 Thread Dave Page
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

Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

2010-09-29 Thread Dave Page
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

Re: [GENERAL] Optimizing postgresql.conf for dedicated windows server 2003 x64 standard edition

2010-09-29 Thread Dave Page
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

Re: [GENERAL] Missing path in pg_config

2010-09-29 Thread Dave Page
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

Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken

2010-09-28 Thread Dave Page
/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

Re: [GENERAL] PostgreSQL 9 Mac OS X one-click install - PL/perl broken

2010-09-28 Thread Dave Page
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

Re: [GENERAL] Database Cluster Initialisation Failed error during PostgreSQL install

2010-09-27 Thread Dave Page
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

Re: [GENERAL] Database Cluster Initialisation Failed error during PostgreSQL install

2010-09-27 Thread Dave Page
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

Re: [GENERAL] Installing Contrib Modules with a Precompiled Binary

2010-09-20 Thread Dave Page
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

Re: [GENERAL] Installing Contrib Modules with a Precompiled Binary

2010-09-20 Thread Dave Page
- 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

Re: [GENERAL] configure: error: header file libxml/parser.h is required for XML support

2010-09-15 Thread Dave Page
/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

Re: [GENERAL] configure: error: header file libxml/parser.h is required for XML support

2010-09-15 Thread Dave Page
, 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

Re: [GENERAL] Postgres 32bit on Windows 64bit, related components

2010-09-08 Thread Dave Page
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

[GENERAL] PGDay.EU Logo required!

2010-07-29 Thread Dave Page
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

Re: [GENERAL] Rescue data after power off

2010-07-19 Thread Dave Page
. -- 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

2010-07-12 Thread Dave Page
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

Re: [GENERAL] How to download Non-Installer (ZIP) Postgres 8.3 for Windows?

2010-07-09 Thread Dave Page
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

Re: [GENERAL] Problems with Vista and Windows 7

2010-07-08 Thread Dave Page
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

2010-07-08 Thread Dave Page
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

Re: [GENERAL] Open Source Forum Software using PostgreSQL?

2010-07-04 Thread Dave Page
, 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

Re: [GENERAL] Looking for multithreaded build of libpq for Windows

2010-06-30 Thread Dave Page
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

Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

2010-06-25 Thread Dave Page
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

Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

2010-06-25 Thread Dave Page
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

2010-06-25 Thread Dave Page
? 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

2010-06-25 Thread Dave Page
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

Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

2010-06-25 Thread Dave Page
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

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
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

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
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

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
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

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Dave Page
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

Re: [GENERAL] libpython - cannot open shared object file

2010-06-23 Thread Dave Page
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

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread Dave Page
) 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

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread Dave Page
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

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread Dave Page
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

Re: [GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb

2010-06-07 Thread Dave Page
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

Re: [GENERAL] Error in 8.4.4-1 of windows installer from Enterprisedb

2010-06-07 Thread Dave Page
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

Re: [GENERAL] Question about Beta for Windows 64 bits

2010-05-13 Thread Dave Page
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

Re: [GENERAL] Question about Beta for Windows 64 bits

2010-05-13 Thread Dave Page
: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

Re: [GENERAL] Question about Beta for Windows 64 bits

2010-05-12 Thread Dave Page
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

2010-05-12 Thread Dave Page
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

Re: [GENERAL] postgres crashes - could not reattach to shared memory

2010-05-02 Thread Dave Page
, 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

2010-05-02 Thread Dave Page
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

  1   2   3   4   5   6   7   >