Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E

Re: [GENERAL] slow request

column's datatypes do not match This could be a DNS related problem, if not the request itself, but the connect, is slow. How did you measure these times and speeds? -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL

Re: [GENERAL] Anyone know a good opensource CRM that actually installs with Posgtres?

)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key

Re: [GENERAL] How to force disconnections from a Perl script?

! kj ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL

Re: [GENERAL] Installing PostgreSQL under Cpanel

0.02. Thanks anyway. ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web

Re: [GENERAL] Installing PostgreSQL under Cpanel

. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36

Re: [GENERAL] slow speeds after 2 million rows inserted

to type the data faster than what is being done by the java application on the third file. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF

Re: [GENERAL] slow speeds after 2 million rows inserted

[EMAIL PROTECTED] thought long, then sat down and wrote: I'm sorry to ask a stupid question, but how do I 'commit' the transactions? Thanks, James Frank Finner wrote: When do you commit these inserts? I occasionally found similiar problems, when I do heavy inserting/updating

Re: [GENERAL] postgresql /var fill

of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B

Re: [GENERAL] Shared Objects (Dynamic loading)

language to use while dealing with email parsing. We have the perl code ready to parse the email. Just wondering what would be the best method to deal with database (postgresql) calls from the perl code. Use DBD::Pg, available at CPAN. -- Frank Finner Invenius - Lösungen mit Linux

Re: [GENERAL] Strange error message

-- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651 pgpIipkeBc9SW.pgp Description: PGP signature

Re: [GENERAL] PostgreSQL and OpenVZ

subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http

Re: [GENERAL] casting... adding integer to timestamp

... Regards, -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651 pgpFDCN81x4Xm.pgp Description: PGP

Re: [GENERAL] 8.1.4: Installation ends up in endless recheck loops

On Sun, 04 Jun 2006 15:14:37 -0400 Tom Lane [EMAIL PROTECTED] thought long, then sat down and wrote: Frank Finner [EMAIL PROTECTED] writes: I run ./configure --with-perl --with-pam --with-openssl then gmake and end up in endless loops of cd . ./config.status --recheck so configure

[GENERAL] 8.1.4: Installation ends up in endless recheck loops

and CentOS) on other computers I got no problems at all. Any ideas? -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A

Re: [GENERAL] How to do a CREATE DATABASE and then connect to it?

. That__s equivalent to what \c does. It would sometimes really be nice, btw, if inter-database queries were possible. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key

Re: [GENERAL] Image in postgresql 7.3

: http://www.nabble.com/Image-in-postgresql-7.3-t944227.html#a2446227 Sent from the PostgreSQL - general forum at Nabble.com. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http

Re: [GENERAL] PITR problems

in ('DIR %PG_WAL_AREA% /AA /OD /B') do set lastfil=%%f ECHO. last file in directory is %lastfil% COPY /Y %PG_WAL_AREA%\%lastfil% %CUR_WAL_AREA% @endlocal -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax

Re: [GENERAL] Need input on postgres used for phpBB

database became extremely slow, vacuum itself needed several hours instead of several minutes, after doing some weeks of heavy inserting. Vaccum obviously does not release all unused memory in 7.3.x. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606

Re: [GENERAL] PL/Perl trusted throws error on example function

works fine now. Thanks for your help, it opened my eyes. Regards, Frank On Thu, 03 Mar 2005 12:14:53 -0500 Tom Lane [EMAIL PROTECTED] thought long, then sat down and wrote: Frank Finner [EMAIL PROTECTED] writes: error from Perl function: trusted Perl functions disabled - please upgrade

[GENERAL] PL/Perl trusted throws error on example function

untrusted, the example above works correctly. What is so bad with this function that I only can run it untrusted? Regards, Frank -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http

Re: [GENERAL] Upgrading PostgreSQL 7.1.3

for me rather smoothly from 7.1 to 7.3. -- Frank Finner Memory follows memory, memory defeats memory; some things are banished only into the realms of our rich imaginings - but this does not mean that they do not or cannot or will not exist - they exist! They exist! (M

Re: [GENERAL] Disappointing news

I really would like to know what they are going to do if somebodies´ MySQL-database crashes really hard (eg by CPU failure) and comes back with inconsistent state. Do they agree to be liable for that, because they certified it? Comparing MySQL with DB2 is IMHO quite funny. Like comparing pocket

Re: [GENERAL] performance very slow

Hi, shared_buffers seems quite low for a server to me. For best performance, you should read and follow the optimisation articles on http://techdocs.postgresql.org/. Regards, Frank On Wed, 26 May 2004 11:26:30 -0400 (VET) Mario Soto [EMAIL PROTECTED] sat down, thought long and then wrote:

Re: [GENERAL] Installation Postgresql

On Mon, 26 Apr 2004 10:22:36 -0700 Andrew Ayers [EMAIL PROTECTED] sat down, thought long and then wrote: Bill Moran wrote: Stephen Salbod wrote: My background is Windows and I just switched, yesterday to, Suse Linux Professional 9.0. And I have a class project due Monday, which is on

Re: [GENERAL] Installation Postgresql

On Tue, 27 Apr 2004 19:08:12 +0200 Frank Finner [EMAIL PROTECTED] sat down, thought long and then wrote: After having installed the SuSE shipped PostgreSQL packages, you simply have to start the database as root with rcpostgresql start. If the database is not initialized, the startup script

Re: win32 users list (Re: [GENERAL] Native Win32 port - PLEASE!)

On Sun, 28 Mar 2004 20:08:11 +0700 David Garamond [EMAIL PROTECTED] sat down, thought long and then wrote: I for one vote for win32 users having their own list as soon as possible. I predict three things: 1) there will be *lots* of them coming to -general (instead of to -novice); 2) there

Re: [GENERAL] Running multiple databases PG vs MySQL

On Sun, 28 Mar 2004 14:24:15 +0900 Alex [EMAIL PROTECTED] sat down, thought long and then wrote: Hi, what is the recommended way to run multiple databases under postgres. In MySQL it is rather simple to give different users or websites their own database with all the access rights. Any

Re: [GENERAL] Beginner Questions Please: Which To Go With ?

Hi, from my point of view (and according to my experiences) I wouldn´t recommend the use of MySQL between Access and PostgreSQL. It has a somewhat similiar, although subtle different language compared to PostgreSQL, and if one uses it, he will get used to that and going on to PostgreSQL will

Re: [GENERAL] pg_dump

Hi, surely you are right. I´m still using 7.2.3 as production database, so I have no experience with .pgpass. Where to put .pgpass if you use pg_dump from a PHP script and the database user is not a system user? Greetings, Frank Finner On Fri, 25 Jul 2003 17:17:26 -0400 Andrew Sullivan [EMAIL