Re: [ADMIN] Create index problem ( _bt_sort )

you think about this : when i have add some rows , the index creation become possible . It's strange , isn't it ? I don't remove any row . I work on a debien and i like the system package so, for the 7.1beta4, i will try if i'm forced . Thanks , soory for my english -- Loïc TREGOUËT

[ADMIN] Create index problem ( _bt_sort )

eate index user2000 on log2000(username); CREATE raslog=# -- Loïc TREGOUËT

Re: [ADMIN] ssh problem ?

Any idea ? thanks Loic Peter Eisentraut wrote: > > Loïc TREGOUËT writes: > > > The following is ok : > > $ psql -h localhost -U postgres > > $ psql -h 127.0.0.1 -U postgres > > > > but this don't work : > > $

[ADMIN] ERROR: ORDER BY is not allowed in INSERT/SELECT

Hie, Why the folowing is not accepted on PostgreSQL 7.0 but accepted on PostgreSQL 6.5.3 ? insert into tempo select id, name from topics order by name; ERROR: ORDER BY is not allowed in INSERT/SELECT Thanks

[ADMIN] ssh problem ?

Hello , The following is ok : $ psql -h localhost -U postgres $ psql -h 127.0.0.1 -U postgres but this don't work : $ psql -U postgres psql: connectDBStart() -- connect() failed: Connection refused Is the postmaster running at 'localhost' and

[ADMIN] security , multiple interface

Hello , I've on my server 3 interfaces : - lo (127.0.0.1) -eth0 ( xxx.xxx.xxx.xxx) - eth0:1 (alias 192.168.xxx.xxx) Is it possible to listen (bind ?) only lo and eth0:1 and not eth0 for PostgreSQL? ( with a PostgreSQL configuration) I'm french , i hope

[ADMIN] system tables and indexes problem

Re , I hope someone will help me ... I've a big problem with a database . When i try a vacuum : NOTICE: Vacuum: can not process index and certain system tables and i have to kill the process because i take all the cpu .. When i try to access system tables : - the select

[ADMIN] problem with table system

When i try the command \dt or when i try to extract directly from the system tables , i've the following error docserv=> \dt pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the req

[ADMIN] speed Postgresql 7.0 vs PostgreSQL 6.5.2

Hie , I've just install PostgreSQL 7.0.2 on i686-pc-linux-gnu (Pentium 233 with 64 Mo RAM) But i've also PostgreSQL 6.5.2 " " (P 450 with 256 Mo RAM) I've dump one of my big database (50 rows) on the new one . I've made some test and one of

[ADMIN] smp , php and postmaster distant

Hie , I have put a database on a 2 processors db server . (2 * PII 450 Mhz with 512 Mo RAM) This server is distant from the web server . I've a php3 interface and , i've seen some big loose of performance . The request are longer when i use the bi-processor . Is it due to

[ADMIN] Database replication ?

Hello , I was talking about PostgreSQL with one of my friend who use SQL Server . He ask me what about replication database in Postgresql . Is there a way to do this : - when a row is inserted (or deleted ...) in database1 - > automatically the same operation is replicated on a other dat

[ADMIN] view performance

Hello , I use a database to store log files . I have 2 Million rows by year . I want the maximum of performance when i access them from my web site so i've started to make one table by year : log2000 : contain all the log information of the year 2000 log 1999 : .. I think now it's a bad idea

[ADMIN] multi processor

Hello , Maybe my question is stupid but , i can't test it . Is Postgresql , can use more than one processor for one request or is depend of something else ? thanks P.S:If someone give me a multi-processor computer , i could make the test and you will not have to reply to me

[ADMIN] debian cron.d and security

Hello , I have the following problem : - I use postgresql 6.5.3 on a debian - >i want the maximun of security for my database ->so , i use a flat file for identification by password (is it the maximum ?) : local password passwd ->but the cr

Re: [ADMIN] pgaccess use wrong password

Bruce Momjian wrote: > >Excuse me for the latest message , i've found the solution > > > > localallpasswordpasswdfile > > > > Now , passwords are stored (and crypted) in passwdfile . > > The authentication with psql is ok > > > > But pgaccess still use the password in clear in

[ADMIN] pgaccess use wrong password

   Excuse me for the latest message , i've found the solution local    all    password    passwdfile Now , passwords are stored (and crypted) in passwdfile . The authentication with psql is ok But pgaccess still use the password in clear in pg_shadow . Is there an option , i've not set correc

[ADMIN] Password crypted storage utilisation

    Hie , hope someone can help me       I 'm trying to secure my database so i would like to use crypted password for authentification. But if i do this with pg_hba.conf like : local  all    crypt passwords are still stored in clear ! I don't wan't that superu

[ADMIN] select distinct inet bug

    Hie all ,     I've already post a similar messages but i don't see it into the mailing list so ... Look at the following : test=> create table ip_table (addr inet); CREATE test=> insert into ip_table values ('10.10.10.10'); INSERT 1403913 1 test=> insert in

[ADMIN] inet type , select distinct troubles

    Hie all ,       I've a big database ( 2M rows ) and i use the inet type for ip address .     for example :     test=>create table ip_table (i int4 , addr inet );     CREATE     The i do a lot of inserts in my database , with Perl/DBI . (Note i use AutoCommit=off for performance) :     tes

[ADMIN] how to manipulate object ?

Hello I try to create table with object . example : create table myObject( info text , locint4); create table test ( id int4, obj myObject); So , now

[ADMIN] oreilly

To everybody and anyone else , Is anybody know if a oreilly book about Postgresqlis on writing ? I find nothing on the site oreilly.com but i've heard this information . Thanks , Have a good day

[ADMIN] array ...

Hie, Is there any possibility to know the number of record in an array into a table . Example : create table test ( id int4, array int4[] ); How can i know , how many record i have in array ? (PHP , SQL ) Thanks

[ADMIN] Postquel?

Hie Postquel ? Is it an extended request language ? Is it use by PostgreSQL ? Thanks ...

[ADMIN] This Object side of postgresql

Hello I'm french ( you may already note it !) I would like to have some light on the aspect Object of pgsql . When we talk about about a object base , it's just because we can specify a oid in a field or can we put directly a row of a t

[ADMIN] This Object side of postgresql

Hello I'm french ( you may already note it !) I would like to have some light on the aspect Object of pgsql . If i make a table called table1 (with some field ) . I can create an other table called table2 with a field who have the