-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
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
-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
-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
-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
-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
-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
-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:
-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
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
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
--- 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
--- 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
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
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
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
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
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
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
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
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
--- 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.
--- 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.
--- 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
--- 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
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
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
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.
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
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
--- 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
--- 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
--- 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
--- 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?
--- 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
--- 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
--- 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
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
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)?
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
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
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
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
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
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
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 :-)
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
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
--- 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
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
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
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
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
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
--- 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
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,
--- 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
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
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
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
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
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
--- 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
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
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
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
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
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
--- 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
--- 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
--- 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
--- 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
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
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
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
--- 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
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
--- 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
--- 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
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
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
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
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
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
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
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.
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
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
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, #
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
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
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
--- 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
--- 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
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
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
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
--- 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
--- 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
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 - 100 of 656 matches
Mail list logo