Re: [ADMIN] Error while loading external data into Postgres table

2003-06-07 Thread Robert Treat
Perhaps you can post the first 10 lines or so of your input file and the schema in which you are trying to import? Robert Treat On Mon, 2003-06-02 at 10:23, Bodanapu, Sravan wrote: > NO. I dont have any arrays in the table. > > - Sravan. > > -Original Message- > From: shreedhar [mailto

[ADMIN] unsubscribe

2003-06-07 Thread Kambiz Kermanizadeh
unsubscribe

[ADMIN] Compiling on HP-UX 11.11

2003-06-07 Thread David F. Skoll
Hi, I have a customer trying to compile PostgreSQL 7.3.1 on HP-UX with GCC, and he can't to it. He gets these configure errors: checking build system type... hppa2.0w-hp-hpux11.11 checking host system type... hppa2.0w-hp-hpux11.11 checking which template to use... hpux [...] checking sys/socket.

[ADMIN] Disk I/O Monitoring

2003-06-07 Thread Kris Kiger
Hi all, I'm looking for a good way to monitor disk I/O on a linux system. Specifically, I would like to know when postgres is making page-ins and page-outs. If anyone knows of a good utility, please let me know! Thank you for the help Kris ---(end of broadcast)

Re: [ADMIN] interpret vacuum verbose output

2003-06-07 Thread Shankar K
Thanks tom that was very useful. just wondering what could be "Keep 0, UnUsed 205434" refer here. does that any of it impact in evaluvating the vaccum frequecy. thanks, Shankar --- Tom Lane <[EMAIL PROTECTED]> wrote: > Shankar K <[EMAIL PROTECTED]> writes: > > I'm trying to evaluate the frequecy

[ADMIN] Help! Error when calling a function

2003-06-07 Thread Ben Schneider
I am receiving the following error when I call a simple function:   Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: fmgr_info: function 3036754: cache lookup failed . in /var/www/html/cmwareben/db_pgsql.php on line 93 Database error: Invalid SQL: SELECT note_num, fn_concat(rtr

Re: [ADMIN] Urgent: Restoring many schemas in a database

2003-06-07 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 June 2003 03:49, Stephen J. Thompson wrote: > Hello all, > > I am trying to restore a 7.3 database with many schemas and schema users in > it. The issue I am having is that there are many \connect statements in the > backup file and it k

Re: [ADMIN] Shared_buffers and kernel parameters, tuning

2003-06-07 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 June 2003 01:10, Lending, Rune wrote: > It is very difficult to test > the actual performance since there is a hugh difference in traffic on dev > and prod. I would resolve this problem as well. How can you know any of your changes won

Re: [ADMIN] No acceptable C compiler found

2003-06-07 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 June 2003 01:41, Marvin wrote: > When I issue the command ./configure when installing > POSTGRESQL I encounter the error > "configure: error: No acceptable C compiler found in > PATH " > Can someone advice me on what to do with this erro