Re: [ADMIN] PG 6.5 and src/interfaces/libpq++/Makefile.in

1999-07-07 Thread Bruce Momjian
> A few questions about src/interfaces/libpq++/Makefile.in: > 1. How about changing: > ifeq ($(CXX), g++) > CXXFLAGS= -Wno-error > else > CXXFLAGS= > endif > to > ifeq ($(CXX), g++) > C

[ADMIN] growing table size

1999-07-07 Thread Richard Krenek
I have hopefully a simple question. When doing updates on a table, specifically switching boolean values, the table continually grows in size although I'm only switching booleans from false to true. I can get the space back by doing the VACUUM command but since our table is very large that is not

Re: [ADMIN] problem with Pg 6.4 and RH 5.0

1999-07-07 Thread Bruce Momjian
> On Wed, 7 Jul 1999, Bruce Momjian wrote: > [snip] > > Can you suggesyt me a good version of stl? > Ah, I've make a wrong: postgres 6.5 not 6.4 No, I got bit by that too, but found there was already an stl on in my BSD/OS. Seems they have to match. I could not find older versions. -- Bruc

[ADMIN] Authentication via PAM or NIS

1999-07-07 Thread Peter Eisentraut
Does anyone know of any patches/utilities/magic to make PostgreSQL (6.5) use either PAM for authentication, or, if that doesn't work, is somehow NIS aware when the supplied password file ends with the usual +: ? (Or, as a rather clumsy solution, can I pipe the output of ypcat as the password "

Re: [ADMIN] problem with Pg 6.4 and RH 5.0

1999-07-07 Thread ZioBudda
On Wed, 7 Jul 1999, Bruce Momjian wrote: [snip] Can you suggesyt me a good version of stl? Ah, I've make a wrong: postgres 6.5 not 6.4 -- Michel Morelli [EMAIL PROTECTED] http://ziobudda.enter.it Italian Linux FAQ http://z

Re: [ADMIN] problem with Pg 6.4 and RH 5.0

1999-07-07 Thread Bruce Momjian
> make[2]: Entering directory > `/home/michel/postgresql-6.5/src/interfaces/libpq++' > c++ -I../../backend -I../../include -I../../interfaces/libpq > -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes -fpic > -c pgconnection.cc -o pgconnection.o > In file included from /usr/include/

Re: [ADMIN] Blew away postgres user -- now can't connect

1999-07-07 Thread Bruce Momjian
> Hi all > > Bruce Momjian wrote: > > > > > I had two identical postgres users in my pg_users table. (Why does that > > > keep occurring? I also had to versions of each table I made.) > > > > I would love to know how that happens. It is pg_dumpall causing it? > > Please try to find out. > > Y

[ADMIN] PG 6.5 and src/interfaces/libpq++/Makefile.in

1999-07-07 Thread pgsql-admin
A few questions about src/interfaces/libpq++/Makefile.in: 1. How about changing: ifeq ($(CXX), g++) CXXFLAGS= -Wno-error else CXXFLAGS= endif to ifeq ($(CXX), g++) CXX

[ADMIN] problem with Pg 6.4 and RH 5.0

1999-07-07 Thread ZioBudda
Hi, I have a RH 5.0 distribution where I have upgrade some packet (glibc-2.0.7, libstdc++-2.8.0-14). Now I want to install ostgres 6.5, but when I'm going to compile it, "make" return me this error (only a part): make[2]: Entering directory `/home/michel/postgresql-6.5/src/interfaces/libpq++' c++

Re: [ADMIN] Blew away postgres user -- now can't connect

1999-07-07 Thread Peter Eisentraut
On Tue, 6 Jul 1999, Bruce Momjian wrote: > > I had two identical postgres users in my pg_users table. (Why does that > > keep occurring? I also had to versions of each table I made.) > > I would love to know how that happens. It is pg_dumpall causing it? > Please try to find out. I couldn't re

Re: [ADMIN] Blew away postgres user -- now can't connect

1999-07-07 Thread Terry Mackintosh
Hi all Bruce Momjian wrote: > > > I had two identical postgres users in my pg_users table. (Why does that > > keep occurring? I also had to versions of each table I made.) > > I would love to know how that happens. It is pg_dumpall causing it? > Please try to find out. Ya, this is now the 4th

[ADMIN] FW: BOUNCE pgsql-admin@postgreSQL.org: Non-member submission

1999-07-07 Thread sk . list
Hi! On 07-Jul-99 Vadim Mikheev wrote: >> I found a strange hunging of postgres 6.5. >> In a few days working child process dumped to core but postmaster was runned >> it > > What does gdb say about this core? Core was generated by `/usr/comset/dbase/bin/postmaster -i -D/usr/comset/dbase/data'.

Re: [ADMIN] 6.5 hung

1999-07-07 Thread Vadim Mikheev
[EMAIL PROTECTED] wrote: > > Hi! > > I found a strange hunging of postgres 6.5. > In a few days working child process dumped to core but postmaster was runned it What does gdb say about this core? Vadim

[ADMIN] Postgres 6.5 on Alpha.

1999-07-07 Thread Mattias Norlander
Hi, We've compiled and installed postgres v6.5 on an Alpha computer running Debian Linux 2.2.9. Everything seemed to work fine, but... *Trying to select oid:s from non-empty tables causes the backend to go down. also * trying to destroy a database using 'destroydb' (or drop database) yields: