Re: [ADMIN] grants

2005-09-05 Thread [EMAIL PROTECTED]
I ran into a problem while compiling PGSQL 8.0.3. I am on Solaris 10 (Sparc) running GCC 4.0. The problem is as follows: gmake[4]: Leaving directory `/opt/sft/postgresql-8.0.3/src/port' gmake[3]: Leaving directory `/opt/sft/postgresql-8.0.3/src/timezone' gcc -O3 -pthreads -Wall -Wmissing-protot

[ADMIN] Initdb error during silent install on windows 2000

2005-09-05 Thread Karim Mardhani
Hi All:   I am getting following error from initdb during silent installation of 8.0.1:   creating directory C:/Program Files/PostgreSQL/8.0/data/global ... initdb: could not create directory "C:/Program Files": File exists   I have searched about this issue and usually t

[ADMIN] Problems during linking of PGSQL 8.0.3

2005-09-05 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote: >I ran into a problem while compiling PGSQL 8.0.3. I am on Solaris 10 >(Sparc) running GCC 4.0. > >The problem is as follows: > > >gmake[4]: Leaving directory `/opt/sft/postgresql-8.0.3/src/port' >gmake[3]: Leaving directory `/opt/sft/postgresql-8.0.3/src/timezone' >gcc -

Re: [ADMIN] Initdb error during silent install on windows 2000

2005-09-05 Thread Karim Mardhani
One update on this problem.   I updated my install script to create a directory "md C:\pgdata" and update the command line for postgresql install to include "DATADIR=C:\pgdata" and everything works fine.   Maybe the space in "Program Files" is causing this problem?  But then

Re: [ADMIN] Initdb error during silent install on windows 2000

2005-09-05 Thread Magnus Hagander
> One update on this problem. > > I updated my install script to create a directory "md > C:\pgdata" and update the command line for postgresql install > to include "DATADIR=C:\pgdata" and everything works fine. > > Maybe the space in "Program Files" is causing t

[ADMIN] any clue?

2005-09-05 Thread Guido Barosio
Hi all,   Are the below lines related with a disrupted client connection and a bad backend behaviour? That's what  I think. I used to fetch these lines con pgadmin III connections.   Anyway, I have the idea of a bad hardware, well known here due to a DELL box hosting this postgres, but I would like

Re: [ADMIN] Initdb error during silent install on windows 2000

2005-09-05 Thread Karim Mardhani
No. There is no "C:\Program" directory on this machine. Thanks Karim - Original Message - From: "Magnus Hagander" <[EMAIL PROTECTED]> To: "Karim Mardhani" <[EMAIL PROTECTED]>; Sent: Monday, September 05, 2005 2:49 PM Subject: RE: [ADMIN] Initdb error during silent inst

[ADMIN] A good reference book for Postgresql administration

2005-09-05 Thread adey
Has anyone found the book "PostgreSQL Essential Reference" by Barry Stinson useful in administering Postgresql please? I'm looking for a comprehensive reference rather than a history or introduction to databases and SQL, and would like to know how suitable this book would be.   Your opinion would

Re: [ADMIN] A good reference book for Postgresql administration

2005-09-05 Thread Brian Choate
I just picked up the second edition of "PostgreSQL: the comprehensive guide to " by Douglas and Douglas.  It seems to be a really good reference so far. I am pretty new to PostgreSQL, but have a fair bit of experience with Oracle. I would recommend it to anyone looking for a fairly complete ref

Re: [ADMIN] any clue?

2005-09-05 Thread Peter Eisentraut
Guido Barosio wrote: > Are the below lines related with a disrupted client connection and a > bad backend behaviour? It looks like the client went away without telling the server (perhaps a crash). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of