[GENERAL] PostgreSQL Code of Conduct Draft

2017-02-14 Thread Dave Page
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
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 wrote: > >&g

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

2014-07-03 Thread Dave Page
gt; 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 wrote: > >> Sandeep, how much effort is it to do this? >> >> On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer >> wrote: &

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

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

[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 (

Re: Fw: [GENERAL] Postgresql on Windows 8

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

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

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

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

2012-08-17 Thread Dave Page
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: [GE

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

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

Re: [GENERAL] PG Installer - Licensing Issues

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

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

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

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 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

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 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 i

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 wrote: > On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer 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

[GENERAL] PostgreSQL Conference Europe: Are you ready?

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

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

2011-10-03 Thread Dave Page
ete > 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: @p

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 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 o

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

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

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

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

[GENERAL] PostgreSQL Core Team

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

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

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

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

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

Re: [GENERAL] Why facebook used mysql ?

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

Re: [GENERAL] Why facebook used mysql ?

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

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

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

Re: [GENERAL] Please Help...

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

Re: [GENERAL] Linux

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

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

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

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

2010-10-30 Thread Dave Page
he > 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://pgsnak

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

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

[GENERAL] PGDay Europe 2010 schedule announced

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

Re: [GENERAL] Missing uuid_generate_v1()

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

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

2010-10-24 Thread Dave Page
2bit 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.blog

Re: [GENERAL] 9.0 SSL renegotiation failure restoring data

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

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 wrote: > On Mon, Oct 18, 2010 at 3:07 AM, Dave Page wrote: >> On Mon, Oct 18, 2010 at 10:46 AM, Mike Christensen >> wrote: >>> Okay I found one that I can use.. >>> >>> One question..  Should th

Re: [GENERAL] Need some help setting up pgAgent

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

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 wrote: > On Mon, Oct 18, 2010 at 2:34 AM, Dave Page wrote: >> On Mon, Oct 18, 2010 at 10:31 AM, Mike Christensen >> wrote: >>> Sorry, it looks like it defaulted to the wrong DB.  I created the >>> schema in

Re: [GENERAL] Need some help setting up pgAgent

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

Re: [GENERAL] Need some help setting up pgAgent

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

Re: [GENERAL] Understanding PostgreSQL Storage Engines

2010-10-13 Thread Dave Page
On Wed, Oct 13, 2010 at 1:11 PM, Thom Brown wrote: > On 13 October 2010 12:35, Dave Page wrote: >> On Wed, Oct 13, 2010 at 12:29 PM, Ron Mayer >> wrote: >>> Pavel Stehule wrote: >>>> 2010/10/8 Carlos Mennens : >>>>> I know that MySQL uses MyI

Re: [GENERAL] Understanding PostgreSQL Storage Engines

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

Re: [GENERAL] NoSQL -vs- SQL

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

Re: [GENERAL] postgreSQL for Windows 7

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

Re: [GENERAL] Missing uuid_generate_v1()

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

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

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

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

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

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

2010-10-05 Thread Dave Page
#x27;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.b

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

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

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

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

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

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

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 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.

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

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

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 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 &

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 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), an

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 wrote: > Dave Page writes: > >> A couple of questions for

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 wrote: > Dave Page writes: > >> On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt wrote: >>> Hi Dharmendra, >>> >>> thanks for your reply. This kind of errors, which cannot be reproduced >>> o

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

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

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

Re: [GENERAL] Missing path in pg_config

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

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

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

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

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

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 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

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 wrote: > > On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" 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 th

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

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

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

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

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

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

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] Installing Contrib Modules with a Precompiled Binary

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

Re: [GENERAL] configure: error: header file is required for XML support

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

Re: [GENERAL] configure: error: header file is required for XML support

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

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

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

[GENERAL] PGDay.EU Logo required!

2010-07-29 Thread Dave Page
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 <><> -- Sent via pgsql-general mailing list (

Re: [GENERAL] Rescue data after power off

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

Re: [GENERAL] simple functions, huge overhead, no cache

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

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

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

Re: [GENERAL] CREATE PROCEDURAL LANGUAGE plpythonu on windows, with EDB's 8.4.2 installer causes error

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

Re: [GENERAL] Problems with Vista and Windows 7

2010-07-08 Thread Dave Page
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] Open Source Forum Software using PostgreSQL?

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

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 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 Postg

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 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 Enterpr

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 wrote: > In response to Dave Page : >> On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown wrote: >> >> > Didn't PostgreSQL used to have more than 1 storage engine in the past? >> >  I thought I read somewhe

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
ave 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

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

Re: [GENERAL] Hide the code from users postgres

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

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 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'

Re: [GENERAL] Hide the code from users postgres

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

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 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 Pag

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

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

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

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

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 wrote: > On 14/06/2010 08:43 م, Dave Page wrote: > > > > On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi wrote: > >> Hi All, >> >> >> As shown in the following screenshot I couldn't insta

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

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

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

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

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

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

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

2010-05-13 Thread Dave Page
Psqlodbc already supports 64bit. We just need to package it for win64. On 5/13/10, Joshua D. Drake 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 >> wrote: >> > On Thu, 2010-05-13 at 15:15 +0100, D

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 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 y

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 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 Enterpr

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

2010-05-12 Thread Dave Page
ostgreSQL  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] postgres crashes - could not reattach to shared memory

2010-05-02 Thread Dave Page
On Sun, May 2, 2010 at 7:41 PM, Tom Lane wrote: > Dave Page writes: >> On 5/2/10, Tom Lane wrote: >> I'm not so sure it's fair to the users though. > > Well, we did promise that Windows 8.2 would have the same lifespan as > 8.2 on other platforms: > htt

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

2010-05-02 Thread Dave Page
On 5/2/10, Tom Lane wrote: > Dave Page writes: >> On Sun, May 2, 2010 at 8:27 AM, Sofer, Yuval wrote: >>> PG "FATAL: could not reattach to shared memory (key=5432001, >>> addr=0210): Invalid argument. >>> >>> The version is 8.2.4, the

  1   2   3   4   5   6   7   >