Re: [GENERAL] Libpq Asynchronous Command Processing

>So PQexec works fine for you on both 7.4 and 8.3, producing a quick >result no matter which server you run it against? Yes. If I use PQexec, both 7.4 and 8.3 produce a quick result but I if I use asynchronous command processing 8.3 produce a slow result whereas 7.4 works fine. >Consider using

Re: [GENERAL] Libpq Asynchronous Command Processing

>> With that analysis, I'd be betting against it being a client problem. >> (If you wanted, you might confirm that by pointing an old client at >> the new server.) >> >> I'd look into how the data was loaded into the new server and how >> the database is configured: number of buffers, indexes, and

[GENERAL] Libpq Asynchronous Command Processing

Hello, I am migrating a client/server application from Debian Sarge to Debian 5.0 and I am finding problems with the client application. The facts are the following: ->The client application is an interface to a Postgresql DB so it uses libpq. ->The client application compiles properly in both Deb

[GENERAL] database still hanging

What would cause psql to hang indefinitely when the backend disappears? We have a script that uses psql to insert a record (TCP connection to DB on different machine). The command is basically psql -c "insert into..." A while back I had to restart the server and today discovered that some

[GENERAL] Migrate Postgres 7.2 to Postgres 8.1

Hi all   All people have advised me that I should migrate my database Postgres 7.2.2   PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 ( Red Hat Linux 8.0 3.2-7)   to new version 8.1.4.   I have downloaded postgresql-8.1.4-1PGDG.i686.rpm postgresql-co

Re: [GENERAL] Adding Functionality

eb 18, 2004 at 11:49:39AM -0500, Fernando Alonso Renault wrote: > Hello, > > i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i > add new funtionality? I mean, i wanna add a couple of new functions, and i've found > this files, pg_proc.h a

[GENERAL] Adding Functionality

Hello, i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i add new funtionality? I mean, i wanna add a couple of new functions, and i've found this files, pg_proc.h and fmgrtab.c, but i don't know the meaning of the fields, so i can't add anything. For instance,

[GENERAL] Backward migration

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I must migrate a PostgreSQL database that I've created initially with PostgreSQL 7.0 over LiNUX to a system that has PostgreSQL 6.5.3 running on a FreeBSD. I've no chance to update de PostgreSQL engine to a newer version so the only way