Re: [ADMIN] PREPARE/EXECUTE questions... custom functions?

Joshua D. Drake wrote: Use a connection pooler like pgpool. Thanks for the suggestion, I will look into it and test. There seems to some overhead using that tool. What about custom functions, written in SQL or C? They seem to work until the database is shut down, any thoughts about that for a c

Re: [ADMIN] postmaster stopps

Tom Lane wrote: When you've got some evidence to look at, we'll be glad to help you interpret it, but there's no point in speculating without evidence. Thanks Tom, My original post stated I'd had the postmaster stop without explanation. I now have log files. I can see nothing in messaegs or sys

[ADMIN] plperl won't load on Win2k3

Hello All, I'd like to know what I am doing wrong. I've installed the 7.5 win32 version of Postgres (love it...). I've entered the bin directory and loaded the plpgsql language on my database (works fine)... I have perl 5.6.1 installed as well and would like to load the plperl language on the

[ADMIN] PGDATA problem

I just installed postgresql on my gentoo box. everything works fine when i use the default data directory '/var/lib/postgresql/data' but the problem is i do not want my data stored there. so i created a new directory owned by postgres '/home/postgresql/data' and ran $initdb -D /home/postgresql/data

Re: [ADMIN] postmaster -i option...

"Taber, Mark" <[EMAIL PROTECTED]> writes: > I restarted our dev postgres instance today with the -i option, and now, > using 'ps,', I am not able to see connections to the database any longer. > The production instance (running only with the -D option) shows the > connections. Am I going crazy, mi

[ADMIN] postmaster -i option...

I restarted our dev postgres instance today with the -i option, and now, using 'ps,', I am not able to see connections to the database any longer. The production instance (running only with the -D option) shows the connections. Am I going crazy, missing something obvious? I'm using the command 'p

[ADMIN] unsubscribe

Title: Mensaje unsubscribe

Re: [ADMIN] PREPARE/EXECUTE questions

Postgres User wrote: I'm writing a web application inwhich clients will login/out among other stuff. I have be reading on prepared statements and leave you all with an open-ended question. Are prepared statements better and how can I program them to not end at the once the session is over? Use

Re: [ADMIN] insert a file into remote database

On Mon, Oct 18, 2004 at 15:37:48 -0400, Chuming Chen <[EMAIL PROTECTED]> wrote: > Hi, all, > > Is there anyway to insert a local text file into a table in a remote > database server? Perhaps psql's \copy command will do what you want. ---(end of broadcast)-

[ADMIN] PREPARE/EXECUTE questions

I'm writing a web application inwhich clients will login/out among other stuff. I have be reading on prepared statements and leave you all with an open-ended question. Are prepared statements better and how can I program them to not end at the once the session is over? Thanks, any other sugges

[ADMIN] insert a file into remote database

Hi, all, Is there anyway to insert a local text file into a table in a remote database server? Thanks, -- Chuming Chen System Administrator & Programmer Department of Biostatistics, Bioinformatics and Epidemiology Medical University of South Carolina 135 Cannon Street, Suite 303 Charleston SC 294

Re: [ADMIN] Relations summary at end of vacuum

Doug Y <[EMAIL PROTECTED]> writes: > What exactly are the "Relations" that are referred to in the summary > at the end of a vacuum? Tables and indexes. > I have two DBs that are supposed to be mirrored copies of each other, > but my relation & page counts are different for each after a vacuum

[ADMIN] Relations summary at end of vacuum

Hi, What exactly are the "Relations" that are referred to in the summary at the end of a vacuum? I have two DBs that are supposed to be mirrored copies of each other, but my relation & page counts are different for each after a vacuum: DB_a: INFO: free space map: 109 relations, 70413 pages st

Re: [ADMIN] large dumps won't restore

When using pg_dump + psql: I get a similar error. In one table that has about 5.4 million rows, the dump has several incomplete rows in the large block of copy data. It seems to attempt to fill the copy with data from the *next* line. ERROR: invalid input syntax for type timestamp: "4" CONTEXT

[ADMIN] large dumps won't restore

I'm running a large database ( data dir is ~9gigs ) on Fedora Core 2 with 7.4.5-PGDG rpm's When using the -Fc dump method + pg_restore, I get: -bash-2.05b$ pg_restore -Fc -d foo -L backup.list /tmp/02\:43-postgresql_database-foo-backup pg_restore: ERROR: invalid input syntax for type timestamp: