Re: New pginstaller beta - Mailing list pgsql-hackers-win32

From Kevin Tew
Subject Re: New pginstaller beta
Date
Msg-id 410E5A28.7060405@ekstrom.org
Whole thread Raw
In response to New pginstaller beta  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-hackers-win32
Getting the follow error on install.
Note also that I tried running initdb manually with -d
I used the postgres account that was created by the install to run
initdb, by first running runas /user:postgres "cmd"
then typing the init db call
Listman


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

The database cluster will be initialized with locale C.

fixing permissions on existing directory C:/Program
Files/PostgreSQL/7.5/data ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/global ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/pg_xlog ... ok
creating directory C:/Program
Files/PostgreSQL/7.5/data/pg_xlog/archive_status ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/pg_clog ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/pg_subtrans ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/base ... ok
creating directory C:/Program Files/PostgreSQL/7.5/data/base/1 ... ok
creating directory C:/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 C:/Program
Files/PostgreSQL/7.5/data/base/1 ... FATAL:  could not create shared
memory segment: No error
DETAIL:  Failed system call was shmget(key=1, size=1196032, 03600).
Deleted file - C:\Program Files\PostgreSQL\7.5\data\pg_hba.conf
Deleted file - C:\Program Files\PostgreSQL\7.5\data\pg_ident.conf
Deleted file - C:\Program Files\PostgreSQL\7.5\data\PG_VERSION
Deleted file - C:\Program Files\PostgreSQL\7.5\data\postgresql.conf
child process was terminated by signal 1
initdb: failed
initdb: removing contents of data directory "C:/Program
Files/PostgreSQL/7.5/data"

C:\PROGRA~1\PostgreSQL\7.5\bin>initdb -d -D ..\data -L ..\share
Running in debug mode.
VERSION=7.5devel
PGDATA=../data
share_path=../share
PGPATH=C:/PROGRA~1/PostgreSQL/7.5/bin
POSTGRES_SUPERUSERNAME=postgres
POSTGRES_BKI=../share/postgres.bki
POSTGRES_DESCR=../share/postgres.description
POSTGRESQL_CONF_SAMPLE=../share/postgresql.conf.sample
PG_HBA_SAMPLE=../share/pg_hba.conf.sample
PG_IDENT_SAMPLE=../share/pg_ident.conf.sample
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale English_United
States.1252.


fixing permissions on existing directory ../data ... ok
creating directory ../data/global ... ok
creating directory ../data/pg_xlog ... ok
creating directory ../data/pg_xlog/archive_status ... ok
creating directory ../data/pg_clog ... ok
creating directory ../data/pg_subtrans ... ok
creating directory ../data/base ... ok
creating directory ../data/base/1 ... ok
creating directory ../data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in ../data/base/1 ... DEBUG:  TZ
"US/Mountain" match
es Windows timezone "Mountain Daylight Time"
DEBUG:  invoking IpcMemoryCreate(size=1196032)
FATAL:  could not create shared memory segment: No error
DETAIL:  Failed system call was shmget(key=1, size=1196032, 03600).
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  exit(1)
child process was terminated by signal 1
initdb: failed
initdb: removing contents of data directory "../data"
Deleted file - C:\PROGRA~1\PostgreSQL\7.5\data\pg_hba.conf
Deleted file - C:\PROGRA~1\PostgreSQL\7.5\data\pg_ident.conf
Deleted file - C:\PROGRA~1\PostgreSQL\7.5\data\PG_VERSION
Deleted file - C:\PROGRA~1\PostgreSQL\7.5\data\postgresql.conf


Magnus Hagander wrote:

> A new beta-release of the win32 gui installer has been uploaded to
>pgfoundry.
>
>Postgresql is the snapshot from 20040731, with the win32 versioning/icon
>patch added, as well as the initdb auth patch (in the patch queue).
>
>Changes since last beta includes:
>* PgAdmin shortcuts are now predictably created.
>* Startmenu shortcuts are added to start and stop the database (pg_ctl
>or service depending on install method)
>* Service is set for automatic start instead of manual
>* Default encoding is now UNICODE
>* There is a base feature with a base directory so the install root can
>be changed at one place
>* The Next button is now always activated and a popup is shown if the
>specified passwords don't match. Workaround the fact that the activation
>required the password field to be de-focused before it happened.
>* A warning is shown if a service is installed without running initdb
>when there is no database in the directory already.
>* The installer now verifies that the user specified has Log on as a
>service right, and optionally grants it.
>* The installer now verifies that the user specified is not an
>administrative user, and refuses to continue if it is.
>* The installer now optionally creates a user account (with an optional
>random password) for the service.
>
>
>Plus a few other minor things.
>
>This addresses many of the issues brought up since the last beta, but
>not all. Please see the trackers on pgfoundry.org/projects/pginstaller
>for status on the other items, or to add new items.
>
>
>If you are upgrading from the previous snapshot, you'll have to
>uninstall the old version first. You can do this from Add/Remove
>progrmas, or by running "msiexec /x postgresql-7.5-devel.msi" on the
>commandline. This will not remove the data directory.
>You can run the new version on the same data directory, but we'd
>appreciate testing of clean installations anyway. In that case,
>pg_dump/reload and manual removal of the data directory is needed. (Full
>testing would also require removal/recreation of the service account, of
>course).
>
>
>As before, please post your feedback to the mailinglist on
>pgfoundry.org, or use the trackers.
>
>And thanks for all the feedback on the first beta!
>
>//Magnus & Dave
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>


pgsql-hackers-win32 by date:

Previous
From: Andreas Pflug
Date:
Subject: make fails if path has spaces
Next
From: "Sean S. O'Donovan"
Date:
Subject: FW: New pginstaller beta : Perfect on W2K SP4