Re: [ADMIN] Statistics Collector not collecting server activities

2010-04-11 Thread Kevin Grittner
"Gnanakumar" wrote: > Does stats collector process need any other special > resource/privilege/operations/port to start? If I understand correctly, it uses UDP. I don't think PostgreSQL uses UDP outside of that. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To

Re: [ADMIN] initdb failure

2010-04-11 Thread Kevin Grittner
"Pankaj Mandal (pmandal)" wrote: > creating template1 database in > C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/base/1 > ... > initdb: could not execute command > ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/ > postgres.exe" --boot -x1 -F ": No error > initdb:

Re: [ADMIN] initdb failure

2010-04-11 Thread Jan-Peter Seifert
Hello, > The files belonging to this database system will be owned by > user "Administrator". > This user must also own the server process. the user here should be postgres. Are you 'locally'/'directly' installing on the server machine? Good luck. Peter -- Sent via pgsql-admin mai

Re: [ADMIN] initdb failure

2010-04-11 Thread Joseph Conway
Kevin Grittner wrote: > "Pankaj Mandal (pmandal)" wrote: > >> creating template1 database in >> C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/base/1 >> ... >> initdb: could not execute command >> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/ >> postgres.exe" --boot

Re: [ADMIN] initdb failure

2010-04-11 Thread Pankaj Mandal (pmandal)
Hi Peter, First I create the user postgres using the createuser.exe script. After that I run the following scripts from postgres installer in the order listed below. In between I do have checks to make sure the previous commands returned 0 exit code and that database server did start successfully

Re: [ADMIN] initdb failure

2010-04-11 Thread Pankaj Mandal (pmandal)
Hi Peter, The scripts are executed by user Administrator on this specific machine which has all the privileges that postgres user has (note postgres user account is also created) I also checked that the data directory and it contents are owned by user postgres and user postgres's permissions are i