Re: [GENERAL] Is the FTP server down?

2005-03-30 Thread Magnus Hagander
>I get time out errors from all mirrors when trying to download 8.0 win >binaries. > >Apologies if this is the wrong forum for this. I just tried a couple, and they all seem to be working. Perhaps you have a firewall that's blocking you out of ftp connections? //Magnus --

Re: [GENERAL] PostgreSQL and .NET

2005-04-03 Thread Magnus Hagander
> If there was idea to implement a .NET support in Windows >version of PostgreSQL? Like existing Pl/Java We have a .Net client. You want server-side .Net? No one has ever talked about that, sorry. >>> >>> not knowin gmuch about .Net ... what is a 'server-side >.Net'? Like a

Re: [GENERAL] stored procedures / C-Language

2005-04-04 Thread Magnus Hagander
Title: stored procedures / C-Language   hi, i'm trying to find some documentation about writing stored procedures with C-language. i found description in postgresql's documentation but i don't understand everything. Aat present, i have a pl/perl stored procedure but it isn't

Re: [GENERAL] cygwin and psql

2005-04-05 Thread Magnus Hagander
Title: Meddelande It needs to be removed fromt he path of the server process if you want to use PL/Perl, PL/Tcl or PL/Python. If not, you should be ok having it ni there, just not during the installation. It should have no effect in the clients environment.   //Magnus -Ursprungligt

Re: [GENERAL] Can't install plpython on Windows 8.0

2005-04-09 Thread Magnus Hagander
>>> Probably the problem has to do with not finding the underlying >>> language's DLL (eg, python.dll). > >> Do I need to install a particular version of python then? Is >there any >> further documentation that can help me with this? > >Darn if I know. If the installer documentation doesn't tell

Re: [GENERAL] PostgreSQL 8.0.2 Now Available

2005-04-11 Thread Magnus Hagander
> For a full list of bugs fixed in this version, please see the > HISTORY file, which can be found at: > > http://www.postgresql.org/ftp/source/v8.0.2/HISTORY This link should be: http://wwwmaster.postgresql.org/download/mirrors-ftp?file=source%2Fv8.0. 2%2FHISTORY or simply http://www.po

Re: [GENERAL] Favorable Postgresql write up

2005-05-04 Thread Magnus Hagander
I read the reason for the 5 out of 10 as "little win32 post-install specific documentation", which is quite true, and few google hits on "postgresql getting started" (which is kind of true - 600k vs 2.5M for mysql vs 2.6M for oracle. But it can be debated wether 600,000 pages should actually be enu

Re: [GENERAL] windows 1252 encoding

2005-05-13 Thread Magnus Hagander
> Is there a reason that the windows code page 1252 is not supported? > The encoding Latin1 would be the most appropriate, but 1252 > is a superset of ISO8859-1 and supports more characters, and > when I want to write them through odbc I get an error. > psqlodbc 8 converts everything to utf-8 and

[GENERAL] Kerberos v4 users?

2005-05-22 Thread Magnus Hagander
Is there anybody out there who is using Kerberos v4 with PostgreSQL? If so, please contact me :-) //Magnus ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Magnus Hagander
Title: Message Just get the latest openssl binary download from their site (linked from their site, that is, I think their main site only carries source) and just copy over the file. Make sure you replace *both* openssl DLLs - ilbeay32.dll and ssleay32.dll - they should always be the same ve

Re: [GENERAL] How do I reinstall libeay32.dll

2005-06-04 Thread Magnus Hagander
:[EMAIL PROTECTED] Sent: den 4 juni 2005 19:37To: Magnus Hagander; 'Jon Christian Ottersen'; pgsql-general@postgresql.orgSubject: RE: [GENERAL] How do I reinstall libeay32.dll Sorry, I am a bit newbie to this. I am not able to find links to these files on the openssl web

Re: [GENERAL] vulnerability/SSL

2005-06-08 Thread Magnus Hagander
> Hi, > I¡¯m using postgreSQL with SSL these days. The version I¡¯m > using is 8.0.3. I found that it¡¯s impossible to use an > encrypted key file. > When you use a protected server.key file, you will be > prompted to input your passphrase EVERYTIME IT¡¯S USED, not > only when you start the se

Re: [GENERAL] vulnerability/SSL

2005-06-09 Thread Magnus Hagander
> The EFS encryption as you described it adds nothing but a > false sense of security (and the ability to use some more > buzzwords). The level of protection is just the same of a > Unix file with the right permissions. > The key point here is that both the 'postgres' user and > 'administrator

Re: [GENERAL] vulnerability/SSL

2005-06-09 Thread Magnus Hagander
> > > The EFS encryption as you described it adds nothing but a false > > > sense of security (and the ability to use some more > buzzwords). The > > > level of protection is just the same of a Unix file with > the right > > > permissions. > > > The key point here is that both the 'postgres' u

Re: [GENERAL] vulnerability/SSL

2005-06-09 Thread Magnus Hagander
> > Yes, that is correct - runas is similar to su. But in order to do > > "runas", you need the service accounts password. Once you > are "root" > > on a unix system, you can do "su - user" *without* the password. > > That's a big difference. > > (You can also use the postgres accounts smartcar

Re: [GENERAL] Starting PostgreSQL on WinXP is not working

2005-06-09 Thread Magnus Hagander
> Hi, i'm working with PostgreSQL for a long time (about > three years), but always on Linux box. But recently, I had to > intall PostgreSQL on a WinXP machine! > The installation works fine, although the starting service > did not works in the finalization of the installation! The > instal

Re: [GENERAL] Case sensitivity

2005-06-12 Thread Magnus Hagander
> create table test (val varchar(10)); > insert into test values ('A'); > insert into test values ('a'); > select * from test where val < 'a'; > > Results on 8.0.1 linux server (UNICODE) > val > - > (0 rows) > > Results on 8.0.3 windows server (UNICODE) val > - > A > (1 row) > > I am

Re: [GENERAL] Case sensitivity

2005-06-13 Thread Magnus Hagander
> I looked into the problem further - and could not repeat the > problem on my windows XP machine. The problem was isolated to > a server which uses the 64bit edition of W2K3 server. > Otherwise the W2K3 64bit edition seems to run PG ok. > > Are there any plans for fixing the UNICODE encoding o

Re: [GENERAL] [HACKERS] [PATCHES] Removing Kerberos 4

2005-06-22 Thread Magnus Hagander
> > Last chance for any Kerberos 4 users to speak up --- otherwise I'll > > apply this soon. > > If you just want someone to test it I can do that. I don't > actually use it normally though. I don't think "just testing" is enough - somebody needs to actually maintain it... > As far as securi

Re: [GENERAL] [HACKERS] [PATCHES] Removing Kerberos 4

2005-06-23 Thread Magnus Hagander
> Has Kerb4 been marked as depricated in the docs at all? If > not it might be best to just do that and then yank it later. Yes, since 7.4. http://www.postgresql.org/docs/8.0/static/auth-methods.html#KERBEROS-AUT H http://www.postgresql.org/docs/7.4/static/auth-methods.html#KERBEROS-AUT H "Ker

Re: [GENERAL] Win32 users?

2005-06-26 Thread Magnus Hagander
-cut- It is correct that the installer does not put the PosgtgreSQL directory in the system PATH. This is intended behaviour - but mainly because we didn't have time to do a "proper fix" for the 8.0 release. We hope to give a choice to the user on what to do (where to put the shared DLLs, and wha

Re: [GENERAL] Web application development on Win32, deployment on Linux

2005-06-27 Thread Magnus Hagander
> I currently maintain a website which is deployed on LAMP, but > it is developed on Windows (WAMP?). I'm considering moving > both to use PostgreSQL. I'm curious as to whether others are > following a similar development/deployment model and if so, > what pitfalls/gotchas they have found. F

Re: [GENERAL] Windows XP installation problem

2005-06-27 Thread Magnus Hagander
> Hello! > I'm trying to install postgresql on WindowsXP box using > postgresql-8.0.msi. > The installation goes fine until running the service. I get a > message saying that postgre-8.0 failed to run as a service. I > checked system log and came across an error saying > that: PostgreSQL Databas

Re: [GENERAL] Web application development on Win32, deployment on Linux

2005-06-27 Thread Magnus Hagander
> > > I currently maintain a website which is deployed on LAMP, > but it is > > > developed on Windows (WAMP?). I'm considering moving both to use > > > PostgreSQL. I'm curious as to whether others are following a > > > similar development/deployment model and if so, what > > > pitfalls/gotc

Re: [GENERAL] DANGER Windows version might hurt you

2005-06-27 Thread Magnus Hagander
> I want to warn you all that you might hurt yourself by > banging your head against the wall or damage your karma by > using foul language if you find your postmaster rejecting to > work after a minor change in the postgresql.conf. (I changed > the listenig address to an IP instead of *.) Wind

Re: [GENERAL] automating backup ?

2005-06-28 Thread Magnus Hagander
> Hello. > I created a Windows XP schedule for backup, following your > instruction. Now I have a .bat file with this script: > > cd D:\Program Files\PostgreSQL\8.0\bin > pg_dumpall >D:\MYDATABASE_DUMPALL -U postgres pg_dumpall > >D:\MYDATABASE_SHEMA -U postgres -s pg_dumpall > >D:\MYDATABASE_G

Re: [GENERAL] illegal sort order

2005-07-13 Thread Magnus Hagander
> I insalled Postgres 8 in Windows XP with default settings I > xreated database with encoding unicode. Unicode is not currently supported when the server runs on Win32, see http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. You'll need to pick a different encoding if you need locale-aware

Re: [GENERAL] NTFS partition autodetection during instalation

2005-07-13 Thread Magnus Hagander
> I want to embed postgres into a software installation. I will > use silent install, how do I detect which partition is NTFS > so I can tell the installer to use that partition? You can't do that inside the installer, you'll have to do it in your own script/program that wraps it. //Magnus --

Re: [GENERAL] To Postgres or not

2005-07-14 Thread Magnus Hagander
> > >The first sentence rules out MySQL, so the second sentence should > > >read "So that leaves Postgres". Your problem is solved ;-) > > > > > >(If you are accustomed to Oracle, you are probably > expecting an ACID > > >database, which rules out MySQL too). > > > > Does MySQL with InnoDB no

Re: [GENERAL] Postgres crashes,help to recover

2005-07-20 Thread Magnus Hagander
> > And do your disks honour the fsync? Was a power failure the > cause of this? > > > I have usual office PC using Quantum FireballP LM20.5 20 GB > IDE HDD with > XP drivers. > How to determine is fsync working or not ? > I use default postgres.conf file ( added only listen_addresses = '*'

Re: [GENERAL] Postgres crashes,help to recover

2005-07-20 Thread Magnus Hagander
> > What version exactly was this? There was some changes in > 8.0.2 in this > > area on win32. The default sync method was also changed at > this point. > > "PostgreSQL 8.0.2 on i686-pc-mingw32, compiled by GCC gcc.exe > (GCC) 3.4.2 (mingw-special)" There we go. That explains it - you have t

Re: [GENERAL] Cannot start DB system

2005-07-21 Thread Magnus Hagander
> All, > > I have postgreSQL 8.0 on winXP. This morning at 7:59am, the > db system could not start. > I looked at the pg_log. Started from yesterday 1:30pm, all > log files have this line: > > database system was not properly shut down; automatic > recovery in progress > > Then, I restarted t

Re: [GENERAL] DST and potential changes thereto

2005-07-23 Thread Magnus Hagander
> With the U.S. Government poised to tinker with Daylight > Saving Time, I have a couple questions. > > 0) Does PG rely on system-level TZ info or will specific > updates to PG be required? I'm interested in *nix but the > Windows folks are probably interested, too. Pre-8.0 relies on the syst

Re: [GENERAL] Can't connect after restart

2005-07-24 Thread Magnus Hagander
> Another question on the same matter: > > Do I need XP SP2 for pgSQL 8.0.3 to work correctly? I have > all the security patches, but not SP2. No, it shold work fine with both RTM and SP1. (That said, I'd definitly recommend SP2, but that is as a general matter not as a postgresql requirement)

Re: [GENERAL] PostgreSQL + windows xp + ipv6

2005-07-24 Thread Magnus Hagander
> Hi, I am with problems to function postgreSQL 8.0.3 in > windows XP with the Ipv6 protocol. I try to have access the > bank in the following way: > psql -h ::1 -d db_teste -u postgres > but it gives an error: could not translate ::1: Unknown host. > already I configured the archive pg_hba.conf

Re: [GENERAL] transaction timeout

2005-07-26 Thread Magnus Hagander
> > > That said, I have seen some folks post about writing a > perl or shell > > > script that runs every x minutes looking for connections > that have > > > been idle for > a certain amount of time and kill the backend > > > associated with it (sigterm, not -9...) > > > > what are the implic

Re: [GENERAL] transaction timeout

2005-07-26 Thread Magnus Hagander
> > > > > That said, I have seen some folks post about writing a > > > perl or shell > > > > > script that runs every x minutes looking for connections > > > that have > > > > > been idle for > a certain amount of time and kill the backend > > > > > associated with it (sigterm, not -9...) > > > >

Re: [GENERAL] GUID for postgreSQL

2005-07-27 Thread Magnus Hagander
> > This is not really a viable replacement for a GUID == > globally unique > > identifier. Here global means that if I use the application in > > multiple databases, I'm guaranteed that no two identifiers > will be the > > same. Using a sequence will only support uniqueness for a single > >

Re: unicode error on win32 Was: Re: [GENERAL] pgmonitor

2005-08-02 Thread Magnus Hagander
See http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. //Magnus > -Original Message- > Sent: Tuesday, August 02, 2005 1:11 PM > To: pgsql-general@postgresql.org > Subject: Re: unicode error on win32 Was: Re: [GENERAL] pgmonitor > > I use a database with UNIBASE encoding too. Writ

Re: unicode error on win32 Was: Re: [GENERAL] pgmonitor

2005-08-02 Thread Magnus Hagander
> Hi Magnus, > > the docmentation does not realy help me ! > > Client: Win2k, german language settings, SET client_encoding > TO 'UNICODE' > Server: Win2k, german language settings, database with > UNICODE encoding > > I use PostgreSQL via ODBC and want to write and read strings > containing

Re: [GENERAL] Windows file path for copy

2005-08-03 Thread Magnus Hagander
> Windows XP SP2 with Postgresql 8.0.3 > Two commands on fails the other succeeds: > > Fails : > > select import_sharedata('C:\\Documents and > Settings\\Richard\\Desktop\\EzyChart-20050721'); > > Succeeds: > > select import_sharedata('C:\\EzyChart-20050721'); > > is it the spaces in the path

Re: [GENERAL] Need some help creating a database sandbox...

2005-08-03 Thread Magnus Hagander
> I'm trying to setup a "safe" testing database environment for > some unit testing of a web application. I would like to have > the unit tests restore the database to a known state before > every test. The simplest way I thought would be to have the > testing tools drop/create the testing da

Re: [GENERAL] Windows file path for copy

2005-08-03 Thread Magnus Hagander
oing to presume > that they can load from "their" desktop. For now I can > operate around the issue but will have to place instructions > in big letters unless I want to answer this adnauseum. > > > Magnus Hagander wrote: > > Windows XP SP2 wi

Re: [GENERAL] tables in public

2005-08-06 Thread Magnus Hagander
> Hello. > > Postgres automatically included some tables in my public domain: > pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser, I beleive these are from tsearch2. > spatial_ref_sys. And this is postgis. > I suppose it's because I switched on all additional options > during initdb... Yes

Re: [GENERAL] tables in public

2005-08-06 Thread Magnus Hagander
> Could you, please, give me short description of > functionalities of those modules? tsearch2 is full text indexing. postgis is geographical functionality. //Magnus ---(end of broadcast)--- TIP 5: don't forget to increase your free space map set

Re: [GENERAL] Querry and SMP mechine

2005-08-07 Thread Magnus Hagander
> Im using postgres 8.0.1 on Debian Sarge with 2 XEON 2.4 HT. > > doing cat /etc/cpuinfo shows that linux sees 4 cpu ( the HT effect ). > > I noticed that when im runing a big query only one of the > CPUs become loaded. > > Is it normal behavior ? am i missing something ? Yes, that is normal.

Re: [GENERAL] The cost of SET search_path TO

2005-08-09 Thread Magnus Hagander
> Hi, > > I will appreciate it if anyone can educate me on the cost of > using SET search_path TO for schemas at runtime. AFAIK, that's quite cheap. Shouldn't be a problem. > In > particular, for .NET data operations where there may be high > rate of connection/disconnection and reconnection

Re: [GENERAL] libpy and ENABLE_THREAD_SAFETY=1

2005-08-10 Thread Magnus Hagander
> Is the standard libpq.dll distributed by PostgreSQL8.0 for > windows thread safe by default ? No. It is safe as long as you use each PGconn on a separate thread but you cannot share the same PGconn between threads. //Magnus ---(end of broadcast)

Re: [GENERAL] Howto build libpq.dll using VC2003 and ENABLE_THREAD_SAFETY=1

2005-08-10 Thread Magnus Hagander
> Building without ENABLE_THREAD_SAFETY=1 works fine, but when > i add this option to the win32.mak some compiler error occur. > > d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.h(481) : error > C2143: syntax error : missing ')' before '*' > d:\postgresql-8.0.3\src\interfaces\libpq\libpq-int.

Re: [GENERAL] pgsql and php with windows.

2005-08-10 Thread Magnus Hagander
> Hmm, since you are using the Windows version, I'm not really > sure. If you have the right compiler and environment, it'd > be just a matter of getting the source for the same version > you have installed, and then "configure --with-openssl". > > It'd surprise me however to learn that the Wi

Re: [GENERAL] Linux Postgres authentication against active directory

2005-08-12 Thread Magnus Hagander
> Hi to all, > > Actually I try to authenticate my Linux Postgres installation > against Active Directory, I find 3 solution to use: > > 1) LDAP > 2) Pam and Kerberos > 3) Kerberos alone (3) is the one I've been using, and it works very well. I've been working on a HOWTO, but it' snot done yet.

Re: [GENERAL] Upgrading 8.0.2 to 8.0.3 on Windows XP

2005-08-15 Thread Magnus Hagander
> Hello Giovanni, > > I had a similar problem. I think the windows installer tries > to create a new service which he can't, since there is > already one with the same name. I uninstalled Postgresql but > told it to keep the data directory, rebooted the machine > (that's important since only

Re: [GENERAL] Authenticating using Windows XP login

2005-08-15 Thread Magnus Hagander
> Was looking to see if I could get pgAdmin to log into > postgresql 8.0.3 on Windows XP using the current windows > login information. Tried using the ident functionality on > pg_hba.conf to no avail. > > Can someone post a link to a how to on this subject please? > > Also can anyone tell m

Re: [GENERAL] libpy and ENABLE_THREAD_SAFETY=1

2005-08-15 Thread Magnus Hagander
> >>Is the standard libpq.dll distributed by PostgreSQL8.0 for windows > >>thread safe by default ? > >> > >> > > > >No. > >It is safe as long as you use each PGconn on a separate > thread but you > >cannot share the same PGconn between threads. > > > >//Magnus > > > > > > > > > But what i

Re: [GENERAL] Linux Postgres authentication against active directory

2005-08-15 Thread Magnus Hagander
> > > Actually I try to authenticate my Linux Postgres installation > > > against Active Directory, I find 3 solution to use: > > > > > > 1) LDAP > > > 2) Pam and Kerberos > > > 3) Kerberos alone > > > > (3) is the one I've been using, and it works very well. I've been > > working on a HOWTO, b

Re: [GENERAL] libpy and ENABLE_THREAD_SAFETY=1

2005-08-16 Thread Magnus Hagander
> >In theory, but I beleive there are build issues in the currently > >released version when it comes to building on win32 with > >ENABLE_THREAD_SAFETY. > > > >//Magnus > > > > > > > > > Thank you for this information. > > Your wrote: "In theory" > Do you know anybody who has tested this ? >

Re: [GENERAL] ~/pgpass

2005-08-16 Thread Magnus Hagander
> > On Fedora: wrong file permissions? > > Btw.: ~/.pgpass is only supported in 7.3 and later. > > Thanks. > > The permission is 0600 on Fedora. But must the file > (~/.pgpass) be owned by postgres? Also what could explain the > reason why it is not working on Windows XP where permission > is

Re: [GENERAL] SOCKET Conection on Windwos 2003 vs PostgreSQL 8.0.1

2005-08-25 Thread Magnus Hagander
> Hi, > > I´m Julio and a have a situation running W2003 and DBExpress. > > I connect to the W2003 with socket (:5432) and, when i save > the package on my table, a new postgres.exe process start. > Ok, no problems until here. I disconnect from the W2003 and > the new proccess just die...

Re: [GENERAL] Is there going to be a 8.1 beta for win32?

2005-08-26 Thread Magnus Hagander
> Is there going to be a 8.1 beta for win32? I assume you are talking about a binary version. The source version is already available. Yes, there is. But we're not quite ready yet, so it'll be a few days before it'll be out. Until then you can use the source version if youh ave the tools required

Re: [GENERAL] Problems Reinstalling PostgreSQL on XP

2005-08-26 Thread Magnus Hagander
It appears to die in CheckAvailableDLLs(). See question 3.1 in the FAQ at http://www.postgresql.org/docs/faqs.FAQ_windows.html. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ben Trewern > Sent: Friday, August 26, 2005 4:58 PM > To: pgsq

Re: [GENERAL] pgclient hostbased authentication

2005-09-21 Thread Magnus Hagander
> Hello, > > may I ask, how(or which) ip is checked against pg_hba.conf IP > entry in NAT environment? > > Could it be, that psql client packs IP address of the client > into athentication data? No, it validates the source address on the TCP connection. In the event of NAT, it will check the

Re: [GENERAL] Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

2005-09-29 Thread Magnus Hagander
> Hi folks at pgsql.admin, > > I've Postgres 8.0.1 running natively under Windows XPpro SP2. > I would like to update to 8.0.3 using the upgrade-batchfile > coming with the zipped download file. > The installation stops when trying to install the service, > saying the Postgres 8.0 Database Serv

Re: [GENERAL] installing several PostgreSQL instances on Windows

2005-09-30 Thread Magnus Hagander
> Hello. > > Is it possible to install several completely independent > instances of PostgreSQL on the same Windows machine? > I'm asking this mostly because I want to have complete > control over my database, which is not possible if there is > some other superuser. Therefore I need dedicated

Re: [GENERAL] Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

2005-09-30 Thread Magnus Hagander
> > The way to do it is to deinstall the old version. What's > the problem > > with that? (it won't remove your data!) > > Well, maybe you're right. But why do that guys call it > upgrade if it doesn't upgrade!? I thought the purpose of > updating mechanism was easyness of upgrades. It usuall

Re: [GENERAL] Portable PostgreSQL

2005-10-02 Thread Magnus Hagander
> Hello Group: > > Is there any 'portable' version of PostgreSQL for Windows? By > 'portable' > I mean, I can just unzip files, run the initdb and then run > the postmaster and I get a temporary database server running > on port 5432 and accepting connections? Um, yes, this should go with any

Re: [GENERAL] Postgresql Vb.1 beta 2 win binary

2005-10-03 Thread Magnus Hagander
> Hello all, Is anyone having trouble downloading the Win 32 > binary announced on September 18? I am in Australia and > cannot download from any of the Australian or US mirrors. > Would like to receive confirmation whether or not I am the > stupid one!!! So what error msg do you get? Do you g

Re: [GENERAL] Postgresql Vb.1 beta 2 win binary

2005-10-03 Thread Magnus Hagander
son for it not being responded to may be a lack of information. That said, yeah, there are better ways to say that. //Magnus > > -Original Message- > > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > > Sent: 03 October 2005 18:24 > > To: John Craddock; pgsql-genera

Re: [GENERAL] License question

2005-10-04 Thread Magnus Hagander
> This brings me here. I have heard of PostGreSQL, so it's not > new to me. > But all this licensing is. And maybe you can help get some > clarification for the MySQL licensing too. > > We will not be selling the database software. We may install > it for them, though. In fact, most of the t

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

2005-10-06 Thread Magnus Hagander
> > Just so I know (and am armed ;) ), are there any new comparable > > features in MySQL 5.0 that aren't in PostgreSQL up to the > forthcoming > > 8.1? AFAIK, PG just lacks updatable views (which are on the TODO). > > PostgreSQL does not run in Windows 98 > > There is a LOT of customers runni

Re: [GENERAL] PostgreSQL's bug tracker

2005-10-11 Thread Magnus Hagander
> > On Mon, 10 Oct 2005, Joshua D. Drake wrote: > ... > > Just as a suggestion/thought ... *if* you have the resources (or > > someone else wants to step up to it), why not setup the bug > tracker, > > work with the -www guys on having the 'bug submission' > stuff feed into > > it, and get a >

Re: [GENERAL] PostgreSQL's bug tracker

2005-10-11 Thread Magnus Hagander
> > I have thought about that, however I would at least at some > level want > > a blessing. For example, if we did that would we do it with > pgFoundry > > bug tracking? Or would we use Trac? Or Bugzilla? > > I think the main thing that's killed previous proposals in > this line is that we c

Re: [GENERAL] problems with upgrade from 8.0.3 to 8.0.4, Windows

2005-10-11 Thread Magnus Hagander
> Hello. > I downloaded 8.0.4 Windows installer and wanted to update my > previos 8.0.3 installation, by using upgrade.bat. > Unfortunately I was not able to do it. Just before the end of > installation an error apears "Service 'PostgreSQL Database > Server 8.0' (pgsql-8.0) could not be installe

Re: [GENERAL] How to secure pgpass file from unauthorized reading of passwords ? (WIndows)

2005-10-12 Thread Magnus Hagander
> Hello. > > It seems that for all automated tasks (backup, autovacuum > etc.) passwords should be provided by pgpass file. > But, anyone can read pgpass file > > How can I make it secure that nobody can read it, except > programs for backup and autovacuum ? Set filesystem permissions on

Re: [GENERAL] Limitations of PostgreSQL

2005-10-13 Thread Magnus Hagander
> > [snipped] > > > >> May not be the best choice on Windows for production use, > though for > >> development, it should be adequate. > > > > Are there known issues with the Windows version for > production use, or > > is this simply because of the relative newness of the > Windows-native

Re: [GENERAL] Using LISTEN/NOTIFY in C#.NET

2005-10-14 Thread Magnus Hagander
> > To make the long story short...my question is this..is it > possible to > > run the listener command in C# or will it only work in psql? > > There's no theoretical reason why not. You probably need to > read the docs on whatever C# Postgres driver you're using > (ADO, ODBC etc) and find o

Re: [GENERAL] Windows Installation error

2005-10-15 Thread Magnus Hagander
> This error is shown after choose the language in the > installation of Postgresql 8.0.3 in windows 2000: > > "The installer has detected an incompatible version of > OpenSSL installed in your system PATH. PostgreSQL requires > OpenSSL 0.9.7 or later. If you remove your OpenSSL files > (LIBEA

Re: [GENERAL] Urgent : Postgresql installation error somebody help

2005-10-15 Thread Magnus Hagander
> Hi all, > I am trying to create an installable for my metalscan java > application. Here are the specs:- I have created the > installable using GKsetup(Gkware.com) a third party tool. I > am using Postgresql 8.0.2 as my database for my Java > application(metalscan). When the setup executable

Re: [GENERAL] backends and pg_stat_activity

2005-10-17 Thread Magnus Hagander
> Is there a way to get the ip address of the connections > listed in pg_stat_activity? It is - in 8.1 :) Until then, I think you'll need to do a netstat -nap or such a command and match the pids. Manually. //Magnus ---(end of broadcast)--- TIP

Re: [GENERAL] password

2005-10-21 Thread Magnus Hagander
> Hi. > I was installing postgresql 8.0 and let it generate a > password for me, then i changed my mind and went back to > change the password, but then i was stuck. How do i find the > password it generated for me? How do i change it? How can i > start over and install postgresql somehow? Than

Re: [GENERAL] PgInstallerfor 8.1 beta 3 missing Postgis?

2005-10-21 Thread Magnus Hagander
> I don't know whether I should be posting to Hacker Win 32 or > General, but I wanted to ask if anyone else has experienced > troubles restoring a DB on windows to 8.1 from 8.0.x when the > DB contains GIS tables. That really should go on the pginstaller list. Copying there. > As far as I ca

Re: [GENERAL] looking for alternative to MySQL's GROUP_CONCAT function

2005-10-21 Thread Magnus Hagander
> Hi all, > > I'm looking into PostgreSQL. Coming from a MySQL background, > I have made heavy use of its very useful GROUP_CONCAT > function. You can read about the function > here: > > http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html > > Is there a PostgreSQL alternative to GR

Re: [GENERAL] PgInstallerfor 8.1 beta 3 missing Postgis?

2005-10-22 Thread Magnus Hagander
> Magnus, > I have replied to general as well as the only mailing list I > could find on PG Foundry for pginstaller was the Devel list. > > I actually do have all those files - the trouble is that the > name changes make pg_restore fail on a dump from a 8.0.3 > Database with spatial (postgis) t

Re: [GENERAL] pg_autovacuum (8.0.4) as Windows service ?

2005-10-23 Thread Magnus Hagander
> When installing pg_autovacuum as Windows service, should user > that makes connection be the service account or a superuser ? > For example, I have service account "postgres_service" and > database superuser "postgres". Which one should be used in > following script: > @echo off > set TARGET_D

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.1 Beta 4

2005-10-24 Thread Magnus Hagander
> In order to address some issues found with the Windows port, > as well as GCC4, we have released a Beta 4 of the upcoming > 8.1 Release. Are you specifically referring to the interrupt/signals test on windows here? Because that one isn't in beta4, it was disabled again before it was packaged..

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.1 Beta 4

2005-10-24 Thread Magnus Hagander
> >> In order to address some issues found with the Windows > port, as well > >> as GCC4, we have released a Beta 4 of the upcoming > >> 8.1 Release. > > > > Are you specifically referring to the interrupt/signals test on > > windows here? Because that one isn't in beta4, it was > disabled agai

Re: [GENERAL] Prevent application log pollution with notice messages

2005-10-24 Thread Magnus Hagander
> Also: > > They cannot be filterad out since all Postgres log entries > have type Error, e.q. > LOG: database system is ready message is Erorr message ! > > Why postgres uses Error category for NOTICES ? Is'nt it > reasonable to use Information type ? This should be fixed in 8.0.4, and in

Re: [GENERAL] alt+F not working after calling pg_dump

2005-10-25 Thread Magnus Hagander
> I call pg_dump to create backup copies from my application > using Windows > CreateProcess() API call. > > After pg_dump finishes, Alt+F ( to open File menu) and other > Alt key combinations in my application stop working. > > If I use Alt+Tab to switch to other application and then back > t

Re: [GENERAL] Why database is corrupted after re-booting

2005-10-30 Thread Magnus Hagander
> 1. Windows XP > 2. QUANTUM FIREBALLP LM20.5 (IDE drive) > 3. Write caching is off in XP device manager > 4. fsync is ON in Postgres 8 Coming late into the discussion, there is one more note I'd add to this - if you're on windows and want to be extra secure, also set wal_sync_method=fsync_writet

Re: [GENERAL] Programmatic method to determine currently installed Windows PostrgreSQL version

2005-11-07 Thread Magnus Hagander
> Hi, > > I'm in the process of creating an Windows installation > package for a product that uses PostgreSQL. > > During the installation I would like to check if PostgreSQL > is installed and if it is, which version. > > I think that I can infer that PostgreSQL is installed by > searching f

Re: [GENERAL] Programmatic method to determine currently installed Windows PostrgreSQL version

2005-11-08 Thread Magnus Hagander
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\{317D0ED1 > > > -8845-40DD-A028-0A3EB8E24F2E} > > > "Version"="8.1-beta4" > > > > > > So it looks like the version number is underneath > > a key that > > > changes with every new version (new Product > > number). And I > > > am therefore no

Re: [GENERAL] Windows installer fails for 8.1

2005-11-10 Thread Magnus Hagander
See http://www.postgresql.org/docs/faqs.FAQ_windows.html, question 3.1. Your problem is most likely with a broken DLL file in the system path, usually from cygwin. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Richard Sydney-Smith >

Re: [GENERAL] How to install Slony in windows

2005-11-10 Thread Magnus Hagander
> Postgres 8.1 PgAdmin help in slony windows says: > > "In case you're installing a PostgreSQL 8.1 server on Win32, > the windows installer routine can do this for you if you > select the "Slony-I" > installation option. " > > How I can select Slony-I installation option ? > I havent seen such

Re: [GENERAL] psycopg2 problem with libpq.dll , Postgres 8.1.0 Win XP

2005-11-13 Thread Magnus Hagander
> Hello. > I was using psycopg2/Python with Postgres 8.0.4, on Win XP. > Now, when I installed Postgres 8.1.0 and was trying to > connect with Python/psycopg2, an error occured: "This > application has failed to start because lipq.dl was not > found. Re-installing the application may fix the p

Re: [GENERAL] recovering windows database after crash

2005-11-15 Thread Magnus Hagander
> Hello, > > I have postgresql 8.0 under windows, with pgadmin 3 > Unfortunaly i have met a problem with postgresql which > obliged me to reinstall postgresql. The bad thing is i have > no backup of my database before the crash (shame on me !! ;-)) ) > > So i wonder if it is possible, with

Re: [GENERAL] Customizing the Windows installer

2005-11-15 Thread Magnus Hagander
> Hello. > > We'd like to start deploying PostgreSQL to our customers. > They run primarily on Windows and are very low tech for the most part. > > I need the install routine to do a number of things after > install, including creating a database and primary user. > > I know that the 8.0 beta

Re: [GENERAL] Permissions required for service user account _after_ installation

2005-11-15 Thread Magnus Hagander
> The "Silent install of PostgreSQL on Windows" document states > that "The service user needs Log on as a service, Log on > locally and Access this computer from the network." If the > PostgreSQL database will only be accessed via localhost, are > these permissions still required after the in

Re: [GENERAL] Does PG Support Unicode on Windows?

2005-11-17 Thread Magnus Hagander
> Is there any truth to what this guy is saying? Yes, some. But not much. > > > On the other hand, Postgresql claims that "Windows > does not support > > > Unicode" and you can't have Unicode fields on > postgresql on Windows. > > > This is a big mistake. See: > > > > http://pginstaller.project

Re: [GENERAL] Rebranding PostgreSQL

2005-11-17 Thread Magnus Hagander
> The silent capabilities of the installer will do nicely in > this regard...I can wrap it into my current NSIS script and > simply call out to the installer. However, I need to create a > empty database and initial user after install is complete. Is > there any way to "hook" custom scripts int

Re: [GENERAL] Trouble downloading Postgres

2005-11-21 Thread Magnus Hagander
> I'm trying to download the source for 8.1 but am having a > problem from both IE and Mozilla browsers. From either > browser, clicking on a donwload object link leads me here: Hi. This should be fixed by now, thanks for reporting it. (There were serious problems, but they were solved a short w

Re: [GENERAL] Any good HOWTOs on LDAP with PostgreSQL 8.1?

2005-11-21 Thread Magnus Hagander
> Can anyone point me to a good HOW TO on LDAP with postgreSQL > 8.0.x or 8.1? > > Also, while searching online, i came across dblink-ldap. > Is this another ldap utility or is it something i could use > to connect/link to a ldap application? If what you're trying to do is access LDAP data fro

<    2   3   4   5   6   7   8   9   10   >