[ADMIN] DB error recovery

2004-07-07 Thread Werner Bohl
Hi, We have a big postgresql 7.4.2 db on RedHat 8.0. Data resides in a SCSI RAID partition. Problem: SCSI RAID card (LSI 160 Express) was substituted with a LSI 1600 Enterprise. Same make, using same low-level drivers. After the card switch a query to one of our tables returns: ERROR: could not

Re: [ADMIN] [PERFORM] finding a max value

2004-07-07 Thread Rosser Schwarz
On Fri, 02 Jul 2004 20:50:26 +0200, Edoardo Ceccarelli <[EMAIL PROTECTED]> wrote: > This is the query: > select max(KA) from annuncio > wasn't supposed to do an index scan? it takes about 1sec to get the result. > TIP 5: Have you checked our extensive FAQ? I believe this is a FAQ. See: http://

Re: [ADMIN] Problems upgrading to 7.4

2004-07-07 Thread Michael Adler
On Wed, Jul 07, 2004 at 04:28:53PM +0100, Hilary Forbes wrote: > > ... when I run pg_dump to restore the data, one table with approx > 5.5 million records gives me > > ERROR: invalid memory alloc request size 1073741824 What do you mean "pg_dump to restore the data"? One would normally use psql

Re: [ADMIN] pg_xlog

2004-07-07 Thread Scott Marlowe
On Wed, 2004-07-07 at 04:31, [EMAIL PROTECTED] wrote: > Hi, > > Could you please send me an advice how to configure Postgres database > > With non standard pg_xlog directory location i.e. on other (non db) > physical disk ??? Easy: su - postgres pg_ctl stop cd $PGDATA mkdir /mnt/drive2/pg_xlog

[ADMIN] Problems upgrading to 7.4

2004-07-07 Thread Hilary Forbes
I have a 7.1.3 instance of postgres running on one machine and want to move the database from that machine to a new machine running 7.4.1. We've installed 7.4.1 and I have successfully run pg_dump on the 7.1.3 machine and transferred the file over. However when I run pg_dump to restore the dat

Re: [ADMIN] is there app to catalog email oe6

2004-07-07 Thread Michelle Konzack
Am 2004-07-06 23:30:46, schrieb Paul Gimpelj: >Hi >I am hoping posgresql will get more widely used. ??? >I have an idea for an application. Nice... >Consider , after spending months collecting email with information for >research there becomes the need to catalog it >and store it efficiently. A

[ADMIN] pam authentification trouble ...

2004-07-07 Thread Hervé Piedvache
Dear all, I have a trouble with the pam authentification for PostgreSQL. I have add in the pg_hba.conf the good line ... and I have create a /etc/pam.d/postresql file which contains : auth        required    pam_unix.so nullok_secure account     required    pam_unix.so Now like this ... imposs

Re: [ADMIN] Source RPMS

2004-07-07 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 7 Jul 2004, Donald Fraser wrote: > I attempted to build the RPMS from the source package (7.4.3-2) for Redhat 9 and got > the following errors. > > [EMAIL PROTECTED] SRPMS]# rpmbuild --rebuild --define 'build9 1' --define 'test 0' > -

[ADMIN] Source RPMS

2004-07-07 Thread Donald Fraser
  I attempted to build the RPMS from the source package (7.4.3-2) for Redhat 9 and got the following errors.   [EMAIL PROTECTED] SRPMS]# rpmbuild --rebuild --define 'build9 1' --define 'test 0' --define 'python 0' postgresql-7.4.3-2PGDG.src.rpm Installing postgresql-7.4.3-2PGDG.src.rpmerror:

Re: [ADMIN] pg_xlog

2004-07-07 Thread Sam Barnett-Cormack
On Wed, 7 Jul 2004 [EMAIL PROTECTED] wrote: > Hi, > > Could you please send me an advice how to configure Postgres database > > With non standard pg_xlog directory location i.e. on other (non db) physical > disk ??? One word: symlinks. -- Sam Barnett-Cormack Software Developer

[ADMIN] pg_xlog

2004-07-07 Thread Leszek . Dukwicz
Hi, Could you please send me an advice  how to configure Postgres database With non standard pg_xlog directory location i.e. on other (non db) physical disk ???   Leszek Dukwicz