Re: [GENERAL] vista

2006-09-19 Thread Magnus Hagander
Well, we are entirely ready to accept patches from any Windows Vista beta testers who are able to find and fix portability issues. It's the folks who think that non-Windows-using developers should care about Vista that bug me. This is open-source code, people. Scratch your own

Re: [GENERAL] PostgreSQL 8.1.4 on Vista RC1

2006-09-29 Thread Magnus Hagander
I receive Windows Vista RC1 for testing, so I try to install PG 8.1.4.The installer fails : - On the creation of the user Postgres, - On the creation of the service. I found workaround for that : - I create manually the Postgres user with a password, - I install PG 8.1.4 WITHOUT creating

Re: [GENERAL] PostgreSQL 8.1 - SSL:Required

2006-10-02 Thread Magnus Hagander
Hi, I am using the binary install for postgresql 8.1 Win32 on Windows XP. I know how to intstall SSL if I was installing from source, -- with-openssl, but I am installing onto Windows XP for the first time, so my question is: 1. How do I install the SSL module via the install wizard? SSL

Re: [GENERAL] List of supported 64bit OS

2006-10-12 Thread Magnus Hagander
All of them ... ? At least, I'm not aware of any that PostgreSQL *doesn't* support ... Win32 is not supported on 64bit IIRC. Actually, win32 works just fine on 64bit. Meaning that 32-bit PostgreSQL runs on x64 versions of Windows. Win64, however, is not supported. That would be a 64-bit

Re: [GENERAL] techdocs.2 how long has this be around?

2006-10-16 Thread Magnus Hagander
Is this new? Who ever spent the time to do this, thanks for the effort. Having the content organized this way makes it easy to find specific reading material. Are you talking about http://www.postgresql.org/docs/techdocs? If so, it's been around for quite a whilen ow, but we're still not

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Magnus Hagander
Hmm. If the messages are less than PIPE_BUF bytes long (4096 bytes on Linux) then the writes are supposed to be atomic. Some of them involve long messages (4K), but there are many that do not (like the ones I had posted at the start of this thread). I checked around with some

Re: [HACKERS] [GENERAL] query log corrupted-looking entries

2006-10-18 Thread Magnus Hagander
Should work fine on Windows. fileno() is deprecated however, with the following comment: C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE\stdio.h(688) : see declaration of 'fileno' Message: 'The POSIX name for this item is deprecated. Instead, use the

Re: [GENERAL] 8.2beta1 installation fails

2006-10-24 Thread Magnus Hagander
I ran msi installation package downloaded from postgresql.org from remote desktop. I selected Estonian locale, UTF-8 database encoding. After that I got error Failed to run initdb: !128 Please see the logfile in 'C:\program Files\PostgreSQL\8.2beta1\tmp\initdb.log'. Note! You must

Re: [GENERAL] 8.2beta1 installation fails

2006-10-25 Thread Magnus Hagander
Andrus, did you make sure you used the /console mode of remote desktop? On 10/24/06, Andrus [EMAIL PROTECTED] wrote: I ran msi installation package downloaded from postgresql.org http://postgresql.org from remote desktop. I selected Estonian locale, UTF-8

Re: [GENERAL] Problems running PostGreSQL silent install

2006-10-27 Thread Magnus Hagander
initdb: directory C:/Program Files/PostgreSQL/8.1/data exists but is not empty If you want to create a new database system, either remove or empty the directory C:/Program Files/PostgreSQL/8.1/data or run initdb with an argument other than C:/Program Files/PostgreSQL/8.1/data. The

Re: [GENERAL] Problems running PostGreSQL silent install

2006-10-27 Thread Magnus Hagander
Thank you for the reply. But then are you saying I don't even really need to use the MSI in the first place? I can just copy the files to a folder. Then run initdb and pg_ctl? Sure. The MSI is just a convenient way to get everything into place, and to set icons and stuff. I am bundling

Re: [GENERAL] Availability of pg_backend_pid() immediately after connection establishment

2006-11-02 Thread Magnus Hagander
Someone in this group mentioned a while back that pg_backend_pid() function works only after some 1/2 second after the connection has been established. This had something to do with the stats collector to make its sweep every .5 seconds?. Does anyone have more information on this? No,

[GENERAL] Counting records in a PL/pgsql cursor

2006-11-02 Thread Magnus Hagander
Is there any way to count how many hits I got in a cursor in PL/pgsql? I have a function that will window through the result of a (large) query based on two parameters, but I also want to return the number of hits to the client. Right now I'm looping through the entire cursor and incrementing a

Re: [GENERAL] Counting records in a PL/pgsql cursor

2006-11-03 Thread Magnus Hagander
Is there any way to count how many hits I got in a cursor in PL/pgsql? I have a function that will window through the result of a (large) query based on two parameters, but I also want to return the number of hits to the client. Right now I'm looping through the entire cursor

Re: [GENERAL] Counting records in a PL/pgsql cursor

2006-11-03 Thread Magnus Hagander
I can deal with materializing the resultset, but I want to get away from the loop-a-thousand-times-doing-plus-one... i dont think its possible. note that you can make a refcursor inside your plpgsql function and pass it to an sql function which can do sql cursor operations

Re: [GENERAL] Counting records in a PL/pgsql cursor

2006-11-03 Thread Magnus Hagander
Nope, the query is way too expensive to run it twice. (GIN scan over well over half a million rows. It's faster to do the get-as-cursor-then-loop-and-increment, I've measured that) Can't you select into a temporary table and then do select count(*) over that table, aswell as run

Re: [GENERAL] kerberos authentication error with Windows 2003 SP1 AD

2006-11-14 Thread Magnus Hagander
My operating system is Red Hat Linux AS 4, Kerberos 5, with postgresql-7.4.14 that I compiled. I can authenticate using ssh, su, console login, and also have gotten apache mod_auth_kerb to work with AD - but I am missing something with postgresql. When I try: [EMAIL PROTECTED] ~]$

Re: [GENERAL] Why the data changes it's value by itself!

2006-11-17 Thread Magnus Hagander
Does this message in application.log can be the source of problem wuaueng.dll (1204) Synchronous read page checksum error -1018 ((1:801 1:801) (0-13218) (0-14642)) occurred. Please restore the databases from a previous backup. I don't recognise this as a PostgreSQL error, although

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Magnus Hagander
I have done this in Delphi using it's built in UTF8 encoding and decoding routines. You can get a free copy of Delphi Turbo Explorer which includes components for MS SQL server and ODBC, so it would be pretty straight forward to get this working. The actual method in Delphi

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Magnus Hagander
I already posted this as COPY FROM encoding error, but I have been doing some more tests since then. I'm trying to export data from MS SQL Server to PostgreSQL. The tables are quite big (20M rows), so a CSV export and a COPY FROM3 import seems to be the only reasonable solution.

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Magnus Hagander
I thought Win1252 was supposed to be almost the same as Latin1. While I'd expect certain differences, I wouldn't expect it to use 0x00 as data! Maybe you could have DTS export Unicode, which would presumably be UTF-16, then recode that to something else (possibly UTF-8)

Re: [GENERAL] transfer just the data directories from linux to windows?

2006-12-01 Thread Magnus Hagander
Hi, We have some backups from our prod server and I was wondering if there would be any problems with just copying the data directory to a windows install (same version - 8.1.4) ... any pointers? If both servers are windows servers, and both are running the same version of pg, then you

Re: [GENERAL] tsearch2 and pdf files

2006-12-11 Thread Magnus Hagander
1. Convert PDF to file with e.g xpdf 2. Insert parsed text to a table of your choice. 3. Make vectors from the text. Actually, if you're not going to use the headline() function, you cna just store it directly in a vector, cutting down on the size requirements. Just insert to the to_tsvector()

Re: [GENERAL] tsearch2 and pdf files

2006-12-11 Thread Magnus Hagander
1. Convert PDF to file with e.g xpdf 2. Insert parsed text to a table of your choice. 3. Make vectors from the text. Actually, if you're not going to use the headline() function, you cna just store it directly in a vector, cutting down on the size requirements. What size

Re: [GENERAL] could not write to log - PANIC - System down

2006-12-15 Thread Magnus Hagander
On Fri, Dec 15, 2006 at 03:54:01AM -0500, Brandon Aiken wrote: My understanding of VSS is that only one non-VSS aware app can access the data at any one time. All I meant was that if their NetBackup version was old that they probably cannot benefit from VSS since I doubt the Win32 PG port

Re: [GENERAL] Failed to set permision Win2k3-PG Installation Issues

2006-12-16 Thread Magnus Hagander
[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Everytime I try to install Postgre 8.2, I get the following error: Failed to set permissions on the installed files. Please see the logfile. The thing is, I'm telling PG to use my Administrator account (the account I'm currently logged in

Re: [GENERAL] Authenticating with x509 certificate

2006-12-16 Thread Magnus Hagander
Andre Lebedev wrote: Hello. Based on the information I was able to find so far, it seems that Postgres has the capability of authenticating users through x509 certificate. But I can't find instructions on how to do it. Any help will be greatly appreciated! It does not, unfortunately

Re: [GENERAL] installing postgres on win Me...

2006-12-18 Thread Magnus Hagander
On Mon, Dec 18, 2006 at 09:52:27AM +0100, riki wrote: Hi all, is it possible to install postgres ver 8.1.4 on windows Me FAT32 partition? if so, how? on the second step of installation after i choose language i get error message Failed to create process: 2!. Win Me are freshly installed.

Re: [GENERAL] installing postgres on win Me...

2006-12-18 Thread Magnus Hagander
On Mon, Dec 18, 2006 at 11:49:42AM +0100, riki wrote: Magnus Hagander [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, Dec 18, 2006 at 09:52:27AM +0100, riki wrote: Hi all, is it possible to install postgres ver 8.1.4 on windows Me FAT32 partition? if so, how

Re: [GENERAL] Anyone? Best way to authenticate postgres against active directory?

2006-12-19 Thread Magnus Hagander
On Mon, Dec 18, 2006 at 08:23:08PM -0600, Derrick wrote: I've been struggling with pam_ldap and a windows 2003 active directory server, trying to get postgres to authenticate against it. I'm wondering what the best way to get postgres to authenticate against windows active directory would

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 12:56:25AM +0100, Thomas H. wrote: Take a look at let us know what you think and how it performs for you. i would love an advanced search where you can limit the results to a particular version of the documentation. the query for SELECT returns too many results from

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 01:48:22PM +0530, Gurjeet Singh wrote: On 12/19/06, Henrik Zagerholm [EMAIL PROTECTED] wrote: Hello, Searching after tsearch 5. PostgreSQL: Documentation: Manuals: PostgreSQL 7.4: Examples [0.1] ...tsearch and tsearch2Full text

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 01:13:16PM +0300, Oleg Bartunov wrote: Seems to_tsvecto() returns NULL for tsearch2 or for, as you say, anything that ends in a digit. Oleg, can you comment on why this is happening? What can we do to fix that? Most probably, token type 'word' just doesn't indexed.

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 01:24:01PM +0100, Magnus Hagander wrote: On Tue, Dec 19, 2006 at 01:13:16PM +0300, Oleg Bartunov wrote: Seems to_tsvecto() returns NULL for tsearch2 or for, as you say, anything that ends in a digit. Oleg, can you comment on why this is happening? What can we do

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Wed, Dec 20, 2006 at 01:35:57AM +1030, Shane Ambler wrote: Magnus Hagander wrote: You get this if you go into say the 8.2 docs, and use the search form there - same as before. I would search from the home page rather than navigate to docs first. (open browser - type postgres.org (enter

Re: [GENERAL] Anyone? Best way to authenticate postgres against active directory?

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 09:52:58AM -0600, Derrick Stensrud wrote: Thanks I've been trying to use pam_ldap but I keep getting this error from postgres. I think it may have something to do with postgres running as the postgres user and not having permissions to something, but I have no idea

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 09:41:38PM +0530, Gurjeet Singh wrote: On 12/19/06, Matthew O'Connor matthew@zeut.net wrote: Magnus Hagander wrote: But seriously, I'm definitly interested in ways it can be improved - and that's true of the whole web team, I'm sure. It was just my way of saying

Re: [GENERAL] Let's play bash the search engine

2006-12-19 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 01:02:09PM -0300, Alvaro Herrera wrote: Matthew O'Connor wrote: Magnus Hagander wrote: But seriously, I'm definitly interested in ways it can be improved - and that's true of the whole web team, I'm sure. It was just my way of saying it will take a while, but I'll

Re: [GENERAL] Anyone? Best way to authenticate postgres against

2006-12-19 Thread Magnus Hagander
Stephen Frost wrote: * John McCawley ([EMAIL PROTECTED]) wrote: (I am working on this project with Derrick.) We have to use the Active Directory to authenticate not only users from our client-side app (We're attempting to use PostgreSQL essentially as a proxy authentication mechanism), but

Re: [GENERAL] windows - silent uninstall question

2006-12-20 Thread Magnus Hagander
On Tue, Dec 19, 2006 at 05:42:05PM -0500, Amit Mody wrote: Hi, I am packaging the postgres database in my application and for this I need to do a silent install and uninstall, the msiexec for install works great. Is there a similar utility for uninstall. If not, are there any other options

Re: [GENERAL] Unable to start server - winxp

2006-12-22 Thread Magnus Hagander
So there's no other way to start the server else than to create an unpriviledged winxp user account, or change my user account (and forever not be able to install programs, change settings etc etc.)? There must be, I can't imagine postgresql is in backwards world: making the admin less

Re: [GENERAL] Unable to start server - winxp

2006-12-23 Thread Magnus Hagander
Joost Kuckartz wrote: Thanks for all the help guys, I actually found the problem and solution. Maybe for others who will have this, let me recap: - While installing the msi file I had to disable the initialization in the installer, because of installation on a FAT32 partition - I then ran

Re: [GENERAL] LDAP configuration problem

2006-12-28 Thread Magnus Hagander
Wenjian Yang wrote: Hi, I've just installed 8.2.0 from rpms on FC6 i386 and wanted to try out the built-in LDAP support. The following LDAP authentication was added to pg_hba.conf host all all 0.0.0.0 http://0.0.0.0 0.0.0.0 http://0.0.0.0

Re: [GENERAL] LDAP configuration problem

2006-12-29 Thread Magnus Hagander
ldap token) //Magnus On 12/29/06, *Magnus Hagander* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Wenjian Yang wrote: Hi, I've just installed 8.2.0 from rpms on FC6 i386 and wanted to try out the built-in LDAP support. The following LDAP

Re: [GENERAL] Installing support for python on windows

2007-01-01 Thread Magnus Hagander
novnov wrote: Then I tried something like what Adrian had suggested: D:\postgresql\bincreatelang -U sauser -d mydb plpythonu Password: createlang: language installation failed: ERROR: could not load library D:/pos tgresql/lib/plpython.dll: The specified module could not be found. It's

Re: [GENERAL] Installing support for python on windows

2007-01-01 Thread Magnus Hagander
novnov wrote: This is so much more difficult than I imagined it could be. I've added the main python dir and the lib dir to my path and nothing has changed. I may be able to figure out how to use the depends tool, so far it looks pretty obscure to a newb. It should be easy enough - just run

Re: [GENERAL] could not open file xxxx for writing: Permission denied

2007-01-03 Thread Magnus Hagander
Hello, Using PostgreSQL 8.1.4, pgadmin III 1.6.0 in WinXP I tried to export a table using COPY (first time in postgresql, did many times in Sybase): COPY ml50jtsk_datum_v TO 'c:/postgresql/ml50jtsk.out'; I got the following errormessage: ERROR: could not open file

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

2007-01-09 Thread Magnus Hagander
Hi, I may be wrong but: Enabling query logging (in the options dialog) will only log the SQL pgAdmin III sends to the server, it will not capture the query for a selected process in the server status dialog. If you want something like the trace in MS SQL server Lightning Admin has

Re: [GENERAL] PGPASS.CONF ¿is there a way to p

2007-01-09 Thread Magnus Hagander
guillermo arias wrote: Hello, i am using PostgreSQL 8.2 in a Windows XP pc. I know that this file PGPASS.CONF stores the users with password, but because this is a plain txt file, it is easy for curious people to read the contents. By other way, if i do not write the password there, my users

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-11 Thread Magnus Hagander
Tom Lane wrote: Patrick Earl [EMAIL PROTECTED] writes: In any case, the unit tests remove all contents and schema within the database before starting, and they remove the tables they create as they proceed. Certainly there are many things have been recently deleted. Yeah, I think then

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-11 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: I find it very unlikely that you would during normal operations end up in a situation where you would first have permissions to create files in a directory, and then lose them. What could be is that you have a directory where you never

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-12 Thread Magnus Hagander
On Fri, Jan 12, 2007 at 10:49:53AM +0100, Zeugswetter Andreas ADI SD wrote: I find it very unlikely that you would during normal operations end up in a situation where you would first have permissions to create files in a directory, and then lose them. What could be is that you

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-12 Thread Magnus Hagander
On Thu, Jan 11, 2007 at 10:39:47PM -0500, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote: ... And anyway there should never *be* a real permissions problem; if there is then the user's been poking under the hood sufficient

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-12 Thread Magnus Hagander
On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Thu, Jan 11, 2007 at 10:39:47PM -0500, Tom Lane wrote: One point worth making is that I'm not really convinced anymore that we have proof that antivirus code has been creating any

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-12 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Fri, Jan 12, 2007 at 09:47:55AM -0500, Tom Lane wrote: No, I didn't claim that Windows AV software is bug-free ;-). What I said was that I'm not certain it's related to the permission denied reports, as opposed to other problems

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-12 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: Actually, it could still be the same problem, with the AV software only involved to the extent that it's trying to scan files for viruses. Partially the same, but I've seen AV software keeping it open for hours

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-15 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Tom Lane wrote: pg_control is certainly not ever deleted or renamed, and in fact I believe there's an LWLock enforcing that only one PG process at a time is even touching it. So we need another theory to explain this one :-( Right

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-15 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: But yeah, that's probably a good idea. A quick look at the code says we should at least ask people who have this problem to give it a run with logging at DEBUG5 which should then log exactly what the errorcode was. Or are you seeing

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-16 Thread Magnus Hagander
On Tue, Jan 16, 2007 at 10:20:04AM +0900, Takayuki Tsunakawa wrote: From: Magnus Hagander [EMAIL PROTECTED] But yeah, that's probably a good idea. A quick look at the code says we should at least ask people who have this problem to give it a run with logging at DEBUG5 which should

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-16 Thread Magnus Hagander
On Tue, Jan 16, 2007 at 11:11:59AM -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: And actually, when I look at the API docs, our case now seems to be documented. Or am I misreading our situation. I have: If you call CreateFile on a file that is pending deletion

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

2007-01-17 Thread Magnus Hagander
That -- and make sure your Secondary Logon service is running. Also, to confirm, Log On As column in front of the pg service should mention the postgres (low privileged) user. Secondary logon service is only needed during installation. It's only used to launch initdb. /Magnus

Re: [GENERAL] Controlling memory of session

2007-01-18 Thread Magnus Hagander
On Thu, Jan 18, 2007 at 07:41:27AM +, James Im wrote: Ok so the solution is to limit the number of connections. But it seems that there is no good way to choose the ideal number of connections as I don't know how much RAM will a connection use. If a connection takes 3MB (on windows I see

Re: [GENERAL] Defining data directory while installing [WinXP]

2007-01-19 Thread Magnus Hagander
On Thu, Jan 18, 2007 at 05:40:27AM -0800, Ole Laurisch wrote: Hello, I would like to install PGSQL on Windows XP and would like to change the default directory for the data as I would prefer to have my databases on a specific partition and not on my programm partitition. What do I have to

Re: [GENERAL] Problems compiling from source

2007-01-23 Thread Magnus Hagander
On Mon, Jan 22, 2007 at 05:32:13PM -0600, George Weaver wrote: Hi all, I have installed version 8.2.1 and downloaded the source tree in order to compile a number of C-functions. I have been compiling from source for contrib files and c-functions since version 7.3 without problem. I

Re: [GENERAL] array_to_string return is different between Windows and Linux systems

2007-01-23 Thread Magnus Hagander
On Tue, Jan 23, 2007 at 09:23:06AM +0100, Pascal Lequeux wrote: Hi all, The *array_to_string *function used to compare the content of arrays of doubles doesn't return the same result if the OS is Windows or if it is a Linux system. Here is an example using the same table content:

Re: [GENERAL] libeay32.dll ssleay32.dll in system PATH

2007-01-25 Thread Magnus Hagander
Check your system, system32 and winnt directories. /Magnus --- Original message --- From: Steven De Vriendt [EMAIL PROTECTED] Sent: 1-25-'07, 11:37 Hi, When I try to install PostgreSQL8.2 I get this error message: Incompactibel version of openssl detected in system path. when

Re: [GENERAL] Stats collector frozen?

2007-01-25 Thread Magnus Hagander
Tom Lane wrote: Jeremy Haile [EMAIL PROTECTED] writes: Unfortunately I don't have any debugging tools installed that would work against postgres - although I'd be glad to do something if you could tell me the steps involved. I can reproduce the issue quite easily on two different Windows

Re: [GENERAL] Stats collector frozen?

2007-01-25 Thread Magnus Hagander
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Jeremy Haile wrote: If anyone else is experiencing similar problems, please post your situation. All the Windows buildfarm machines are, apparently. Can't anyone with a debugger duplicate this and get a stack trace for us? If the

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Jeremy Haile wrote: If anyone else is experiencing similar problems, please post your situation. All the Windows buildfarm machines are, apparently. Can't anyone with a debugger

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Jeremy Haile wrote: If anyone else is experiencing similar problems, please post your situation. All the Windows buildfarm machines are, apparently. Can't anyone with a debugger

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Jeremy Haile wrote: If anyone else is experiencing similar problems, please post your situation. All the Windows buildfarm machines are, apparently. Can't anyone with a debugger

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote: Apparantly there is a bug lurking somewhere in pgwin32_select(). Because if I put a #undef select right before the select in pgstat.c, the regression tests pass. May be, problem is related to fixed bug in

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 12:26:58PM +0100, Magnus Hagander wrote: On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote: Apparantly there is a bug lurking somewhere in pgwin32_select(). Because if I put a #undef select right before the select in pgstat.c, the regression tests pass

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 09:55:39AM -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Apparantly there is a bug lurking somewhere in pgwin32_select(). Because if I put a #undef select right before the select in pgstat.c, the regression tests pass. I guess the bug is shown

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
Jeremy Haile wrote: Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go green, we should probably consider back-porting this to 8.1 and 8.0. Not trying to be a nuisance, but I'd really like to try this out in my environment and see if my problems disappear. Is there

Re: [GENERAL] Stats collector frozen?

2007-01-27 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: Attached patch seems to solve the problem on my machine at least. Uses pgwin32_waitforsinglesocket() instead of pgwin32_select(). Changes pgwin32_waitforsinglesocket() to accept the timeout as a parameter (this is why it touches files

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-27 Thread Magnus Hagander
Dave Page wrote: 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

Re: [GENERAL] Stats collector frozen?

2007-01-27 Thread Magnus Hagander
Jeremy Haile wrote: Using standard build (none of the things you mentioned) on 8.2.1 currently. I really appreciate it! Ok. I've built a binary for you at http://www.hagander.net/download/pgsql_8.2.1_win32select.zip Note that while I named the file 8.2.1 it really isn't - it's current head

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-27 Thread Magnus Hagander
Tom Lane wrote: Dave Page [EMAIL PROTECTED] writes: I've been considering only maintaining the current and previous 2 versions in pgInstaller (the Windows binary distro). But that's a *lot* harder to maintain than just PostgreSQL because of all the bundled stuff. In other words, when 8.3 is

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

2007-02-01 Thread Magnus Hagander
Tony Caduto wrote: Never mind, somehow a application setup a pgpass.conf file for me without my knowledge. Have you been leaving the dark side lately? (pgAdmin does this..) Sorry it's not a bug. However I wonder if it might be a good idea if psql would raise a warning after logon that a

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

2007-02-01 Thread Magnus Hagander
On Thu, Feb 01, 2007 at 12:38:22PM -0600, Tony Caduto wrote: Magnus Hagander wrote: Have you been leaving the dark side lately? (pgAdmin does this..) I still have pgAdmin installed :-) it's a good reference tool. :-) Is there a way to tell libpq in the connection string

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

2007-02-01 Thread Magnus Hagander
On Thu, Feb 01, 2007 at 09:53:26PM -, Dave Page wrote: Not to mention that the whole pgpass thing is a huge security hole, it would be different if the passwords where encrypted or hashed, but they are just sitting there in plain text. In an 0600 file on *nix, or in your profile on

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

2007-02-01 Thread Magnus Hagander
On Thu, Feb 01, 2007 at 02:17:00PM -0600, Tony Caduto wrote: Dave Page wrote: Could this be proof of you using pgAdmin ( :-) ) and checking the Store Password option? That'll save it in pgpass.conf in your profile. /D I won't deny I have it installed :-) I don't remember using the

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

2007-02-02 Thread Magnus Hagander
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 code, not expect us to

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-02-02 Thread Magnus Hagander
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 or more Windows users

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

2007-02-02 Thread Magnus Hagander
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 file, you should warn

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-02-02 Thread Magnus Hagander
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 :-) //Magnus

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

2007-02-02 Thread Magnus Hagander
Dave Page wrote: 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

Re: [GENERAL] Automatic install on windows

2007-06-25 Thread Magnus Hagander
Jason Long wrote: I have a client that wants a disaster recovery plan put into place. What is the easiest way to do a hands free install of postgresql on a window box? http://pginstaller.projects.postgresql.org/silent.html //Magnus ---(end of

Re: [GENERAL] Looking for help regarding getting the latest inserted sequence value.

2007-06-30 Thread Magnus Hagander
Mavinakuli, Prasanna (STSD) wrote: Hello All, We are looking for your help.The scenarion which we need to address is,There are 2 threads and both of them are in separate transction and insert the value to a same table and also sequence number field gets incremented automotically for each of

Re: [GENERAL] installing pljava on windows xp

2007-06-30 Thread Magnus Hagander
Pouria wrote: Hi, When I try to install pljava 1.3 on postgresql 8.2 (or 8.1) I get an error stating that it cannot load pljava.dll from a location specificed in the config file (while the dll is clearly there). I have followed the postgredql and pljava manual installation instructions

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-06-30 Thread Magnus Hagander
siva prakash wrote: if i run the setup choose language then go to next button it shows error *Failed to create process: 2!* Please don't remove the mailinglist from the CC list, so others can learn from the answers. The error you get indicates that your windows installation is broken. At that

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-07-01 Thread Magnus Hagander
Dave Page wrote: siva prakash wrote: if i run the setup choose language then go to next button it shows error *Failed to create process: 2!* Please don't remove the mailinglist from the CC list, so others can learn from the answers. The error you get indicates that your windows

Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows

2007-07-02 Thread Magnus Hagander
On Sun, Jul 01, 2007 at 10:46:22PM -0300, Jorge Godoy wrote: On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote: Jorge, Thanks for the suggestion. But unfortunately, I tried both \cd C:/Document~1 and just \cd C:/Document~1 and neither worked. Sorry. It should be up to 8 chars:

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Magnus Hagander
On Tue, Jul 10, 2007 at 04:34:56PM +0530, 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

Re: [GENERAL] query optimizer

2007-07-19 Thread Magnus Hagander
On Thu, Jul 19, 2007 at 10:41:03AM -0400, Tom Lane wrote: Luca Ferrari [EMAIL PROTECTED] writes: I'd like to better understand how the optimizer works and is implemented. Is there any available documentation (before start reading the source!) to understand concepts about geqo and

Re: [GENERAL] several postgres installations on the same machine?

2007-07-20 Thread Magnus Hagander
On Fri, Jul 20, 2007 at 09:24:05AM +0200, Zlatko Matić wrote: Hi. If I understood correctly, this blog describes how to create second instance that is linked to first (the same service acount user)? But, I want to know whether it is possible to have second instance completely independent,

Re: [GENERAL] query optimizer

2007-07-23 Thread Magnus Hagander
Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Thu, Jul 19, 2007 at 10:41:03AM -0400, Tom Lane wrote: The developers section of the website used to have slides from a couple of talks I gave at OSCON, but I don't see them there anymore :-( How long ago was this (that they were

Re: [GENERAL] Silent Uninstall of Postgres

2007-07-24 Thread Magnus Hagander
Joe L wrote: Hi, I saw the page on silent installation of postgres, but I want to be able to uninstall postgres when my product is uninstalled, silently. I couldn't find the product ID anywhere, which is the method I'm using for uninstalling the JRE. Any help on how to uninstall

Re: [GENERAL] Replicating db structure changes

2007-07-26 Thread Magnus Hagander
On Wed, Jul 25, 2007 at 09:08:56PM -0700, Robby Russell wrote: Hey all, I'm catching up the replication options for PostgreSQL and was looking at slony, but was wondering if I could get some pointers. If I understand the slony documentation correctly, it doesn't allow me to send

  1   2   3   4   5   6   7   8   9   10   >