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 -I/

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, Ma

[ADMIN] postmaster terminated abnormally..

2004-05-28 Thread mallah
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? Regds rmallah. LOG: server process (PID 19852) was terminated by signal 11 LOG: terminating any other active

[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. Shiv

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,

[ADMIN] plz help me

2004-05-28 Thread irfan afzal
hi I have installed the cygwin and cyqIPC softwares. now i want to Initialize the Database, but it becomes fails, please help me, what should i do. I have paste my command and its result: please read it and tell me, what should i do. $ initdb -D /usr/share/postgresql/data The files belonging to

[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 rsy

[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 postgresql

[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 -- Jabb

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 postmaster