Re: [ADMIN] postgres 7.2.1 and pam

2002-05-27 Thread Jameson C. Burt
On Sun, May 26, 2002 at 06:34:13PM +0200, Georg Lutz wrote: > Hi, > > i would like to use pam(ldap) to authenticate users. > > Unix-LDAP-Users already exists and they can login. > > I created a user via "CREATE USER user;" without a password, having a > valid unix-account in ldap. > > But when

[ADMIN] how to install postgresql!!

2002-05-27 Thread liutengjiao
now I have install postgreSQL7.2.tar.gz,but can't run it my step: 1 # ./confugure 2 # make 3 # make install (prompt succed!!) 4 #LD_LIBRARY_PATH=/usr/local/pgsql/lib # export LD_LIBRARY_PATH #/sbin/ldconfig /usr/local/pgsql/lib # MANPATH=/usr/local/pgsql/man:$MANPATH (abov

Re: [ADMIN] databases and RAID ...

2002-05-27 Thread Sander Steffann
> On Sun, May 26, 2002 at 08:00:50AM -0700, Bill Cunningham wrote: > > No Raid 10 is Raid 1 + 0 its strong points are faster writes but slower > > reads. > > RAID 10 reads will actually be faster than RAID 5, but it will require > more disks. (2n instead of n+1). There also seems to be a combinat

[ADMIN] postgres 7.2.1 and pam

2002-05-27 Thread Georg Lutz
Hi, i would like to use pam(ldap) to authenticate users. Unix-LDAP-Users already exists and they can login. I created a user via "CREATE USER user;" without a password, having a valid unix-account in ldap. But whenever I try to login to postgresql via psql -U user template1 i get "psql: FATAL

Re: [ADMIN] [pgadmin-support] Cache lookup error

2002-05-27 Thread Dave Page
> -Original Message- > From: Ramya Asokan [mailto:[EMAIL PROTECTED]] > Sent: 24 May 2002 21:01 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [pgadmin-support] Cache lookup error > > > Hi, > I created a function and a trigger - I then dropped them and > created the same funct

[ADMIN] error while compiling postgres with java option

2002-05-27 Thread Ravi K.R.
hi, problems faced during installation of postgreSQL on linux. 1. Ant java based build tools was successfully installed. 2. PostgreSQL7.2.1 version of the package was extracted and was tried to compile with java/jdbc support which gave error messages and was not compiled. $./configure --

[ADMIN] Cache lookup error

2002-05-27 Thread Ramya Asokan
Hi, I created a function and a trigger - I then dropped them and created the same function and trigger with a different name, but i keep getting the error : cache lookup failed. I don't know what this means, and would be very grateful if you can help me out. Thanks, Ramya -

[ADMIN] jdbc compile does not work

2002-05-27 Thread Ravi K.R.
JDBC compile did not work. problems faced during installation of postgreSQL7.2.1 version on linux during compilation with java/jdbc support which gave error messages and was not compiled. 1. Ant java based build tools was successfully installed and classpath was set. 2. to build the drive

Re: [ADMIN] How to rotate postgres logfiles

2002-05-27 Thread Rajesh Kumar Mallah.
Hi , This question has been asked before in the list by me. and below is an workable solution provided by Gaetano regds mallah. - Well, the most correct way to do a logrotate is ( Redhat ): 1) Put on your postgresql.conf the following lines: sys

[ADMIN] How to rotate postgres logfiles

2002-05-27 Thread Ferdinand Smit
Hi, Does anyone know how to flush the logfiles op postgres. I need it for logrotate. '/usr/lib/postgresql/bin/pg_ctl reload' does not work, it does not create a new logfile. Regards, Ferdinand ---(end of broadcast)--- TIP 6: Have you searched

Réf. : Re: [ADMIN] File systems backup problem

2002-05-27 Thread l . malaspina
For the moment the problem isn't resolv but i'm working on. I want to know. What is the files under the directory pg_xlog. Is this directory contains the logs for the systems transactions ? I ask this questions because when i restore the filesystem. When i firts restart the database. The postm