Re: [GENERAL] pg_ctl start leaves dos window open

> I am running PostgreSQL 8.1 on Windows Server 2003. Our setup > should allow a normal (non-administrator) user to start the > database. Since the user is not allowed to start services, I > am trying a direct "pg_ctl start" approach. However, running > this from a shortcut, leaves a dos window

Re: [GENERAL] Silent start of Postgres in XP

> This causes Apache to run under SYSTEM account . > > Trying to use same approach with Postgres fails. Postgres > requires special user account and is not capable to create > this account without user intervention. Sure, it's very much capable of diong that. See http://pginstaller.projects.pos

Re: [GENERAL] vista

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

Re: [GENERAL] PostgreSQL 8.1.4 on Vista RC1

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

Re: [GENERAL] PostgreSQL 8.1 - SSL:Required

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

Re: [GENERAL] List of supported 64bit OS

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

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

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

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

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

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

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

Re: [GENERAL] 8.2beta1 installation fails

> 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

Re: [GENERAL] 8.2beta1 installation fails

> 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 from remote > desktop. > I selected Estonian locale

Re: [GENERAL] Problems running PostGreSQL silent install

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

Re: [GENERAL] Problems running PostGreSQL silent install

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

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

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

[GENERAL] Counting records in a PL/pgsql cursor

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

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

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

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

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

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

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

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

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

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

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

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

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

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

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

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

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

Re: [GENERAL] tsearch2 and pdf files

> 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

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

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

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

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

Re: [GENERAL] Authenticating with x509 certificate

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

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

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 instal

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

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

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

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 wou

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

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 resul

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

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

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

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

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

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

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

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 bro

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

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 id

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

On Tue, Dec 19, 2006 at 09:41:38PM +0530, Gurjeet Singh wrote: > On 12/19/06, 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,

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

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

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

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

Re: [GENERAL] windows - silent uninstall question

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 op

Re: [GENERAL] Unable to start server - winxp

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

Re: [GENERAL] Unable to start server - winxp

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 th

Re: [GENERAL] LDAP configuration problem

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 0.0.0.0 > ldap://dc.domain.com/dc=doma

Re: [GENERAL] LDAP configuration problem

box. What does the message show if you change the line per my suggestion below? (note the extra ldap token) //Magnus > On 12/29/06, *Magnus Hagander* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Wenjian Yang wrote: > > Hi, > > &

Re: [GENERAL] Installing support for python on windows

novnov wrote: > Then I tried something like what Adrian had suggested: > > D:\postgresql\bin>createlang -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.

Re: [GENERAL] Installing support for python on windows

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 ru

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

> 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 "c:/postgr

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

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

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

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 us

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

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

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

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

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

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

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

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 ho

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

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

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

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 th

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

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

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

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.

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

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 w

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

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

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

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 C

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

> 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

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

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

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

Re: [GENERAL] Problems compiling from source

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.

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

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

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.

Re: [GENERAL] Stats collector frozen?

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

Re: [GENERAL] Stats collector frozen?

Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: >>> "Jeremy Haile" <[EMAIL PROTECTED]> writes: >>>> Do you know of any workaround other than restarting the whole server? >>>> Can the collector be restarted individually?

Re: [GENERAL] Stats collector frozen?

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 f

Re: [GENERAL] Stats collector frozen?

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 d

Re: [GENERAL] Stats collector frozen?

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 d

Re: [GENERAL] Stats collector frozen?

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 d

Re: [GENERAL] Stats collector frozen?

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 pgwin32_waitfors

Re: [GENERAL] Stats collector frozen?

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

Re: [GENERAL] Stats collector frozen?

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

Re: [GENERAL] Stats collector frozen?

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?

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 p

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

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

Re: [GENERAL] Stats collector frozen?

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 he

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

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

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

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

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

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. :-) &

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

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 prof

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

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 remembe

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

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

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

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 Win

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

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

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

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

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

Re: [GENERAL] Priorities for users or queries?

Most likely, you do not want to do this. You *can* do it, but you are quite likely to suffer from priority inversion (http://en.wikipedia.org/wiki/Priority_inversion) //Magnus Adam Rich wrote: > There is a function pg_backend_pid() that will return the PID for > the current session. You could c

Re: [GENERAL] PostgreSQL and OpenLdap

On Sun, Feb 11, 2007 at 08:54:56PM -0200, Cristiano Panvel wrote: > Hi Friends, > > This is my first post in the list. > > I am not obtaining authentication my users of PostgreSQL in OpenLdap. > > 1) PostgreSQL was compiled with the support to ldap in a FreeBSD System. > "option --with-ldap for

Re: [GENERAL] daylight savings patches needed?

> >> So what happens if you have an old os with a new postgresql install? > >> Will CURRENT_TIMESTAMP always return the correct value even if the > >> system 'date' command is showing the wrong time? > > > Yes. > > Unless the user changes the system's clock setting (ie, its notion of > the curr

Re: [GENERAL] PostgreSQL and OpenLdap

On Mon, Feb 12, 2007 at 09:41:44PM -0200, Cristiano Panvel wrote: > Thanks Magnus, > > Now I am passing the line thus pg_hba.conf > > ## > hostall all 10.193.4.0/24 ldap > ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br > ## > > However error in login is occu

Re: [GENERAL] PostgreSQL and OpenLdap

> something is very strange > > Cris. > > On 2/13/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > >On Mon, Feb 12, 2007 at 09:41:44PM -0200, Cristiano Panvel wrote: > >> Thanks Magnus, > >> > >> Now I am passing the line thus pg_hba.con

Re: [GENERAL] PostgreSQL and OpenLdap

Cristiano Panvel wrote: > It does not appear nothing in log, only in /var/log/message the error > of failed in login. > > Feb 13 12:04:16 fns4 postgres[7055]: [4-1] FATAL: LDAP authentication > failed for user "scott" > Feb 13 12:04:20 fns4 postgres[7056]: [4-1] FATAL: LDAP authentication > fail

Re: [GENERAL] PGSQL 8.2.3 Installation problem

The installer is not supported in a fat environment. you need to install the binaries manually for that. /Magnus --- Original message --- From: RPK <[EMAIL PROTECTED]> Sent: 2-14-'07, 5:14 > > Paul, > > I installed on a Fat32 partition and gave the data directory path to an NTFS > part

Re: [GENERAL] PGSQL 8.2.3 Installation problem

On Thu, Feb 15, 2007 at 01:18:25AM -0300, marcelo Cortez wrote: > Paul > > Thanks for your time. > the installer log say: > > fixing permissions on existing directory C:/Archivos > de programa/PostgreSQL/8.2/data ... ok > creating subdirectories ... initdb: could not create > directory "C:/Arch

Re: [GENERAL] user input during runtime

David Fetter wrote: > On Fri, Feb 16, 2007 at 08:23:48PM -0500, Bruce Momjian wrote: >> Ashish Karalkar wrote: >>> Hello All, >>> I want to prompt user to input some value and do some action on that value >>> in runtime of a sql script. >>> Is there any psql command to do this ?? >>> I can use \ec

<    3   4   5   6   7   8   9   10   >