Re: [ADMIN] Compiling problems with 7.4.2

2004-05-28 Thread Jim Seymour
I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as follows. Thanks SunOS 5.8 Generic_108528-29 sun4u sparc SUNW,Ultra-1 [snip] gcc -O3 -pthreads -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declaration s -fPIC -I. -I../../../src/include

Re: [ADMIN] pg_hba.conf

2004-05-28 Thread LSanchez
Jim said: Try changing the 10.29.15.0255.255.255.0 to 10.29.15.0/24, if you have a 7.4-series pgsql server, and see if that doesn't work. IT WORKED! Thanks so much Jim! I'm happily connected from home today... :) -Original Message- From: Sanchez, Lily Sent: Thursday, May 27,

[ADMIN] how do i log events for postgresql 7.0.3

2004-05-28 Thread Shivaprasad Pavoor
hi all, i have RH7.1 box with postgres 7.0.3. i searched the internet for above mentioned subject in vain. now i'm totally confused about postgres.conf (i'm not able to find in my installation) and pg_options. cud anybody let me know how do i setup logging of postgres. thanks in advance.

Re: [ADMIN] tcpip_socket=false and psql is working?

2004-05-28 Thread Andrew Sullivan
On Thu, May 20, 2004 at 09:00:34PM +0200, [EMAIL PROTECTED] wrote: Hi all, I have compiled 7.4.1 on Debian Woody and found psql is working even if tcpip_socket is set to false in postgresql.conf Working on the same box? It's probably using UNIX domain sockets. Try psql -h 127.0.0.1; if

Re: [ADMIN] how do i log events for postgresql 7.0.3

2004-05-28 Thread Peter Eisentraut
Shivaprasad Pavoor wrote: i have RH7.1 box with postgres 7.0.3. i searched the internet for above mentioned subject in vain. now i'm totally confused about postgres.conf (i'm not able to find in my installation) and pg_options. cud anybody let me know how do i setup logging of postgres.

Re: [ADMIN] pg_hba.conf

2004-05-28 Thread Jim Seymour
[EMAIL PROTECTED] wrote: Jim said: Try changing the 10.29.15.0255.255.255.0 to 10.29.15.0/24, if you have a 7.4-series pgsql server, and see if that doesn't work. IT WORKED! Thanks so much Jim! I'm happily connected from home today... :) It was a long shot, but it worked. Very

[ADMIN] postgresql, xfs and lvm

2004-05-28 Thread Tom Jenkins
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I read with great interest the archived postings about the use XFS over LVM and snapshotting the PGDATA dirs for backups. However I saw on XFS's mailing list on May 13th that Murthy said that they now don't use that procedure and instead

[ADMIN] ppp link activated on startup

2004-05-28 Thread tatel
Hi, I'm using debian woody with ppp-on-demand, which worked fine. But after compile-install postgresql 7.4.1 with postgis, ppp link is activated on startup, which is very unpleasant. In postgresql.conf tcpip_socket is set to false. I'm shure this is a postgresql affair, since removing

[ADMIN] Postgresql lib and include files for SuSE 9.0 RPMS?

2004-05-28 Thread Tamer
Hi! I want to compile my Jabber Server and connect it with the latest PostgreSQL Server. I installed all packages from the mirror server available for SuSE Linux 9.0 but the ./configure script tell me, that it can't locate the libraries and headres. Any ideas to solve my problems? Tamer --

Re: [ADMIN] postmaster terminated abnormally..

2004-05-28 Thread Gaetano Mendola
[EMAIL PROTECTED] wrote: Hi, Under what circumstances would the postmaster receive signal 11 my postgres server crashed today and analysis of log yeilded sig 11 is SIGSEGV . Any idea on how it prevent it? Are you running your own functions written in C ? Regards Gaetano Mendola

Re: [ADMIN] ppp link activated on startup

2004-05-28 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear tatel, But after compile-install postgresql 7.4.1 with postgis, ppp link is activated on startup, which is very unpleasant. In postgresql.conf tcpip_socket is set to false. I'm shure this is a postgresql affair, since removing postgresql rc scripts corrects this problem. But no more