Re: [GENERAL] ntfs for windows port rc5-2

>>>rc5-2 msi will not install at all on a fat32 filesystem >>>even without initialising the database. >> >> >> Really? The code for checking the filesystem type is only executed if >> you chose to initdb, so I really don't see this happening. >Exactly what >> message do you get? >> >Log in the

Re: [GENERAL] Problem with win32 installer for PG 8.0

> Hi, > I installed beta 2 a couple of months ago, and today I > installed RC 5 and it seems there is no way to tell the > installer where to actually install, so I could not re use my > data cluster from the beta 2(with out renaming the directory > to the same name as what the installer would

Re: [GENERAL] Problem with win32 installer for PG 8.0

If you o this, don't expect your installation to work later. There is a reason for the safeguards in the system. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tzahi Fadida > Sent: Monday, January 17, 2005 1:35 AM > To: [EMAIL PROTECTED]

Re: [GENERAL] Postgresql 8.0 and Cancel/Kill backend functions

> > The cancel function is implemented. See > > > http://developer.postgresql.org/docs/postgres/functions-admin.html#FUN > > CT > > IONS-ADMIN-SIGNAL-TABLE. > > > > Kill function was considered too dangerous. > > Pity - I would have loved this for my test harnesses. I need > to drop and recrea

Re: [GENERAL] ntfs for windows port rc5-2

> >>Log in the temp install dir: > >>The Cacls command can be run only on disk drives that use the NTFS > >>file system > >> > >>I'll have to rip half or more of the full log as it seems to be to > >>large for the list to accept > > > > > > I assume you are talking about the initdb.log file? Th

Re: [GENERAL] ntfs for windows port rc5-2

> > chose no at that point, and it installs, then errors and completely > > un-installs. > > leaving a dir struct under program files with a single file: > > pgperm.log > > under the directory with the msi files in it there is a > full install > > log, which the list has twice refused to accep

Re: [GENERAL] Problem with win32 installer for PG 8.0

> Oh, and as for uninstalls and silent installations, Inno > Setup also provides that functionality automatically. It can > wrap the installation into a single EXE file, it can do disk > spanning, custom install types, compressed data in the > install file, creation of desktop/start menu short

Re: [GENERAL] Problem with win32 installer for PG 8.0

S as its free and has a nice gui to get me started. > >Thanks Jasper > >Magnus Hagander wrote: > >>>Oh, and as for uninstalls and silent installations, Inno >>>Setup also provides that functionality automatically. It can >>>wrap the installation into a single EXE

Re: [GENERAL] Bypass administrative permissions restriction on windows?

>I am trying to use Postgres as a embedded db from inside a >Java Desktop >application. I am trying to work our how to do the minimal install >manually and start/stop the database from Java. I have come across the >issue of Postgres not running as a user with administrative >permissions. >The

Re: [GENERAL] what happened to the website?

The website went down long before the news was posted to slashdot. By the time it hit slashdot, things were fixed already. Luckily. //Magnus > http://en.wikipedia.org/wiki/Slashdot_effect > > > On Wed, 2005-01-19 at 10:06, [EMAIL PROTECTED] wrote: > > What does that mean? > > > > > >

Re: [GENERAL] Backup DLL

AFAIK, there is no such thing. But you can use pg_dump in a pipe - that's all pgAdmin does.   //Magnus From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tope AkinniyiSent: Tuesday, January 25, 2005 1:25 PMTo: pgsql-general@postgresql.orgSubject: [GENERAL] Backup

Re: [GENERAL] EMBEDDED PostgreSQL

>>> 2.3) Why do I need a non-administrator account to run >PostgreSQL under? > >> Again, I think this is fine as the default, but it would be >nice if it >> could be changed with a setting (rather than recompiling the >source). >> Not all Windows users are dummies about security and need >Po

Re: [GENERAL] EMBEDDED PostgreSQL

>This has long been common practice in the Unix world, and is starting >to become standard practice in the Windows world as well as Microsoft >and other vendors work to improve the security of their systems. >== > >Again, I think this is fine as the default, but it would be nice if it >could

Re: [GENERAL] EMBEDDED PostgreSQL

> > Sorry, but any Windows user who thinks he doesn't need security > > measures equivalent to (not "beyond") minimum Unix practice > is a dummy > > about security. Take a look at this LOAD vulnerability > we're in the > > midst of patching, and ask yourself whether you aren't glad that it >

Re: [GENERAL] EMBEDDED PostgreSQL

> >> Not all Windows users are dummies about security and need > PostgreSQL > >> to enforce security measures beyond those implemented on other > >> platforms. > > > > First of all, it does *not* enforce anything beyond what's > enforced on > > Unix. On Unix, it doesn't run as root. On Windows

Re: [GENERAL] 8.0.0 RC5-2 Processes/Interfaces Under Windows

> I've installed this version on my Win2K machine and can > connect using pgAdminIII just fine. > > I then installed libpqxx 2.4.2 via (i.e., for and under) > cygwin and find that no matter what I do I cannot get the > most basic test routine (test001.cxx) to execute. The problem > appears to

Re: [GENERAL] Postgresql 8.0 beta 5 setup in windowsxp

http://pginstaller.projects.postgresql.org could be what you are looking for. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Art Fore > Sent: Friday, February 04, 2005 3:09 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] P

Re: [GENERAL] Tablespaces with Windows 2000

> I'm having a hard time trying to create a tablespace with > Windows 2000 and PostgreSQL 8. Is there a How-To somewhere on > the Net? I only find tablespace issues with Linux. One > article even claimed it was impossible with Windows, but > since I've tried it successfully in a localhost insta

Re: [GENERAL] Silent installation of postgres

> I want silent, non-interactive installation postgresSQL on Windows. > > I don't want to use the .msi provided for silent > installation. Is there any method by which I can just copy > the binaries and run some postgres script which will > configure the Postgres to work same as installed one?

Re: [GENERAL] windows xp install problem ("failed to set permissions on the installed files...")

> I have installed PG on Windows XP successfully several times, > but now I have one machine on which the install fails with an > error message: "Failed to set permissions on the installed > files. Please see the logfile at ..." . The log file in > question does not look very useful. It has lin

Re: [GENERAL] Postgre sql win32 silent install

> Dear list, > > I'd like to ask you if there is any way to install the > PostGre SQL Windows Server silently. I mean by writing a one > line command in the command line or sg like this... The whole > thing is because I'm writing an installer (a Visual Studio > 2003 Setup Project) for an appl

Re: [GENERAL] E-mail harvesting on PG lists?

> > This is truly worrisome... I wonder if spammers today are > basically > > subscribing to mailing lists so that they receive the > e-mails (seems > > like a very obvious trick), or if they're moving to the > next level of > > "decrypting" the "encrypted / anti-spam" form of e-mail > addr

Re: [GENERAL] Oracle DB Worm Code Published

> A recent article about an Oracle worm: > http://www.eweek.com/article2/0,1895,1880648,00.asp > got me wondering. > Could a worm like this infect a PostgreSQL installation? > It seems to depend on default usernames and passwords - and > lazy DBAs, IMO. > Isn't it true that PostgreSQL doesn't have

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

> Has anyone tried to install Postgres on Windows Sever 2003 > version R2? R2 is actually shipping as a 'new' Microsoft > product- it's basically an interim update to Windows Server ( > http://www.microsoft.com/windowsserver2003/r2/whatsnewinr2.msp > x

Re: [GENERAL] Unregister Windows Service pg_ctl error

> When I try to unregister the windows service I get an error like: > > C:\Program Files\PostgreSQL\8.1\bin>pg_ctl.exe unregister -N > "pgsql-8.1" > pg_ctl: could not open service manager > > This is on Windows XP and the logged user is postgres You need administrative privileges to unregister

Re: [GENERAL] Authentication via LDAP

> Hi, > > I've got Postgres 8.1.1 running on a Win32 platform. I would > like to authenticate users through an LDAP server and I saw > that is possble to do this under a Unix platform with the > pam_ldap package. > > Does anybody know if something similar is at the moment > available (or wi

Re: [GENERAL] Moving PostgreSQL data directory on Windows

> Hello, > > I would like to move the data directory to another location. > I have done this: > 1. Stop PostgreSQL > 2. Move data directory > 3. Create a PGDATA env. variable to the new location 4. Start > PostgreSQL > > And it cannot start, because it cannot find postgresql.conf. > (in Event

Re: [GENERAL] Plans for 8.2?

> I just did a test to see what comes up when I typed > "replication" in the search box at postgresql.org. Got a 503 > error. We really need to work on that. Bad enough we don't > use Postgres to do the searching. Yes we do. We certainly don't back aspseek with mysql... (No, we don't use the st

Re: [GENERAL] Moving PostgreSQL data directory on Windows

ice does not start. > This new directory definetely exists. But now there is no > Event log entry about the error. The log file says nothing > because it is in the data/pg_log directory. > > Thanks, > Otto > > > > 2006/1/13, Magnus Hagander <[EMAIL PROTECTED]>:

Re: [GENERAL] Unregister Windows Service pg_ctl error

> > You need administrative privileges to unregister a service. > Can't run > > it as user postgres. > > I did the same under "Administrator" but then I get an access > violation error like: > > Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC005: > Access violation reading location 0

Re: [GENERAL] Windows re-installation problem

> I uninstalled PostgreSQL from windows for the sake of > re-installing (for the sake of documenting an install for our > product on a clean machine), and now during re-install on the > Service Configuration screen I get "Invalid username > specified: Logon failure: unknown user name or bad pas

Re: [GENERAL] Does this look ethical to you?

> George Pavlov wrote: > > they have the same kind of page setup for pg Admin: > > > > http://pgsql.navicat.com/PG_Admin/index.php > > > > this one renders... > > > > both pages seem to tell robots not to cache them, so can't view a > > cached view on google. > > > At least PG Admin is free s

Re: [GENERAL] Does this look ethical to you?

> > There most certainly are companies making money from pgAdmin, > > including at least 2 of the most well known large PostgreSQL > > companies. In addition to potentially hurting them, you are trading > > off our long established name, which to add insult to injury you > > haven't even spelt

Re: [GENERAL] Does this look ethical to you?

> the personal expense of numerous people including myself. Why > should we advertise your or anyone elses commercial products > for free?> > > Because the installer is not letting it be known that there > are alternatives available, I have had many people tell me > they had no idea there whe

Re: [GENERAL] Alternative to knoda, kexi and rekall?

> > What about PgAdmin III, I know, it is now perfect but I prefer it a > > lot against similar commercial products. > > It is not availlable as a Debian-Package. ;-) Yes, it is. http://www.pgadmin.org/download/debian.php //Magnus ---(end of broadcast)-

Re: [GENERAL] Alternative to knoda, kexi and rekall?

> > PgAdmin III is available on Debian. Its package name is > pgadmin3. Try doing: > > > > apt-cache show pgadmin3 > > I am running Sarge and have found only pgaccess. > So it is in Testing or Unstable... You need to add one of the pgsql mirrors to get it. See http://www.pgadmin.org/download/de

Re: [GENERAL] Postgres using 100% CPU

> I have a fairly large (about 30Gb) PostgreSQL 8.1 database > running on Windows 2003 Server. > I noticed that CPU utilization on the server is 100% for past > few days, and postgres process is taking up most of that CPU > (95%-100%). There is only one connection to the database at > the time

Re: [GENERAL] Installing on NT4 machine

> Hi, > > Has anyone else had troubles installing PGSQL using the Win > installer package (msi) on NT4 machines? I've tried on two > separate machines and each time the install sequence fails to > complete successfully. Sorry the details are sketchy (I was > not performing the installations)

Re: [GENERAL] Postgres Win32 libpq Samples

> Hello, I am very new to postgreSQL I am using the win32 > platform is there a website URL that has Sample Client Apps > written for win32? > > I need Samples of very basic things like: > > Connect to a db on a remote server > create new db > create table > add records > drop records > > ect.

Re: [GENERAL] psql client binary

> > > Hopefully not to grievous an FAQ: can anybody point me at a > > > precompiled binary of the psql terminal-based front-end > to run on NT > > > hopefully not requiring Cygwin, or has this been > effectively replaced by pgAdmin? > > > > pginstaller has such a psql binary that should work o

Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3

> first of all, great effort from you this tool. > > Problem exists with following config: > - Windows XP Pro, SP2 (English). > - PostgreSQL-8.1.3 > - lot of development programs, and IDE-s (for the clients i > am working unfortunately they are windoz-based :-(...). > > Same problem occurs as

Re: [GENERAL] problem with windows xp sp2 and postgres-8.1.3

> the lsp-fix did the trick. As you supposed it was a personal > firewall (however a great product, called armor2net > personal), which unfortunately was broken with the winsock lib. Obviously not a gread product, I'd say, if it breaks the winsock stack. Which the hole purpose of a firewall is t

Re: [GENERAL] What's a good default encoding?

> > Maybe we could even "suggest" UTF8 in the "getting started" > (i.e. the > > windows installer initdb screen, or other default > installations) Sth. > > like "if you do not know better, take utf8" > > UTF-8 on windows works pretty well. It does, but it has an extra speed penalty. For any c

Re: [GENERAL] PostgreSQL on Windows not starting

> I have a customer who is having issues starting PostgreSQL > 8.1 on Windows. It worked for a while and now doesn't appear > to be running. I thought it was probably a stale pidfile, > but had him search and could not find it. Is the pid > information still in a pidfile or is it in the regi

Re: [GENERAL] Licensing of .DLL files

> None of these licenses prohibit distribution, AFAIK. > > You may have to offer source, etc. We normally just bundle > all source tar files for similar components that we > distribute with our code. If you do that, there's definitl no problem. We wouldn't bundle anything that doesn't uphold *

Re: [GENERAL] question about the admin contrib module and binary

> There's also a licensing issue which is that pgAdmin is GPL, > while we're trying to make sure that all contrib modules are > licensed the same as the core server. No, pgAdmin is Artistic License, not GPL. Still not BSD, tough, so the argument still holds even if the difference isn't as big.

Re: [GENERAL] pgsql continuing network issues

> > IF I change the listen_addresses directive to localhost, I > can connect > > fine and everything works EXCEPT I get the message "NOTICE: Unknown > > win32 socket error code: 10107" repeatedly anytime I do something. > > This would be acceptable, except that I need to be able to > access thi

Re: [GENERAL] error message on http://techdocs.postgresql.org/ during redirect

> If I click on a link while on the > http://techdocs.postgresql.org/ site, for example, under > "Quick Reference Material", "PostgreSQL Notes", I briefly > see an error message that says: "Notice: Use of undefined > constant userid > - assumed 'userid' in > /usr/local/www/techdocs.postgresql

Re: [GENERAL] Why postgres install requires physical access to server in windows

> Remote install of Postgres 8.1.3 using Windows installer > binary package is not working (says that console mode is > required) even when RDP client is started with > > mstsc /console > > switch. It should work fine with this switch. I've used it many times. > However, using installer pack

Re: [GENERAL] Why postgres install requires physical access to server in windows

> >> mstsc /console > > > > It should work fine with this switch. I've used it many times. > > I ran "mstsc /console" from my XP Proffessional and tried to > install Postgres 8.1.3 in two different > servers: > > Windows 2003 > Windows 2000 > > Both cause the following message: > > ---

Re: [GENERAL] How to import a CSV file (originally from Excel) into a Postgresql 8.0.7 database

> Hello, > > I am trying to import an Excel file in my database (8.0.7). I > think I am supposed to create an CSV file out of my Excel > file and somehow, feed the database with it. My pronblem is > that I don't really know how to do it... :( Can anyone give > me a hint about how to do that? >

Re: [GENERAL] How to import a CSV file (originally from Excel)

> > \copy "Flight Traffic" from yourfile.csv delimiter as ',' > csv quote as > > '"' > > > > (might need some adaption, of course) > > > > > > Loading 45,000 lines is trivial for copy, it shouldn't take > noticable > > time at all. > > along these lines - can I do something similar (CSV

Re: [GENERAL] how can I create the DML for an existing database - within an application

> I want to get the output from > > pg_dump --struct-only --table=whatever > > inside a programm. Of course I could call pg_dump in a > seperate process and capture the output and all; but ... > > as PGAdmin is doing it someway, I strongly suspect there is a > kind of call to recreate the DML

Re: [GENERAL] Curious UDP packets

> Hello. There are messages like this in shorewall's logs. > x.x.x.x is my site's IP address, both as the source and the > destination. I've been told that they're caused by > postgresql. Having these messages filtered out doesn't seem > to affect postgresql in any way. Does anyone know wh

Re: [GENERAL] Curious UDP packets

> > > omega kernel: Shorewall:all2all:REJECT:IN= OUT=lo SRC=x.x.x.x > > > DST=x.x.x.x LEN=1016 TOS=0x00 PREC=0x00 > > > TTL=64 ID=21629 DF PROTO=UDP SPT=32769 DPT=32769 LEN=996 > > > > The PostgreSQL stats collector uses UDP over a random > loopback port. > > It should normally use localhost, t

Re: [GENERAL] Installing PostgreSQL on Win 2003 R2 64-bit

> On 4/27/06, Aly Dharshi <[EMAIL PROTECTED]> wrote: > > Yes, if you search the archives there was something on > this. Maybe it > > was around 32-bit, but nonetheless, take a search through. > > There is a patch in the queue written by Magnus Hagander > right

Re: [GENERAL] Using the REPLACE command to replace all vowels

> Is there a way to make seperate replacements in 1 field in > one command in SQL? > > I need to remove all vowels (a,e,i,o,u) in a field. How would > I go about that? Try something like SELECT regexp_replace(your_string,'[aeiou]','','g') ... (btw, if you want all vowels, don't forget 'y' :-P)

Re: [GENERAL] logfiles filling up

Do you actively use SSL on this server? //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Erik > Myllymaki > Sent: Wednesday, May 03, 2006 3:36 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] logfiles filling up > > I will

Re: [GENERAL] logfiles filling up

From: Erik Myllymaki [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 03, 2006 3:49 PM > To: Magnus Hagander > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] logfiles filling up > > yes I do. > > > Magnus Hagander wrote: > > Do you active

Re: [GENERAL] logfiles filling up

> -Original Message- > From: Erik Myllymaki [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 03, 2006 6:17 PM > To: Magnus Hagander > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] logfiles filling up > > I don't see any kind of PID in the logfiles a

Re: [GENERAL] linker

You need to link with wsock32.lib. //Magnus > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of srinivasa.n > Sent: Thursday, May 04, 2006 2:33 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] linker > > Hi I am new to postgre sql I am tryi

Re: [GENERAL] Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore

> The latest version (V8.1.4) breaks the setup process of our > application's installation wizard. We used to call > "createdb.exe" and piped the password for the postgres user > (which has been entered by the user in our setup wizard's > dialogs) into it. > > With version V8.1.4 this is not p

Re: [GENERAL] Best high availability solution ?

> Hi list ! > > I have a small enterprise network (~15 workstations, 1 > server), all running windows OSes. Most of our work is done > on a PostgreSQL DB (on the windows server). > I am the only IT here, and my boss asked me to find a way to > have the database always online, without my interve

Re: [GENERAL] Best high availability solution ?

> >Since you're a Windows shop, you may already have the > experience (and > >even liceneses perhaps?) to run Microsoft Cluster Service > (part of 2003 > >Enterprise Edition or 2000 Advanced Server). PostgreSQL will > work fine > >with it. Works with shared disks using either fibrechannel or

Re: [GENERAL] Problem V8.1.4 - providing pwd for commandline tools doesn't

> I don't understand why the change should be "more secure", > but I see that nobody took care about the possible > consequences for installation scripts, third party > applications and so on. :-((( If the installation scripts and third party apps followed the standard way of doing it, they wou

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

> > I don't think anyone ever imagined that the bug actually allowed > > people to use utilities in a way that was useful to them, but > > unintended by everyone else. Had we done, we would > certainly have made > > the warnings more obvious and considered workarounds. > > Actually, we thought

Re: [GENERAL] psql: krb5_sendauth: Bad application version was sent (via sendauth) - Windows 2000, MIT Kerberos, PG v 8.1.1

> I'm trying to setup Kerberos authentication with PG on Windows 2000. > > I have installed the MIT Kerberos Windows dlls into the PG > bin directory > - replacing the krb5_32.dll and comerr32.dll from the PG install. > I did this because the PG install did not have the > krbcc32.dll, which is n

Re: [GENERAL] Installing PostGreSQL automatically

> Normal none Normal interactive user installation > Reduced /qr No user interaction. "Full size" progress window including > progress descriptions. > Basic /qb No user interaction. Just a basic progressbar and not full > descriptions. > Silent /qn No user information at all. > > > Yet, these

Re: [GENERAL] Installing PostGreSQL automatically

> tried calling the '-int' MSI but I get an error telling me > "The installer has encountered an unexpected error installing > this package. This may indicate a problem with the package. > The error code is 2711." > > This is my command line > > msiexec /i postgresql-8.1.msi /qr INTERNALLAUNC

Re: [GENERAL] Import Data from MS SQL Server

> Hi.. > Im Daniel and need soem help in importing data from MS > SQL Server to Postgresql DB. Is there a bulit in option for > importing from Postgresql? Help me out!! You can easily use the DTS tool in SQL Server to export data to PostgreSQL through the ODBC driver. //Magnus --

Re: [GENERAL] Can PostGreSQL slow down a Windows PC much?

> Our software will be using PostGreSQL as a database. Now I > was wondering, if the database is installed on lets say an > entry level Celeron, with 256MB of Ram, will it slow down the > PC at all? > > I'm not taking any queries into account here, just generally, > does installing the databa

Re: [GENERAL] postgres and ldap

> Hi > > I have started to use ldap for user authentication on my systems. > > 1 is it possible to get postgres to authenticate against ldap Yes. With current releases you can do this with PAM, assuming you're on a platform that can do PAM. If your platform can't do PAM (for example, Windows), y

Re: [GENERAL] postgres and ldap

> > 8.2 will have direct LDAP authentication without PAM. > > That code's going to go away real soon if some documentation > doesn't show up. I can't believe Bruce was sloppy enough to > accept a feature patch with zero documentation. ?? I thought I had sent in the docs for that. Will dig thro

Re: [GENERAL] postgres and ldap

> > > 8.2 will have direct LDAP authentication without PAM. > > > > That code's going to go away real soon if some > documentation doesn't > > show up. I can't believe Bruce was sloppy enough to accept > a feature > > patch with zero documentation. > > ?? I thought I had sent in the docs for

Re: [GENERAL] Question about openSSL

> 1.) I went to the OpenSSL ste, and tried to download > opnSSL, but I only saw Linux files. Is OpenSSL supported ni Windows? Yes. They do a good job of hiding their binaries thouhg. You can get them from http://www.openssl.org/related/binaries.html. > 2.) I am using the Npgsql.NET data

Re: [GENERAL] Question about openSSL

> You will need to copy the two dlls > (ssleay32.dll,libeay32.dll) to the same directory where you > have your npgsql.net assembly. If we're talking npgsql (http://pgfoundry.org/projects/npgsql), that information is incorrect. Npgsql uses a managed implementation of SSL, so it does *not* use the

Re: [GENERAL] Question about openSSL

> Well, then what do I need to get NpGSQL connecting to my > server with SSL? > > Do I just turn SSL on in the database and in my connection > string set SSL to true? Yes. You need to have the Mono.Security.DLL (or similar named - and this is needed on MS .Net as well!), btu that's it. It's inc

Re: [GENERAL] psql for winxp?

> > Is it possible to have the installer only emplace psql and the > > necessary support libs? > > > I'm not sure offhand. The installer has customization > options, so it may be possible. But if not, it is probably > easy enough just to install it, copy the files that you need, > and then un

Re: [GENERAL] Postmaster is starting but shutting when trying to connect (Windows)

> Hello, > > i have a PostgreSQL (8.1) installation for testing purposes > which was running fine for several months now (Windows XP). I > was working with it yesterday, and today after booting my > computer and restarting the service (I'm starting the service > manually, because I don't need

Re: [GENERAL] Error code 1063

> We have PostgreSQL 8.1 running on Windows 2000 for a few > weeks now, when we try to start the service, it could not > start claiming no error returned. So, I go to the command > prompt and run the following: > > "C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe" runservice > -N "pgsql-8.1" -D

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

> > > well, since he wrote his app in vb.net he is probably using > > > postgresql as a dumb data store, it might not be all that > difficult. > > > still, not a very smart move. > > > > so if you have functions on server side or triggers or rules... > then > > you need some rewrite on the app... o

Re: [GENERAL] deploy postgre question

> Hi > > We need to deploy postgreSQL with our new app The app is designed > in Visual Studio 2005 and deployed in its own MSI. > Our question is - is it possible to call the postgreSQL msi from > our MSI or is it possible to merge PostGreSQL msi into ours. We use > Wise for Windows 6 to create ou

Re: [GENERAL] Pl/TCL: Is my Windows install missing scripts?

> The Windows-PosgreSQL 8.1.4 package I downloaded from the > PostgreSQL download site (right here) does not seem to contain the > scripts: > pltcl_delmod > > pltcl_listmod > > pltcl_loadmod > > Have I missed something, or can anyone else confirm? They're definitely not included there. Could yo

Re: [GENERAL] What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation

> >> Magnus, did you have a specific reason for choosing > Europe/Dublin, or > >> was it just alphabetically first? Europe/London looks at least > >> marginally closer to what one would think "GMT" means: > > > Does it have to be a specific city? I'd rather it just chose GMT. > > The fact that t

Re: [GENERAL] PostgreSQL and Windows 2003 DFS Replication

> Hi list ! > > I am currently deploying two servers (Windows 2003 R2) that will be > used as file servers as well as PostgreSQL servers. > > One of the server will be the main server, the other one a backup > server (no load-balancing, only an easy-recoverage solution). > The goal is to be able

Re: [GENERAL] Cutting the Gborg throat

> > > Hello, > > > > > > O.k. so how about a phased approach? > > > > > > 1. Contact maintainers to create their new projects on > > pgfoundry and > > > begin moving tickets > > > > > > 2. Migrate CVS > > > > > > 3. Migrate mailing lists > > > > Apparently something cut the throat first. GBorg is d

Re: [GENERAL] Cutting the Gborg throat

> >> Apparently something cut the throat first. GBorg is down since > Sunday. > > > > Neptune lost 2 disks at once... Buts whats more interesting is > that > > yours is the first complaint I've seen. > > Meaning what? > > A) Will be restored from backup > B) Data is lost finally and must be recov

Re: [GENERAL] Cutting the Gborg throat

> > You don't look carefully enough. There's been a couple of > complaints > > earlier. But no, not many. > > Perhaps it's because you responded with a message to the effect > "we're on it" when I asked, and people took that to mean that > prompt action was in the works :) Probably. Heck, that's

Re: [GENERAL] Estimate on gborg rescue?

> Hi, > > I just checked, and gborg is still dead. In fact, the hostname is > no longer valid (there's no A record). Do we have even an estimate > for when it will be back? Can the estimator please publish that > somewhere in big flashing letters or something? Yes, Marc posted to -www earlier

Re: [GENERAL] Majordomo drops multi-line Subject:

> >>> ever noticed/commented about it ... ya, you are the only one > >>> complaining about it :) > >> Honestly, it may be time we start looking at mailman. > > > > Please don't, unless Majordomo is really broken and unfixed (i.e. > > there isn't a newer version with the bug fixed). What version >

Re: [GENERAL] Majordomo drops multi-line Subject:

> > Seriously, I think that's the first time anybody said anything > good > > about the mailman interfaces Just the stuff I have to do for > the > > pgFoundry lists (of which I have only *two*) is just so much > pain. > > (who came up with such a brilliant thing as > > different-password-for-ev

Re: [GENERAL] FW: Postgres alongside MS SQL Server

> >How is it possible for Postgresql to "freak out" and take out the > >machine? > > How easy/likely is it for a program run as a normal user to > blue screen an MS server? > How easy/likely is it for a program run as a normal user to > do the equiv to > a FreeBSD/Linux server? With *decent d

Re: [GENERAL] Partial index in other DB

>Can anybody confirm whether these databases support partial >indexes (and >what are their term and syntax)? > >SQL Server 2000: I've glanced the T-SQL Reference and it seems it >doesn't support it, though it supports indexing views. CLUSTERED index >is not the same thing, right? No. A CLUSTER

Re: [GENERAL] win32 port

> > ...i have little experience in linux and i work on windows. > > > I don't know the current state of the Windows port (PG 7.5) > but as I understood it currently won't run as service at all. > For getting a service you need to go with cygwin ... Current snapshots have full service integrati

Re: [GENERAL] Sql injection attacks

> Most of the online literature is on MS SQL Server. There, the > consensus seems to be that the range of potential attacks is > so wide that attempting to spot attack signatures in posted > data is a doomed enterprise, and that the safest general > approach for any dynamically built query is t

Re: [GENERAL] Pgsql beta 8 on windows starts and stops automatically.

> Hello all, > > I am testing PostgreSQL 8.0 beta on a windows xp > professional. In the time when I did the install I have been > working with pgadmin and so on... > > But after a few days, when I tried to continue with my tests. > I cannot start the postgresql service. I always get this

Re: [GENERAL] beta3 winxp initdb problems

> Hello, folks, > > I am trying to install pgsql8 on winxp. I tried first to install "as > is" with pginstaller beta2-dev3, no luck, it froze, switched off > Nod32, froze a little later, ran through the list of services, > switched off anything that seemed to be a firewall, no luck. > > So I comp

Re: [GENERAL] PostgreSQL 8.0 install woes

Title: Meddelande Make sure the server actually listens on connections other than 127.0.0.1 - check "listen_addresses" in postgresql.conf.     //Magnus   -Ursprungligt meddelande-Från: Taber, Mark [mailto:[EMAIL PROTECTED] Skickat: den 4 oktober 2004 20:29Till: [EMAIL PROTE

<    5   6   7   8   9   10