[GENERAL] RE: [ODBC] Visual Basic and PostgreSQL ODBC

2001-08-05 Thread Dave Page
-Original Message- From: Ryan C. Bonham [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 18:00 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [ODBC] Visual Basic and PostgreSQL ODBC Hi, Ok I have a problem, that I need to find a fix or workaround for. I have a

[GENERAL] pgAdmin III - Call for Translators

2003-07-02 Thread Dave Page
As many of you already know, pgAdmin is a widely used Open Source GUI Management tool for PostgreSQL, similar to DB2's Control Center or SQL Server's Enterprise Manager. We are currently working on the next generation pgAdmin III, with the aim of releasing it at approximately the same time as

Re: [GENERAL] vista

2006-09-19 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: 19 September 2006 05:43 To: Ron Johnson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] vista Ron Johnson [EMAIL PROTECTED] writes: On 09/18/06 22:32, Joshua D. Drake

Re: [GENERAL] vista

2006-09-19 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Naz Gassiep Sent: 19 September 2006 12:26 To: Tom Lane Cc: Ron Johnson; pgsql-general@postgresql.org Subject: Re: [GENERAL] vista The scratch your own itch line can only be pushed so far, if

Re: [GENERAL] vista

2006-09-19 Thread Dave Page
-Original Message- From: Naz Gassiep [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 14:06 To: Dave Page Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org Subject: Re: [GENERAL] vista That's important and we acknowledge the need. Even in the absence of any progress

Re: [GENERAL] vista

2006-09-19 Thread Dave Page
-Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: 19 September 2006 15:10 To: Alban Hertroys Cc: Dave Page; Naz Gassiep; Tom Lane; Ron Johnson; pgsql-general@postgresql.org Subject: Re: [GENERAL] vista If Vista is so important, why aren't seeing

Re: [GENERAL] vista

2006-09-19 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Sent: 19 September 2006 17:03 To: Naz Gassiep Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org Subject: Re: [GENERAL] vista Perhaps many of the core developers don't care if windows

Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

2006-10-10 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake Sent: 10 October 2006 15:28 To: Jim C. Nasby Cc: Ravindran G - TLS, Chennai.; pgsql-general@postgresql.org; Hari Krishna D - TLS , Chennai; Sasikala V - TLS , Chennai Subject:

Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues

2006-10-10 Thread Dave Page
-Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: 10 October 2006 17:11 To: Dave Page Cc: Jim C. Nasby; pgsql-general@postgresql.org Subject: Re: [GENERAL] [PERFORM] Postgre 8.0 Installation - Issues That reminds me Bob - did you see my email about

Re: [GENERAL] List of supported 64bit OS

2006-10-12 Thread Dave Page
On 12/10/06 21:14, Joshua D. Drake [EMAIL PROTECTED] wrote: Marc G. Fournier wrote: All of them ... ? At least, I'm not aware of any that PostgreSQL *doesn't* support ... Win32 is not supported on 64bit IIRC. Should be no problem with the win32 build on 64 bit Windows. What we don't

Re: [SQL] [GENERAL] Is there anyway to...

2006-11-02 Thread Dave Page
imad wrote: Or you can probably use a PostgreSQL administration tool for scheduled jobs. I know a number of such tools which provide this feature and EnterpriseDB Management Server is one of them. As is pgAdmin's pgAgent. Regards, Dave ---(end of

Re: [GENERAL] Trouble migrating from PostgreSQL -- Oracle

2006-11-14 Thread Dave Page
--- Original Message --- From: Jeff Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: 14/11/06, 19:05:33 Subject: Re: [GENERAL] Trouble migrating from PostgreSQL -- Oracle Use pg_dump if you still have problems with PgAdmin, and make sure you're connecting as

Re: [GENERAL] Editing contrib modules which are loaded by default?

2006-11-28 Thread Dave Page
--- Original Message --- From: Richard Huxton dev@archonet.com To: novnov [EMAIL PROTECTED] Sent: 28/11/06, 18:56:37 Subject: Re: [GENERAL] Editing contrib modules which are loaded by default? Because I just don't believe that the installer doesn't let you turn the cube contrib

Re: [GENERAL] PG Admin

2006-12-05 Thread Dave Page
Bob Pawley wrote: This is basically what I have done. However it is not particularly stable and is inelegant. The serial number is close to what I need except it becomes tied to the information. The row numbering on the PG Admin version 1.6.1 performs the same operation that I am looking

Re: [GENERAL] installation problem, for Postgres 8.2.0

2006-12-11 Thread Dave Page
Shoaib Mir wrote: Logged in as 'root' user do the following: ln -s /usr/lib/libreadline.so.4 /usr/lib/libreadline.so.5 And then continue with the installation I'm no RPM expert, but doesn't a failed RPM dependency require that you install the correct RPM rather than adding

Re: [GENERAL] Status of SSL encryption in ODBC driver

2006-12-11 Thread Dave Page
John McCawley wrote: I did a few searches on the mailing list, and checked the documentation of psqlODBC, and I'm confused as to the current status of SSL support in psqlODBC. From the mailing list, it appears that the Open Source driver does not fully support SSL, and I would need to use the

Re: [GENERAL] Status of SSL encryption in ODBC driver

2006-12-11 Thread Dave Page
John McCawley wrote: Where would I go to find the connection string settings to turn it on? I have dug around quite a bit, and tried everything I have found, but nothing seems to work, and the docs included with the driver don't seem to cover it. The easy method is to setup a DSN as

Re: [GENERAL] Backup Restore

2006-12-28 Thread Dave Page
Shoaib Mir wrote: Well I haven't use much of PGAdmin but I will always be using pg_dump and pg_restore for that as they are really easy to use. You can find help on backup and restore at -- http://www.postgresql.org/docs/8.2/static/backup.html pgAdmin is just a frontend to

Re: [GENERAL] Backup Restore

2006-12-28 Thread Dave Page
Bob Pawley wrote: I'm not getting an error message. The restore utility just doesn't see the backup file. It's looking for a file *.backup which is there but noot seen. It's a standard file dialogue as provided by your operating system. I can't think of any reason it wouldn't see the file

Re: [GENERAL] Backup Restore

2006-12-29 Thread Dave Page
Bob Pawley wrote: When I change it to view all files it's there - but it won't do anything. So I assume you've used a different extension than the one the dialogue is expecting by default? When you say it won't do anything. do you mean you cannot select the file, or that nothing happens

Re: [GENERAL] Backup Restore

2006-12-29 Thread Dave Page
Bob Pawley wrote: Hi Dave I can get the restore working if I dump the project spelling out *.backup and not relying on the default. However the restore is being aborted due to a pk error for the spatial coordinates. I've removed the gis feature from both applications but still get the

Re: [GENERAL] Slony in Windows installer?

2007-01-08 Thread Dave Page
--- Original Message --- From: Raymond O'Donnell [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 1/8/07, 5:57:59 PM Subject: [GENERAL] Slony in Windows installer? Hello all, When installing PostgreSQL via the Windows installer, Slony-I is one of the options offered.

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-08 Thread Dave Page
--- Original Message --- From: Ian Harding [EMAIL PROTECTED] To: Jeffrey Melloy [EMAIL PROTECTED] Sent: 1/8/07, 7:06:31 PM Subject: Re: [GENERAL] is there a tracking trace tool like the SQL Analizer in MS sqlserver.? I thought that was called SQL Profiler.

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-08 Thread Dave Page
--- Original Message --- From: Jeffrey Melloy [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 1/8/07, 8:18:02 PM Subject: Re: [GENERAL] is there a tracking trace tool like the SQL Analizer How long has that been available for OS X? Last time I looked at it it wasn't. 2

Re: [GENERAL] is there a tracking trace tool like the SQL Analizer

2007-01-09 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Harald Armin Massa [EMAIL PROTECTED] Sent: 1/9/07, 7:15:52 PM Subject: Re: [GENERAL] is there a tracking trace tool like the SQL Analizer Harald Armin Massa wrote: Jeffrey, Not exactly. SQL Analyzer also

Re: [GENERAL] Process won't start in Windows

2007-01-17 Thread Dave Page
Raymond O'Donnell wrote: Robert Fitzpatrick wrote: Thanks, yes, I verified the services has 'postgres' as the account being used under the Log On tab of the PostgreSQL service. But still, the service will not start with the administrative permissions error previously posted. Any other

Re: [GENERAL] [ANNOUNCE] == PostgreSQL Weekly News - January

2007-01-22 Thread Dave Page
Bruce Momjian wrote: David Fetter wrote: On Mon, Jan 22, 2007 at 10:17:05AM -0300, Alvaro Herrera wrote: David Fetter wrote: EnterpriseDB is now offering support packages for the main branch of PostgreSQL. http://www.enterprisedb.com/products/postgre_pricing.do Huh, it's interesting that

Re: [GENERAL] Can you specify the pg_xlog location from a config

2007-01-26 Thread Dave Page
Karen Hill wrote: Windows doesn't support symlinks. Is it possible instead for there to be a config file that lets one set where the pg_xlog directory will sit? You can use a junction point for this instead of a symlink. Google for utilities to create them. Regards, Dave.

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-27 Thread Dave Page
Bill Moran wrote: Does the PostgreSQL project have any similar policy about EoLs? Even just a simple statement like, it is our goal to support major branches for 2 years after release or some such? I've been considering only maintaining the current and previous 2 versions in pgInstaller (the

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-28 Thread Dave Page
Oisin Glynn wrote: My 8.2c, Having 8.1 end of life this soon after the release of 8.2 seems pretty harsh. Yeah, I agree. In part I'm basing the idea to support the current and 2 previous branches on the amount of work required to build a complete set of point releases in one go - 3 seems

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-28 Thread Dave Page
--- Original Message --- From: Peter Eisentraut [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 28/01/07, 17:39:00 Subject: Re: [GENERAL] Predicted lifespan of different PostgreSQL branches Dave Page wrote: Also, three just seems like a sensible number to maintain. I

Re: [GENERAL] Predicted lifespan of different PostgreSQLbranches

2007-01-29 Thread Dave Page
--- Original Message --- From: Bruce Momjian [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 29/01/07, 21:12:30 Subject: Re: [GENERAL] Predicted lifespan of different PostgreSQLbranches I am pretty amazed people are considering shortening the release cycle for our most

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-01 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Bill Moran [EMAIL PROTECTED] Sent: 01/02/07, 17:13:25 Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32 Bill Moran wrote: Will only apply if you connect via loopback networking (which is not

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-01 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Magnus Hagander [EMAIL PROTECTED], pgsql-general@postgresql.org Sent: 01/02/07, 18:38:22 Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32 I imagine you guys are using it for the pg_restore/pg_dump?

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-01 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 01/02/07, 20:17:00 Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32 I won't deny I have it installed :-) I don't remember using the stored password option though

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-01 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 01/02/07, 20:37:18 Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32 Dave Page wrote: A non-admin user wouldn't necessarily be able to edit it, and it would

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-01 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 01/02/07, 21:18:49 Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32 I may be forced to start deleting the pgpass file unless we can work something out. I must

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Tony Caduto wrote: Dave Page wrote: I am sorry, but I believe the way pgAdmin III is using the pgpass file is TOTALLY WRONG, sorry but it just is. Actually, no, it's using it *exactly as it's documented* - which is not unlike any other win32 app. For example, if you use the IE ActiveX

Re: [GENERAL] Query optimization problem

2007-02-02 Thread Dave Page
Richard Huxton wrote: Peter wrote: Query returned successfully with no result in 600 ms. Why SELECT takes 3+ second to execute? Is it something to do with my Postgres server optimization, or PgAdmin does not show correct data retrieval runtime (leaks over into query runtime or something)?

[GENERAL] Re: pgAdmin III and pgpass was I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Tony Caduto wrote: Dave Page wrote: Actually, no, it's using it *exactly as it's documented* - which is not unlike any other win32 app. For example, if you use the IE ActiveX control to display web pages in your app, it will remember passwords you save there for reuse in Internet Explorer

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Tony Caduto wrote: Dave Page wrote: What you are saying is that because you don't believe in the pgpass design, you are going to summarily delete them - which I know for absolute sure would *really* annoy some pgAdmin users that I know for a fact have a whole heap of passwords stored

Re: [GENERAL] I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Tom Lane wrote: Richard Huxton dev@archonet.com writes: So - since there is at least one user who's suprised by this behaviour, we probably need two things: 1. A message that tells users the password is being remembered for *them* rather than for pgAdmin. 2. A simple way to allow an

Re: [GENERAL] Re: pgAdmin III and pgpass was I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Magnus Hagander wrote: I do not intend to rewrite this code (which has been in pgAdmin for years) on the basis of a single complaint from the author of an equivalent, but commercial tool. If you do not like the effects you see when a user has a pgpass file, you should warn them in your own

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-02-02 Thread Dave Page
Magnus Hagander wrote: Richard Huxton wrote: Dave Page wrote: Also, three just seems like a sensible number to maintain. I kinda like Magnus' idea to put older releases into a sort of 'retired' mode though, and build only the binaries for PostgreSQL itself. The other option would be for one

Re: [GENERAL] Re: pgAdmin III and pgpass was I might have found a bug on 8.2.1 win32

2007-02-02 Thread Dave Page
Magnus Hagander wrote: Dave Page wrote: Magnus Hagander wrote: I do not intend to rewrite this code (which has been in pgAdmin for years) on the basis of a single complaint from the author of an equivalent, but commercial tool. If you do not like the effects you see when a user has a pgpass

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-02-02 Thread Dave Page
Magnus Hagander wrote: Obviously edb doesn't feel the need, since Dave's not been ordered to :-) I'm left to my own devices as far as community work is concerned. Which is nice :-) Well, if edb had customers *using* it, I'm sure they would tell you to do it even if you didn't want to :-)

Re: [GENERAL] AutoVacuum Behaviour Question

2007-06-28 Thread Dave Page
Bruce McAlister wrote: Excuse my PGSQL ignorance, I'm new to PostgreSQL, and waiting for these PGSQL books to become available: http://www.network-theory.co.uk/newtitles.html I'm pretty sure you'll find those are just bound copies of http://www.postgresql.org/docs/8.2/interactive/index.html

Re: [GENERAL] Create user

2007-06-29 Thread Dave Page
Ashish Karalkar wrote: Hello All, I am trying to create a user and i dont understand why it is showing me any massage even after giving parameter -e to the command. command : C:\Program Files\PostgreSQL\8.2\bincreateuser ashish -S -d -R -l -P -E -e -U postgres Enter password for

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-06-30 Thread Dave Page
--- Original Message --- From: Magnus Hagander [EMAIL PROTECTED] To: siva prakash [EMAIL PROTECTED], 'PostgreSQL' pgsql-general@postgresql.org Sent: 30/06/07, 13:33:04 Subject: Re: [GENERAL] postgressqlnot support inwindows 2000 siva prakash wrote: if i run the setup choose

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-07-02 Thread Dave Page
Magnus Hagander wrote: Yes, but it was not necessarily launched as msiexec. If the file was just double-clicked on, the path to msiexec will be fetched from the registry and not the system PATH. That's the only explanation I can find. Not being installed on Windows 2000 is possible iirc - but

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Dave Page
Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) /D ---(end

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-04 Thread Dave Page
Richard Huxton wrote: Dave Page wrote: Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
Ashish Karalkar wrote: Hello All, I am trying tu run a script to create database from a batch programme and dont want to supply password everytime. So i tried to setup pgpass.conf file. File is kept in user profile/application data i.e C:\Documents and Settings\postgres\Application

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
Ashish Karalkar wrote: The batch file is run under postgres user, also owner of the pgpass.conf file is postgres. As far as my knowledge the permission checking is not done on windows anyways the owner is same so i dont think there is any problem of permission OK - have you tried 127.0.0.1

Re: [GENERAL] PGInstaller Project

2007-07-22 Thread Dave Page
--- Original Message --- From: Mitchell Vincent [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 20/07/07, 23:24:03 Subject: [GENERAL] PGInstaller Project This project is of great interest to me as I am looking for a easier-to-deploy database server and I've always loved

[GENERAL] European users mailing list

2007-07-28 Thread Dave Page
Hi, As discussed at the first meeting of what will become the European PostgreSQL Users Group after pgDay in Prato, we now have a mailing list setup at [EMAIL PROTECTED] This is for the European users group, so is not really intended as a technical list but as a place to discuss events,

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-29 Thread Dave Page
--- Original Message --- From: Peter Eisentraut [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 29/07/07, 14:37:57 Subject: Re: [pgsql-advocacy] European users mailing list Dave Page wrote: As discussed at the first meeting of what will become the European PostgreSQL Users

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-30 Thread Dave Page
Joshua D. Drake wrote: Peter Eisentraut wrote: Dave Page wrote: As discussed at the first meeting of what will become the European PostgreSQL Users Group after pgDay in Prato, we now have a mailing list setup at [EMAIL PROTECTED] This is for the European users group, so is not really

Re: [GENERAL] psql 8.2 client vs pg 8.1 server problem

2007-07-31 Thread Dave Page
Alban Hertroys wrote: We have psql 8.2 clients on our workstations, while we still have pg 8.1 on our development and production servers. This causes problems like the following: database \d table ERROR: column i.indisvalid does not exist database We can log into the server and use the local

Re: [GENERAL] pgTray - win32 tray tool for monitoring PostgreSQL service

2007-08-02 Thread Dave Page
Magnus Hagander wrote: Andrei Kovalevski wrote: Have you done any development yet? Yes, you can download and try it. Now it's a single pgtray.exe application. I'm going to make an msi installer and add Autostart option to the menu. When you do the installer, please make sure it's

Re: [GENERAL] Postgres service startup

2007-08-06 Thread Dave Page
M S wrote: Hi, I'm getting errors in my application which suggest that Postgres has not completely started when it has told the Windows Service Control Manager that is has. Postgres log file extracts which (I believe) support this are shown below: 2007-08-06 10:27:42 LOG: database

Re: [GENERAL] Comment for column in view - legal or just working?

2007-08-08 Thread Dave Page
Harald Armin Massa wrote: Using PostgreSQL 8.1.8 on Windows. I have one named listedi in schema cust; that view has one column name No I used comment on cust.listedi.name http://cust.listedi.name is 'MyDescriptive Name'; and the command suceeded. Using \d+ in psql also shows me that

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-13 Thread Dave Page
--- Original Message --- From: novnov [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 13/08/07, 17:36:12 Subject: [GENERAL] Running a stored procedure via pgagent, need an example Can someone give me a simple example of the way in which I might be able to call a stored

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-16 Thread Dave Page
novnov wrote: Thank you, just had time to test this. I wrote a simple sproc that adds a row to a test table. I've created a one step job db = db the sproc is in kind = sql def = SELECT proc_test01_insertrow(); set to run on each minute of every hour every day, starting today

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-23 Thread Dave Page
Tony Caduto wrote: Other than that I would say PG kicks butt. You're just realising that? :-) If there is any interest I could also add MySQL 5.0 to the mix as the third column. I'd be interested to see that. Regards, Dave ---(end of

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-23 Thread Dave Page
Tony Caduto wrote: Check it out here: http://www.amsoftwaredesign.com/pg_vs_fb Couple of corrections Tony: - You don't necessarily need to stop the postmaster to take a filesystem backup - http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP. Obviously

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-24 Thread Dave Page
Alban Hertroys wrote: Joshua D. Drake wrote: I agree with you on the multi-threaded. I think I will add a note saying the the multi-threaded architecture is only advantageous on Windows. And Solaris. I'm not entirely sure what makes multi-threading be advantageous on a specific operating

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-24 Thread Dave Page
Alban Hertroys wrote: So actually the remark shouldn't be that the multi-threaded architecture is only advantageous on Windows, but more like the multi-process architecture is disadvantageous on Windows and hence a multi-threaded architecture is preferred (on that particular OS). Yeah - but

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-25 Thread Dave Page
--- Original Message --- From: Tony Caduto [EMAIL PROTECTED] To: Joshua D. Drake [EMAIL PROTECTED] Sent: 25/08/07, 15:36:15 Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished Hi, Someone mentioned we should put this in the PostgreSQL wiki. Do you guys

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-27 Thread Dave Page
--- Original Message --- From: Stephen Ince [EMAIL PROTECTED] To: Tony Caduto [EMAIL PROTECTED], Greg Smith [EMAIL PROTECTED], pgsql-general@postgresql.org Sent: 27/08/07, 17:02:21 Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished Postgres can't be

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-27 Thread Dave Page
--- Original Message --- From: Stephen Ince [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 27/08/07, 21:30:06 Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished Dave, Thx I will take a look. I was trying to port a postgres schema

Re: [GENERAL] pgsql Windows installer fixed registry key

2007-08-27 Thread Dave Page
--- Original Message --- From: Dizzy [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 27/08/07, 21:12:55 Subject: [GENERAL] pgsql Windows installer fixed registry key The pgsql MSI installer does register a registry key but it's random everytime it installs (probably

Re: [GENERAL] Windows Download

2007-08-28 Thread Dave Page
John K Masters wrote: I have setup a Postgres server on Debian Etch and successfully connected to it with various *nix clients but I now have to connect a WinXP client. On accessing the Postgres site I am directed to a download page, click on the appropriate link and get automatically directed

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-28 Thread Dave Page
Harald Armin Massa wrote: the SQL Server 2005 Express download provides software that is suitable for application embedding or lightweight application development. I never developed more then some queries on SQL Server Express or its different names. But I had to work

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

2007-09-07 Thread Dave Page
Andreas Tille wrote: On Wed, 5 Sep 2007, Andreas Tille wrote: On Mon, 4 Sep 2007, Albe Laurenz wrote: The best list for this kind of thing is certainly the Npgsql mailing list: http://gborg.postgresql.org/mailman/listinfo/npgsql-general Just subscribed. Well, I looked at the archives of

Re: [GENERAL] replacing Access/ Approach etc

2007-09-08 Thread Dave Page
--- Original Message --- From: Zenaan Harkness [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 08/09/07, 06:03:54 Subject: [GENERAL] replacing Access/ Approach etc Is there a way to achieve this, on windows? Yes, 8.2 will start under a admin account just fine. Is

Re: [GENERAL] Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4

2007-09-19 Thread Dave Page
On Tue, 2007-09-18 at 14:58 -0500, Walter Roeland wrote: 2007-09-18 14:28:36 127.0.0.1 postgres postgres FATAL: database postgres does not exist And I have to abort the startup. Maybe the next is a hint: When I had blocked the access to localhost with SSL=ON (using hostnossl

Re: [GENERAL] OK, when 8.3 is coming?

2007-09-29 Thread Dave Page
--- Original Message --- From: Anton Andreev [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 29/09/07, 13:33:03 Subject: [GENERAL] OK, when 8.3 is coming? Hi, Has someone stated when is Postgresql 8.3 coming? Beta 1 early next week if all goes to plan. Regards, Dave

Re: [GENERAL] good sql tutorial

2007-10-04 Thread Dave Page
--- Original Message --- From: Ron Johnson [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 04/10/07, 17:22:16 Subject: Re: [GENERAL] good sql tutorial You'll see his SQL, squeal like a girl and then forbid him from ever touching the database again. I'm just saving you

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
Ow Mun Heng wrote: Does anyone from this list here uses pgagent from pgadmin? it's a job schedular much like cron which is sort of integrated w/ pgadmin3. Only issue which I've found so far which I don't quite like is that to be able to use pgagent, I have to also pull in the entire

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
Ow Mun Heng wrote: I've only have 1.4.3 version for centos. (and for gentoo) so.. I have to use that version. We have RPMs for later versions on the pgAdmin site - do they not work? Thus far, the only serious issue I've seen with it is that for some reason, I can't or is not able to connect

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
Ow Mun Heng wrote: I see.. and in the docs, I was told to import pgagent.sql into the postgres DB so I did that. but actually. I want to deploy it to the target DB, let's call it MyDB. Should I have imported it to MyDB instead? No, postgres is normal. You can specify with each job step which

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: Another followup. Been working with Dave on and off today (well, him mostly on to be honest, me a bit more on and off), and it seems that both our repros clearly blame the desktop heap, and nothing else. Please use the desktop heap tool and see if it breaks when the

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Dave Page wrote: So, we seem to be hitting two limits here - the desktop heap, and something else which is cluster-specific. Investigation continues... In further info, I've been testing this with the 8.3b1 release build that we put out with pgInstaller, and a build with all optional

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Trevor Talbot wrote: The question is where that's coming from. I wondered if it was desktop heap originally, but there's no reason it should be using it, and that seems to be precisely the difference between my system and the others. Connections here are barely making a dent; at 490 there's

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Trevor Talbot wrote: I wrote: [ desktop heap usage ] It could be that there's a significant difference between XP and 2003 in how that's handled though. I do have an XP SP2 machine here with 512MB RAM, and I'll try tests on it as soon as I can free up what it's currently occupied with.

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: Could you try a build without SSPI? It should be as simple as removing the #define ENABLE_SSPI 1 from port/win32.h. I don't think you need to touch the linker lines at all, actually, so try without first. Nope, doesn't help - still using around 9.7KB per connection. Just

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Dave Page wrote: So the only other changes I can think of that might affect things are the VC++ build or the shared memory changes, though I can't see why they would cause problems offhand. I'll go try a mingw build... mingw build of stock 8.3b1, no configure options specified at all, consumes

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: Yeah, it could be that the newer MSVCRT files do something we don't like.. Other than that, did we upgrade to a different version of some of our dependents? Most of them - but my test build is without any of them: our $config = { asserts=1, #

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-23 Thread Dave Page
Rainer Bauer wrote: ...yep, under XP I'm using about 3.1KB of the service heap per connection, which tears through it quite a bit faster. Now to figure out exactly where it's coming from... I can confirm this here (WinXP SP2). It's coming from direct dependencies on user32.dll (from which

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-23 Thread Dave Page
Harald Armin Massa wrote: Dave, It's coming from direct dependencies on user32.dll (from which we use wsprintf()) and shell32.dll (from which we use SHGetSpecialFolderPath()) and is allocated when ResumeThread() is called to kickstart the new backend, why does every backend need its own

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-23 Thread Dave Page
Harald Armin Massa wrote: Replying to myself Postgres is definitely NOT started as LocalSystem account; so using a logical not on Microsofts Words that could indicate the reason why our service-backends consume that memory? Add to this that MS SQL runs as LocalSystem; and as much as I

Re: [GENERAL] subversion support?

2007-10-25 Thread Dave Page
--- Original Message --- From: Roberts, Jon [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 25/10/07, 17:35:32 Subject: Re: [GENERAL] subversion support? Complaint? Who is complaining? I am simply asking if this feature that is rather common in other database

Re: [GENERAL] subversion support?

2007-10-25 Thread Dave Page
--- Original Message --- From: Gregory Stark [EMAIL PROTECTED] To: Dave Page [EMAIL PROTECTED] Sent: 25/10/07, 19:06:12 Subject: Re: subversion support? The situation is complicated somewhat by the SQL ALTER TABLE and so on commands which you need to use instead of just

Re: [GENERAL] subversion support?

2007-10-26 Thread Dave Page
Roberts, Jon wrote: That is awesome. Can it be added to pga3? Like I said - it wasn't implemented in pga3 because noone used it in pga2 except for (as far as I know), the team I was working with at the time. As I recall we polled the mailing lists before dropping it and noone said they wanted

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-26 Thread Dave Page
Magnus Hagander wrote: Rainer Bauer wrote: After increasing the session heap size in the registry from 512KB to 1024KB the no. of connections was roughly doubled. So this might be a solution for people running out of Desktop heap. Alter the value of the following key

Re: [GENERAL] subversion support?

2007-10-26 Thread Dave Page
Hi Tino Tino Wildenhain wrote: Hi Dave, pgAdmin II had change control. No-one ever really used it though so we never bothered to implement it in pgAdmin III. But it was implemented differently then the proposal above. I'm not sure the detail of how it was implemented was a huge factor in

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-26 Thread Dave Page
--- Original Message --- From: Rainer Bauer [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: 26/10/07, 18:09:26 Subject: Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit Dave could you add that it's the third parameter of the SharedSection string that

Re: [GENERAL] PLpgsql debugger question

2007-11-14 Thread Dave Page
--- Original Message --- From: Richard Huxton [EMAIL PROTECTED] To: Joshua D. Drake [EMAIL PROTECTED] Sent: 14/11/07, 19:01:04 Subject: Re: [GENERAL] PLpgsql debugger question Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 14 Nov 2007

Re: [GENERAL] Compiled debugger plug in for windows, any one have it?

2007-11-15 Thread Dave Page
Tony Caduto wrote: I dont' have a c/c++ compiler on my PCs as I am a Delphi guy. Anyone have it compiled for win32 and willing to share? Actually I do have CodeGear C++, but it's unlikely to work with that. Just download and install the win32 distro of 8.3beta2. Regards, Dave

  1   2   3   4   5   6   7   >