initdb failure

initdb failure

am 09.04.2010 02:28:40 von pmandal

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAD77B.9C364072
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All

=20

I have been trying to install PostgreSQL-8.4 on Windows 2000 server and
keep getting the following

=20

=20

creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ...
initdb: could not execute command
""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/p ostgres.exe"
--boot -x1 -F ": No error

initdb: removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"

=20

I have checked the archives but did not see any solution so far.

The data directory does have inheritable permissions for user postgres
to read, write, modify etc.=20

=20

=20

Thanks

Pankaj


------_=_NextPart_001_01CAD77B.9C364072
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">









Hi All



 



I have been trying to install PostgreSQL-8.4 on =
Windows 2000
server and keep getting the following



 



 



creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ... =
initdb:
could not execute command
"" C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/pos t=
gres.exe"
--boot -x1 -F ": No error



class=3DMsoNormal>         &=
nbsp;      initdb:
removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data" >



 



I have checked the archives but did not see any =
solution so
far.



The data directory does have inheritable =
permissions for
user postgres to read, write, modify etc.



 



 



Thanks



Pankaj









------_=_NextPart_001_01CAD77B.9C364072--

Re: initdb failure

am 09.04.2010 07:40:50 von pmandal

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAD7A7.3727F37A
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All

=20

I have been trying to install PostgreSQL-8.4 on Windows 2000 server and
keep getting the following

=20

=20

creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ...
initdb: could not execute command
""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/p ostgres.exe"
--boot -x1 -F ": No error

initdb: removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"

=20

I have checked the archives but did not see any solution so far.

The data directory does have inheritable permissions for user postgres
to read, write, modify etc.=20

=20

=20

Thanks

Pankaj


------_=_NextPart_001_01CAD7A7.3727F37A
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">









Hi All



 



I have been trying to install PostgreSQL-8.4 on =
Windows 2000
server and keep getting the following



 



 



creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ... =
initdb:
could not execute command =
"" C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/pos t=
gres.exe"
--boot -x1 -F ": No error



class=3DMsoNormal>         &=
nbsp;     
initdb: removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data" >



 



I have checked the archives but did not see any =
solution so
far.



The data directory does have inheritable =
permissions for
user postgres to read, write, modify etc.



 



 



Thanks



Pankaj









------_=_NextPart_001_01CAD7A7.3727F37A--

Re: initdb failure

am 09.04.2010 09:01:08 von Jaime Casanova

On Thu, Apr 8, 2010 at 7:28 PM, Pankaj Mandal (pmandal)
wrote:
> Hi All
>
>
>
> I have been trying to install PostgreSQL-8.4 on Windows 2000 server and k=
eep
> getting the following
>
>
> creating template1 database in
> C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ... init=
db:
> could not execute command
> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/p ostgres.exe"
> --boot -x1 -F ": No error
>
>              =
    initdb: removing contents of data directory
> "C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"
>
>
>
> I have checked the archives but did not see any solution so far.
>
> The data directory does have inheritable permissions for user postgres to
> read, write, modify etc.
>
>

are you executing the installer with a privileged user?


--=20
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 09.04.2010 12:21:08 von pmandal

SGkgSmFpbWUNCg0KVGhlIGluc3RhbGxlciBpcyBiZWluZyBleGVjdXRlZCBh
cyBBZG1pbmlzdHJhdG9yDQpJIGhhdmUgY2hlY2sgdG8gZW5zdXJlIHRoYXQs
IGl0IHdpbGwgZmFpbCBvdGhlcndpc2UgYmVmb3JlIGV2ZW4gc3RhcnRpbmcg
dG8gaW5zdGFsbCBQb3N0Z3JlU1FMLg0KDQpUaGFua3MNClBhbmthag0KDQot
LS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogSmFpbWUgQ2FzYW5v
dmEgW21haWx0bzpqY2FzYW5vdkBzeXN0ZW1ndWFyZHMuY29tLmVjXSANClNl
bnQ6IEZyaWRheSwgQXByaWwgMDksIDIwMTAgMTI6MDEgQU0NClRvOiBQYW5r
YWogTWFuZGFsIChwbWFuZGFsKQ0KQ2M6IHBnc3FsLWFkbWluQHBvc3RncmVz
cWwub3JnDQpTdWJqZWN0OiBSZTogW0FETUlOXSBpbml0ZGIgZmFpbHVyZQ0K
DQpPbiBUaHUsIEFwciA4LCAyMDEwIGF0IDc6MjggUE0sIFBhbmthaiBNYW5k
YWwgKHBtYW5kYWwpDQo8cG1hbmRhbEBjaXNjby5jb20+IHdyb3RlOg0KPiBI
aSBBbGwNCj4NCj4NCj4NCj4gSSBoYXZlIGJlZW4gdHJ5aW5nIHRvIGluc3Rh
bGwgUG9zdGdyZVNRTC04LjQgb24gV2luZG93cyAyMDAwIHNlcnZlciBhbmQg
a2VlcA0KPiBnZXR0aW5nIHRoZSBmb2xsb3dpbmcNCj4NCj4NCj4gY3JlYXRp
bmcgdGVtcGxhdGUxIGRhdGFiYXNlIGluDQo+IEM6L1BST0dSQX4xL0NJU0NP
U34xL0NTQ09OY2NtL29iamVjdHMvUG9zdGdyZVNRTC84LjQvZGF0YS9iYXNl
LzEgLi4uIGluaXRkYjoNCj4gY291bGQgbm90IGV4ZWN1dGUgY29tbWFuZA0K
PiAiIkM6L1BST0dSQX4xL0NJU0NPU34xL0NTQ09OY2NtL29iamVjdHMvUG9z
dGdyZVNRTC84LjQvYmluL3Bvc3RncmVzLmV4ZSINCj4gLS1ib290IC14MSAt
RiAiOiBObyBlcnJvcg0KPg0KPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC
oMKgwqAgaW5pdGRiOiByZW1vdmluZyBjb250ZW50cyBvZiBkYXRhIGRpcmVj
dG9yeQ0KPiAiQzovUFJPR1JBfjEvQ0lTQ09TfjEvQ1NDT05jY20vb2JqZWN0
cy9Qb3N0Z3JlU1FMLzguNC9kYXRhIg0KPg0KPg0KPg0KPiBJIGhhdmUgY2hl
Y2tlZCB0aGUgYXJjaGl2ZXMgYnV0IGRpZCBub3Qgc2VlIGFueSBzb2x1dGlv
biBzbyBmYXIuDQo+DQo+IFRoZSBkYXRhIGRpcmVjdG9yeSBkb2VzIGhhdmUg
aW5oZXJpdGFibGUgcGVybWlzc2lvbnMgZm9yIHVzZXIgcG9zdGdyZXMgdG8N
Cj4gcmVhZCwgd3JpdGUsIG1vZGlmeSBldGMuDQo+DQo+DQoNCmFyZSB5b3Ug
ZXhlY3V0aW5nIHRoZSBpbnN0YWxsZXIgd2l0aCBhIHByaXZpbGVnZWQgdXNl
cj8NCg0KDQotLSANCkF0ZW50YW1lbnRlLA0KSmFpbWUgQ2FzYW5vdmENClNv
cG9ydGUgeSBjYXBhY2l0YWNpw7NuIGRlIFBvc3RncmVTUUwNCkFzZXNvcsOt
YSB5IGRlc2Fycm9sbG8gZGUgc2lzdGVtYXMNCkd1YXlhcXVpbCAtIEVjdWFk
b3INCkNlbC4gKzU5Mzg3MTcxMTU3DQoKLS0gClNlbnQgdmlhIHBnc3FsLWFk
bWluIG1haWxpbmcgbGlzdCAocGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcp
ClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDov
L3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1hZG1pbgo=

Re: initdb failure

am 09.04.2010 16:26:39 von Kevin Grittner

"Pankaj Mandal (pmandal)" wrote:

> initdb: could not execute command
> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/
> postgres.exe" --boot -x1 -F ": No error

I would check permissions related to the user and that postgres.exe
file.

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 10.04.2010 03:42:21 von pmandal

Hi Kevin,

I have checked this several times. The installer is executed by user
Administrator (which apparently has all Administrator privileges)
The user postgres is also being created and the data directory is owned
by this user, which does have read, write, execute, modify, list folder
contents and they are all inheritable. Here I am copying few more lines
from the logs, upto when initdb failed.


"
Ensuring we can write to the data directory (using cacls):
processed dir:
C:\PROGRA~1\CISCOS~1\CSCONccm\objects\PostgreSQL\8.4\data
=09
The files belonging to this database system will be owned by
user "Administrator".
This user must also own the server process.
=09
The database cluster will be initialized with locale
English_United States.1252.
The default text search configuration will be set to "english".
=09
fixing permissions on existing directory
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
creating configuration files ... ok
creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/1 ...
initdb: could not execute command
""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/p ostgres.exe"
--boot -x1 -F ": No error
initdb: removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"


"

Thank you
Pankaj

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]=20
Sent: Friday, April 09, 2010 7:27 AM
To: Pankaj Mandal (pmandal); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] initdb failure

"Pankaj Mandal (pmandal)" wrote:
=20
> initdb: could not execute command
> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/
> postgres.exe" --boot -x1 -F ": No error
=20
I would check permissions related to the user and that postgres.exe
file.
=20
-Kevin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 11.04.2010 20:04:42 von Kevin Grittner

"Pankaj Mandal (pmandal)" wrote:

> creating template1 database in
> C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/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: removing contents of data directory
> "C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"

I don't recognize this. Anyone else? I am curious what can cause a
failure with a description of "No error"

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 12.04.2010 00:17:33 von 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 mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 12.04.2010 01:09:23 von Joe Conway

Kevin Grittner wrote:
> "Pankaj Mandal (pmandal)" wrote:
>
>> creating template1 database in
>> C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/ba se/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: removing contents of data directory
>> "C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"
>
> I don't recognize this. Anyone else? I am curious what can cause a
> failure with a description of "No error"

This is the only matching string in initdb.c

/*
* Open a subcommand with suitable error messaging
*/
static FILE *
popen_check(const char *command, const char *mode)
{
FILE *cmdfd;

fflush(stdout);
fflush(stderr);
errno = 0;
cmdfd = popen(command, mode);
if (cmdfd == NULL)
fprintf(stderr,
_("%s: could not execute command \"%s\": %s\n"),
progname, command, strerror(errno));
return cmdfd;
}

So I guess the question is, what could cause popen on Windows to return
NULL, but not set errno?

Joe

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 12.04.2010 06:57:55 von 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 before
trying to load modules etc.

initcluster.vbs
startupcfg.vbs
createshortcuts.vbs
startserver.vbs
loadmodules.vbs

This pretty much seems to work on about half a dozen other machines
where I have tested it. Meaning the data directory gets initialized
properly,
Servers start properly and modules get loaded correctly and later I am
able to create database and execute SQL as well.

On this one machine (Windows 2000 server) I get this problem, which
results in unsuccessful install.=20
I also get another error message as posted in the forum
http://archives.postgresql.org/pgsql-admin/2010-04/msg00097. php
With all the installs but that does not seem to cause any problem to my
application so far.


Thanks
Pankaj
=20

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
Sent: Sunday, April 11, 2010 3:18 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] initdb failure

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 12.04.2010 07:25:18 von 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 inheritable.

Thanks
Pankaj

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
Sent: Sunday, April 11, 2010 3:18 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] initdb failure

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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 22.04.2010 21:44:54 von Jan-Peter.Seifert

Hello Pankaj,

well - obviously initdb wasn't run by (the operating system's user)
postgres. The owner of the server process (normally named postgres)
mustn't have any administrator privileges:

http://www.postgresql.org/docs/8.4/interactive/app-initdb.ht ml

Good luck.

Maybe there wasn't any problem so far because the other PostgreSQL
servers have been installed on non-NTFS file systems?

Good luck,

Peter

Am 12.04.2010 07:25, schrieb Pankaj Mandal (pmandal):

> 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 inheritable.
>
> Thanks
> Pankaj
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
> Sent: Sunday, April 11, 2010 3:18 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] initdb failure
>
> 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 mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: initdb failure

am 22.04.2010 22:52:46 von pmandal

Hi Peter,

The link you mention below does not say that Operating System user
postgres, should not have Administrator privileges,
It says user postgres may not have sufficient privileges and could fail
to create the Data directory, in that case, create Data directory by
root user and change ownership to postgres. This is not the case here,
the Data directory does get created and the owner is postgres. It fails
subsequently during initdb though.

Also I have successfully tested the installation on more than half dozen
machines and they are all NTFS file systems.

Thanks
Pankaj


-----Original Message-----
From: Jan-Peter Seifert [mailto:Jan-Peter.Seifert@gmx.de]=20
Sent: Thursday, April 22, 2010 12:45 PM
To: Pankaj Mandal (pmandal)
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] initdb failure

Hello Pankaj,

well - obviously initdb wasn't run by (the operating system's user)
postgres. The owner of the server process (normally named postgres)
mustn't have any administrator privileges:

http://www.postgresql.org/docs/8.4/interactive/app-initdb.ht ml

Good luck.

Maybe there wasn't any problem so far because the other PostgreSQL
servers have been installed on non-NTFS file systems?

Good luck,

Peter

Am 12.04.2010 07:25, schrieb Pankaj Mandal (pmandal):

> 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 inheritable.
>=20
> Thanks
> Pankaj
>=20
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jan-Peter
Seifert
> Sent: Sunday, April 11, 2010 3:18 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] initdb failure
>=20
> Hello,
>=20
>> The files belonging to this database system will be owned by
>> user "Administrator".
>> This user must also own the server process.
>=20
> the user here should be postgres.
> Are you 'locally'/'directly' installing on the server machine?
>=20
> Good luck.
>=20
> Peter
>=20

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin