[ADMIN] runing Postgresql on shared disk

2004-12-10 Thread Nageshwar Rao
Hi, Can anybody let me know how to configure postgresql on shared disk? I want postgresql on two systems accessing same disk for data(disk arrays). Our aim is to provide HA DB.  

[ADMIN] correspondence between the numbered folder and actual database

2004-12-10 Thread Chuming Chen
Hi, all, Is there any way I can find the correspondence between the numbered folders under postgresql data/base and the actual database name or table name? Thank you for your suggestions. -- Chuming Chen System Administrator NHLBI Proteomics Center Medical University of South Carolina 135 Canno

Re: [ADMIN] Running sql files

2004-12-10 Thread Pradeepkumar, Pyatalo (IE10)
Hi all, Thanks a lot for all your valuable inputs. I tried "\set QUIET" and "\unset QUIET" arount certain parts of the file. It works fine with INSERT COMMANDS. But incase of creating tables, it still prints NOTICE and ERROR messages on the screen...how do I restrict that. Regs, Pradeep

[ADMIN] Login with blank password

2004-12-10 Thread rray
Is there a setting in postgresql.conf that will log the password that's used to login with? If I add "hostall user172.17.32.0 255.255.255.0 password" to pg_hba.conf the user can login with a blank password. If I add "hostall user172.17.32.1

[ADMIN] Issue with large objects

2004-12-10 Thread Chris White (cjwhite)
I am putting a large object into my database using jdbc interface and using LargeObjectManager to do largeobject open, write and close. After several largeobject writes I get the following message   'failed to re-find parent-key in "pg_largeobject_loid_pn_index"'   What does this mean and h

Re: [ADMIN] Running sql files

2004-12-10 Thread Michael Fuhr
On Tue, Dec 07, 2004 at 04:55:24AM -0700, Pradeepkumar, Pyatalo (IE10) wrote: > $psql dbname < sqlfile > The results of the command are displayed on to the screen. In one file I am > trying to populate a table with values ( There are more than 5000 tuples to > be inserted). > When I run this comm

Re: [ADMIN] Running sql files

2004-12-10 Thread Michael Fuhr
On Tue, Dec 07, 2004 at 10:23:44PM -0700, Pradeepkumar, Pyatalo (IE10) wrote: > Thanks a lot for all your valuable inputs. I tried "\set QUIET" and "\unset > QUIET" arount certain parts of the file. It works fine with INSERT COMMANDS. > But incase of creating tables, it still prints NOTICE and ERR

[ADMIN] postgresql 7.4.1 SRPM

2004-12-10 Thread FM
I'm using RPM from postgresql site (v 7.4.1). I need to add krb5 auth so I need to recompile SRPMS. I cannot find it in the source tree. Is there a place where we can find the SRPM ? thanks, ---(end of broadcast)--- TIP 9: the planner will ignore yo

[ADMIN] Connections

2004-12-10 Thread Pascal Tufenkji
Hi, I'm using PostgreSQL 7.3.2 Is there a way to know if there are users connecting to my database (either via the web or telnet or whatever...) I need that for in case I want to shut down the server, I want to know first if there are users still connecting to the database before shutting it

Re: [ADMIN] Running sql files

2004-12-10 Thread Jaime Casanova
--- "Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> escribió: > > Hi, > > I just wanted to know how to disable the results > being displayed on the > screen. > When I try the following command - > $psql dbname < sqlfile > The results of the command are displayed on to the > screen. In one

[ADMIN] pgcrypto module for WINDOWS

2004-12-10 Thread Mª José Sempere
Hello, We are interested in installing the pgcrypto module of PostgreSQL for Windows, In order to use the function digest() for creating index on bytea type fields: create unique index my_index on my_table (digest(my_bytea_field, 'md5')); HOW CAN WE INSTALL THE PGCRYPTO MODULE FOR WINDOWS? DO

[ADMIN] vacuum analyze takes long time

2004-12-10 Thread Hemapriya
Hi, I have updated 10M rows in a table. i ran the vacuum analyze. it has been running more than a day. I'm not sure whether it would take so long? total volume in the table - 16M rows Can anyone please confirm... thanks Priya __ Do you

Re: [ADMIN] pgcrypto module for WINDOWS

2004-12-10 Thread Joe Conway
Mª José Sempere wrote: We are interested in installing the pgcrypto module of PostgreSQL for Windows, In order to use the function digest() for creating index on bytea type fields: create unique index my_index on my_table (digest(my_bytea_field, 'md5')); Um, why would you want to use digest() jus

[ADMIN] statistics buffer is full

2004-12-10 Thread Bjoern Metzdorf
Hi, just wanted to share some experience with the curious log message: "statistics buffer is full". Some time ago we suffered from bad performance on our database server. We were running 7.4.x. I saw this strange log message and Tom told me a way to raise this specific buffer. After raising it

Re: [ADMIN] Running sql files

2004-12-10 Thread John DeSoi
On Dec 7, 2004, at 6:55 AM, Pradeepkumar, Pyatalo (IE10) wrote: I just wanted to know how to disable the results being displayed on the screen. When I try the following command - $psql dbname < sqlfile The results of  the command are displayed on to the screen. In one file I am trying to populate

Re: [ADMIN] fallback authentication

2004-12-10 Thread Ron Peterson
On Fri, Dec 10, 2004 at 03:20:50PM -0500, Ron Peterson wrote: > Sometimes, however, I would like to create an account in PostgreSQL > which I do not want to also maintain in LDAP. Is it possible to > configure authentication to fall through to a different method? I suppose the right thing to do