[ADMIN] Oracle and PostgreSQL servers incompatibility

Hello everybody, We plan to install on a same Solaris server an Oracle8i and a PostgreSQL 7.3.4 database. During our impact tests, we encountered a situation where no more semaphore was available for Oracle server (while we where bulk loading on postgreSQL using copy statement. There was only one

[ADMIN] Server log parser

Hi,   I wondered if there's other server log parser than pgAnalyzer 2.0. My goal is to have a cron trying to match server log file content with a list of regular expressions. I wondered if it exists a ready-to-use list of regular expressions adapted to posgreSQL server log file content.   Tha

Re: [ADMIN] Java Applet + Postgre SQL

Hi, you should give access to postgresql jdbc driver (http://jdbc.postgresql.org) from your applet and afterwards look at http://doc.postgresintl.com/jdbc/index.html to find what you need. - Luc Jouneau Unité Centrale Informatique de Jouy, INRA Domaine de Vilvert 78352 Jouy en

Re: [ADMIN] Performance 7.3.4

Title: Performance 7.3.4 Hello,   try to understand differences in "Explain analyze your_query" in 7.2 compared to 7.3   Luc Jouneau - Original Message - From: Alessandro Meneguelli Coutinho To: [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 3:59 PM

Re: [ADMIN] Problem saving some characters

Hello, '\' is an escape character, you should double it when you insert data : insert into my_table values ('S:\\directory\\app'); I don't think it has much to do with database encoding. Luc Jouneau - Original Message - From: "Eduardo S. Fontanetti" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

[ADMIN] Seq scan with a like operator

Hi, I don't understand why with a like operator, PostgreSQL 7.4.2 does not behave the same as with an equal operator :   Here's a table with about 200.000 tuples : CREATE TABLE public.annu_pers2(  nom varchar(50),  prenom varchar(50),  nom_int varchar(50),   ) WITH OIDS; CREAT

Re: [ADMIN] Seq scan with a like operator

> LIKE requires a different kind of index. See > . Thanks for the answer peter, I didn't notice it when I red the doc, but if I create the index as specified then it is the query with equal operator which use a seq scan. Do I have to

Re: [ADMIN] please please please PLEASE help!

Hi, I don't want to offense you asking if you run vacuum full regullary. I suppose that the 10Gb are plain of usefull data, aren't they ? Luc - Original Message - From: "Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 23, 2004 8:10 AM Subject: [ADMIN] please please

Re: [ADMIN]

postgresql.conf ? Jouneau Luc ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [ADMIN] Adding multiple instances to 7.4

listening on different port (set PGDATA and PGPORT to distinct values before to launch each postmater). Jouneau Luc ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] can't remote access from client with ODBC

Hi,  did you asked the server to reload configuration files with a restart or a "pg_ctl reload" ? lj   - Original Message - From: Devi Munandar To: pgsql-admin@postgresql.org Sent: Tuesday, January 18, 2005 11:22 AM Subject: [ADMIN] can't remote access

[ADMIN] max_fsm_pages

Hi everybody,   I'm trying to understand how vacuumdb and free space map work together for retrieving free spaces after delete or update statements. max_fsm_pages and max_fsm_relations are set to default values (respectively 1 and 100). I do my tests on a table containing at the beginnin

Re: [ADMIN] Blob Data type in postgres ?

As far as I am concerned, I think that lobs are managed in postgres with oid.   Create your table like this : CREATE TABLE table_of_lobs ( title varchar(100), content_reference oid);   content_reference is a handler on lobs data contained in specials postgres system tables called Toast. Create

Re: [ADMIN] libpq problem

Did you set LD_LIBRARY_PATH to locate directory where libpq.so.3 can be found ? (Something like LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH) Luc Jouneau - Original Message - From: "Kris Kiger" <[EMAIL PROTECTED]> To: "Postgres Admin List" <[EMAIL PROTECTED]> Sent: Monday, September 22,