Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postres Beta Installer Error on W2K SP4

Postres Beta Installer Error on W2K SP4

From
"Sean S. O'Donovan"
Date:
Hi,

I get the following errors on two different machines both running W2K200 SP4.

I installed the .msi file and received the following error after a series of postmaster application errors of the form
"thememory at XXXXXXXXX could not be referenced" 

This is the initdb log:

 The files belonging to this database system will be owned by user "postgres_user".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory G:/Program Files/PostgreSQL/7.5/data ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/global ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/pg_xlog ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/pg_xlog/archive_status ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/pg_clog ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/pg_subtrans ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/base ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/base/1 ... ok
creating directory G:/Program Files/PostgreSQL/7.5/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in G:/Program Files/PostgreSQL/7.5/data/base/1 ... Deleted file - G:\Program
Files\PostgreSQL\7.5\data\pg_hba.conf
Deleted file - G:\Program Files\PostgreSQL\7.5\data\pg_ident.conf
Deleted file - G:\Program Files\PostgreSQL\7.5\data\PG_VERSION
Deleted file - G:\Program Files\PostgreSQL\7.5\data\postgresql.conf
child process was terminated by signal 5
initdb: failed
initdb: removing contents of data directory "G:/Program Files/PostgreSQL/7.5/data"

After this the install rolled back and I had nothing !

I tested the latest (25 July 2004) release from http://www.hagander.net/pgsql/win32snap/ and got similar errors.

By replacing the postgres.exe and postmaster.exe with an older one from the above site ( I think about three dats
older)I could continue as normal. 


Is this a W2K issue only ? I have been regularly downloading and testing the win32 binary releases and this
postmaster/postgresexe issue is the only serious problem I have not been able to get around without reverting to an
earlierrelease. 


Thanks for the great work

Sean O'Donovan

Re: Postres Beta Installer Error on W2K SP4

From
"Merlin Moncure"
Date:
> I get the following errors on two different machines both running
W2K200
> SP4.
>
> I installed the .msi file and received the following error after a
series
> of postmaster application errors of the form "the memory at XXXXXXXXX
> could not be referenced"
>
> This is the initdb log:
>
>  The files belonging to this database system will be owned by user
> "postgres_user".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> fixing permissions on existing directory G:/Program
> Files/PostgreSQL/7.5/data ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/global ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/pg_xlog ... ok
> creating directory G:/Program
> Files/PostgreSQL/7.5/data/pg_xlog/archive_status ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/pg_clog ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/pg_subtrans
... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/base ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/base/1 ... ok
> creating directory G:/Program Files/PostgreSQL/7.5/data/pg_tblspc ...
ok
> selecting default max_connections ... 10
> selecting default shared_buffers ... 50
> creating configuration files ... ok
> creating template1 database in G:/Program
Files/PostgreSQL/7.5/data/base/1
> ... Deleted file - G:\Program Files\PostgreSQL\7.5\data\pg_hba.conf
> Deleted file - G:\Program Files\PostgreSQL\7.5\data\pg_ident.conf
> Deleted file - G:\Program Files\PostgreSQL\7.5\data\PG_VERSION
> Deleted file - G:\Program Files\PostgreSQL\7.5\data\postgresql.conf
> child process was terminated by signal 5
> initdb: failed
> initdb: removing contents of data directory "G:/Program
> Files/PostgreSQL/7.5/data"
>
> After this the install rolled back and I had nothing !
>
> I tested the latest (25 July 2004) release from
> http://www.hagander.net/pgsql/win32snap/ and got similar errors.
>
> By replacing the postgres.exe and postmaster.exe with an older one
from
> the above site ( I think about three dats older) I could continue as
> normal.
>
>
> Is this a W2K issue only ? I have been regularly downloading and
testing
> the win32 binary releases and this postmaster/postgres exe issue is
the
> only serious problem I have not been able to get around without
reverting
> to an earlier release.

I was playing around with it last night on XP and had the same problem.
Haven't had time to look at it yet tho.  This was on a version I
compiled myself.

Merlin

Re: Postres Beta Installer Error on W2K SP4

From
"Merlin Moncure"
Date:
> Hi,
>
> I get the following errors on two different machines both running
W2K200
> SP4.

I've confirmed right now win32 is totally busted.  This is not due to
your o/s, installer, or bad build.  I tried rolling back the last two
version of initdb (no help).  The AV is thrown from postgres.exe...

Merlin

Re: Postres Beta Installer Error on W2K SP4

From
"Sean S. O'Donovan"
Date:
Merlin,

I am also sure it is postgres.exe/postmaster.exe (See my e-mail at near the bottom.) An older one, dated 20/07/2007
doeswork. In fact if you use yesterday's build but just replace the above two exe's with those of 20/07/2004 then it
works.(Well, initdb works, I did not test further ) 


Thanks

Sean O'Donovan