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

Re: [ADMIN]

? 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

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] 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

[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; CREATE

Re: [ADMIN] Seq scan with a like operator

LIKE requires a different kind of index. See http://www.postgresql.org/docs/7.4/static/indexes-opclass.html. 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] 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] 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

[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

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

[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_pagesand max_fsm_relations areset to default values (respectively 1 and 100). I do my tests on a table containing at the beginning