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

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

> 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 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] 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] Any good HOWTOs on LDAP with PostgreSQL 8.1?

> 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

Re: [GENERAL] Trouble downloading Postgres

> 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] Rebranding PostgreSQL

> 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] Does PG Support Unicode on Windows?

> 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] Permissions required for service user account _after_ installation

> 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] Customizing the Windows installer

> 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] recovering windows database after crash

> 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] psycopg2 problem with libpq.dll , Postgres 8.1.0 Win XP

> 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] How to install Slony in windows

> 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] Windows installer fails for 8.1

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] Programmatic method to determine currently installed Windows PostrgreSQL version

> 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] Programmatic method to determine currently installed Windows PostrgreSQL version

> 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] Why database is corrupted after re-booting

> 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] alt+F not working after calling pg_dump

> 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] Prevent application log pollution with notice messages

> 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] [ANNOUNCE] PostgreSQL 8.1 Beta 4

> >> 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] [ANNOUNCE] PostgreSQL 8.1 Beta 4

> 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] pg_autovacuum (8.0.4) as Windows service ?

> 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] PgInstallerfor 8.1 beta 3 missing Postgis?

> 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] looking for alternative to MySQL's GROUP_CONCAT function

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

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

> 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] backends and pg_stat_activity

> 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] Urgent : Postgresql installation error somebody help

> 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] Windows Installation error

> 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] Using LISTEN/NOTIFY in C#.NET

> > 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] Limitations of PostgreSQL

> > [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] How to secure pgpass file from unauthorized reading of passwords ? (WIndows)

> 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] problems with upgrade from 8.0.3 to 8.0.4, Windows

> 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] PostgreSQL's bug tracker

> > 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] PostgreSQL's bug tracker

> > 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 8.1 vs. MySQL 5.0?

> > 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] License question

> 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 Vb.1 beta 2 win binary

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] Postgresql Vb.1 beta 2 win binary

> 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] Portable PostgreSQL

> 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] Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

> > 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] installing several PostgreSQL instances on Windows

> 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

> 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] pgclient hostbased authentication

> 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] Problems Reinstalling PostgreSQL on XP

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] Is there going to be a 8.1 beta for win32?

> 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] SOCKET Conection on Windwos 2003 vs PostgreSQL 8.0.1

> 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] ~/pgpass

> > 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] libpy and ENABLE_THREAD_SAFETY=1

> >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] Linux Postgres authentication against active directory

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

> >>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] Authenticating using Windows XP login

> 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] Upgrading 8.0.2 to 8.0.3 on Windows XP

> 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] Linux Postgres authentication against active directory

> 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] pgsql and php with windows.

> 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] Howto build libpq.dll using VC2003 and ENABLE_THREAD_SAFETY=1

> 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] libpy and ENABLE_THREAD_SAFETY=1

> 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] The cost of SET search_path TO

> 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] Querry and SMP mechine

> 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] tables in public

> 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] tables in public

> 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] Windows file path for copy

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] Need some help creating a database sandbox...

> 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

> 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: unicode error on win32 Was: Re: [GENERAL] pgmonitor

> 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: unicode error on win32 Was: Re: [GENERAL] pgmonitor

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: [GENERAL] GUID for postgreSQL

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

<    4   5   6   7   8   9   10   >