Failed to run initdb: 128!

[anthony herve]

Hello,

I am trying to install postgresql-8.2.1-1 on a VPS server (via Remote Desktop) with Windows Server 2003 (pack 1).

I use the postgresql-8.2.msi installer with:
- installation language = english
- national language support, PL/java, Development files selected
- install a service option checked with postgres user
- initialise database cluster option checked with port 5432, accept connection on all adresses not just localhost option checked, locale English UK, encoding Latin1 and superuser postgres
- PL/pgsql, PL/perl, PL/python selected
- Adminpack selected as contrib module.

I execute the installation as Administrator (usergroup Administrators).
I get the error " Failed to run initdb: 128! " with an error log that is empty.

Googling this error, I can see it is probably something to do with authorisations but I can't figure out what is wrong exactly.

Have you ever encountered this error message? How did you finally fix it?

Thanks a lot for your help.
Best regards,
Anthony

---

Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.

[Magnus Hagander-2]

On Thu, Feb 01, 2007 at 12:58:17PM +0100, anthony herve wrote:
> Hello,
>
> I am trying to install postgresql-8.2.1-1 on a VPS server (via Remote Desktop) with Windows Server 2003 (pack 1).

What VPS technology is being used?

Also, beware that there are known issues when installing from Terminal
Services. Most of them are not current anymore, but there seems to be at
least one problem still there. However, that usually shows a log.
Anyway, make sure you try to install it from the console session (using
mstsc /console and connecting to the RDP service)

> I use the postgresql-8.2.msi installer with:
> - installation language = english
> - national language support, PL/java, Development files selected
> - install a service option checked with postgres user
> - initialise database cluster option checked with port 5432, accept connection on all adresses not just localhost option checked, locale English UK, encoding Latin1 and superuser postgres
> - PL/pgsql, PL/perl, PL/python selected
> - Adminpack selected as contrib module.
>
> I execute the installation as Administrator (usergroup Administrators).
> I get the error " Failed to run initdb: 128! " with an error log that is empty.

Unfortunatly, error 128 is a very "catch-all" like error :-(
What you should try is to install it without initdb:ing (just uncheck
the box), and then try to manually run the initdb command (don't forget
to set your locale and encoding). If that also fails, it shuld at least
be able to give you a better error message since it's not running under
the limited environment in the Windows Installer executor.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@... so that your
       message can get through to the mailing list cleanly

[adula]

Hello,

Magnus Hagander-2 wrote:

Unfortunatly, error 128 is a very "catch-all" like error :-(
What you should try is to install it without initdb:ing (just uncheck
the box), and then try to manually run the initdb command (don't forget
to set your locale and encoding). If that also fails, it shuld at least
be able to give you a better error message since it's not running under
the limited environment in the Windows Installer executor.

 I tried:

C:\Programme\PostgreSQL\8.2\bin>set pgdata=c:\Programme\PostgreSQL\8.2\data
C:\Programme\PostgreSQL\8.2\bin>initdb -E SQL_ASCII --locale=German_Germany.1252

Das Programm postgres wird von initdb benötigt, aber wurde nicht im selben Verzeichnis wie  
C:\Programme\PostgreSQL\8.2\bin/initdb gefunden. Prüfen Sie Ihre Installation. (postgres was not found)

my work around was:

runas /profile /user:postgres cmd (Start a command-window as user postgres)

give the password for postgres

C:\Programme\PostgreSQL\8.2\bin>set pgdata=c:\Programme\PostgreSQL\8.2\data

C:\Programme\PostgreSQL\8.2\bin>initdb -E SQL_ASCII --locale=German_Germany.1252

Die Dateien, die zu diesem Datenbanksystem gehören, werden dem Benutzer postgres gehören.
Diesem Benutzer muss auch der Serverprozess gehoren.
Der Datenbankcluster wird mit der Locale German_Germany.1252 initialisiert werden.
berichtige Zugriffsrechte des bestehenden Verzeichnisses
c:/Programme/PostgreSQL/8.2/data ... ok    
erzeuge Unterverzeichnisse ... ok
wähle Vorgabewert für max_connections ... 100
wõhle Vorgabewert f³r shared_buffers/max_fsm_pages ... 32MB/204800
erzeuge Konfigurationsdateien ... ok
erzeuge Datenbank template1 in c:/Programme/PostgreSQL/8.2/data/base/1 ... ok
initialisiere pg_authid ... ok
initialisiere Abhõngigkeiten ... ok
erzeuge Systemsichten ... ok
lade Systemobjektbeschreibungen ... ok
erzeuge Konversionen ... ok
setze Privilegien der eingebauten Objekte ... ok
erzeuge Informationsschema ... ok
f³hre Vacuum in Datenbank template1 durch ...ok
kopiere template1 nach template0 ... ok
kopiere template1 nach postgres ...ok
WARNUNG: Authentifizierung für lokale Verbindungen auf +trust½ gesetzt
Sie können dies ändern, indem Sie pg_hba.conf bearbeiten oder beim
nächsten Aufruf von initdb die Option -A verwenden.
Erfolg. Sie können den Datenbankserver jetzt mit "postgres" -D "c:/Programme/PostgreSQL/8.2/data"
oder
"pg_ctl" -D "c:/Programme/PostgreSQL/8.2/data" -l logdatei start
starten.




Regards
Adula