Thread: problem installing postgresql
Hello, After digging a lot, i discover that the initdb fail to do his job: $ initdb -U postgres -D /usr/share/postgresql/data2 -W -E LATIN1 -d Running in debug mode. initdb: internal variables: PGDATA=/usr/share/postgresql/data2 datadir=/usr/share/postgresql PGPATH=/usr/bin ENCODING=LATIN1 ENCODINGID=8 POSTGRES_SUPERUSERNAME=postgres POSTGRES_BKI=/usr/share/postgresql/postgres.bki POSTGRES_DESCR=/usr/share/postgresql/postgres.description POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample The files belonging to this database system will be owned by user "jeff". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory /usr/share/postgresql/data2... ok creating directory /usr/share/postgresql/data2/base... ok creating directory /usr/share/postgresql/data2/global... ok creating directory /usr/share/postgresql/data2/pg_xlog... ok creating directory /usr/share/postgresql/data2/pg_clog... ok selecting default max_connections... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 10 selecting default shared_buffers... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /usr/share/postgresql/data2/base/1... DEBUG: invoking IpcMemoryCreate(size=1081344) Signal 12 initdb: failed Anyone as an idea?
If you do a $env does cygwin=server appear in the list? On Tue, 2004-07-06 at 13:06, Jean-François Trevien wrote: > Hello, > > After digging a lot, i discover that the initdb fail to do his job: > > $ initdb -U postgres -D /usr/share/postgresql/data2 -W -E LATIN1 -d > Running in debug mode. > > initdb: internal variables: > PGDATA=/usr/share/postgresql/data2 > datadir=/usr/share/postgresql > PGPATH=/usr/bin > ENCODING=LATIN1 > ENCODINGID=8 > POSTGRES_SUPERUSERNAME=postgres > POSTGRES_BKI=/usr/share/postgresql/postgres.bki > POSTGRES_DESCR=/usr/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample > PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by user "jeff". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > fixing permissions on existing directory /usr/share/postgresql/data2... ok > creating directory /usr/share/postgresql/data2/base... ok > creating directory /usr/share/postgresql/data2/global... ok > creating directory /usr/share/postgresql/data2/pg_xlog... ok > creating directory /usr/share/postgresql/data2/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/share/postgresql/data2/base/1... > DEBUG: invoking IpcMemoryCreate(size=1081344) > Signal 12 > > initdb: failed > > Anyone as an idea? > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
I had the same problem, it took me 2 days to figure it out. My problem was the enviroment variable in windows (CYGWIN=server). When you install cyrserver it writes out thet he needs this variable. So put this enviroment variable. Look in the document: /usr/share/doc/cygwin/postgresql-7.4.3.README at the special instructions(chmod for the temp dir and /usr/bin etc). Hope this helps. Andy. ----- Original Message ----- From: "Jean-François Trevien" <jftrevien@free.fr> To: <pgsql-cygwin@postgresql.org> Sent: Tuesday, July 06, 2004 9:06 PM Subject: [CYGWIN] problem installing postgresql > Hello, > > After digging a lot, i discover that the initdb fail to do his job: > > $ initdb -U postgres -D /usr/share/postgresql/data2 -W -E LATIN1 -d > Running in debug mode. > > initdb: internal variables: > PGDATA=/usr/share/postgresql/data2 > datadir=/usr/share/postgresql > PGPATH=/usr/bin > ENCODING=LATIN1 > ENCODINGID=8 > POSTGRES_SUPERUSERNAME=postgres > POSTGRES_BKI=/usr/share/postgresql/postgres.bki > POSTGRES_DESCR=/usr/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample > PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by user "jeff". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > fixing permissions on existing directory /usr/share/postgresql/data2... ok > creating directory /usr/share/postgresql/data2/base... ok > creating directory /usr/share/postgresql/data2/global... ok > creating directory /usr/share/postgresql/data2/pg_xlog... ok > creating directory /usr/share/postgresql/data2/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/share/postgresql/data2/base/1... > DEBUG: invoking IpcMemoryCreate(size=1081344) > Signal 12 > > initdb: failed > > Anyone as an idea? > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
I had the same problem, it took me 2 days to figure it out. My problem was the enviroment variable in windows (CYGWIN=server). When you install cyrserver it writes out thet he needs this variable. So put this enviroment variable. Look in the document: /usr/share/doc/cygwin/postgresql-7.4.3.README at the special instructions(chmod for the temp dir and /usr/bin etc). Hope this helps. Andy. ----- Original Message ----- From: "Jean-François Trevien" <jftrevien@free.fr> To: <pgsql-cygwin@postgresql.org> Sent: Tuesday, July 06, 2004 9:06 PM Subject: [CYGWIN] problem installing postgresql > Hello, > > After digging a lot, i discover that the initdb fail to do his job: > > $ initdb -U postgres -D /usr/share/postgresql/data2 -W -E LATIN1 -d > Running in debug mode. > > initdb: internal variables: > PGDATA=/usr/share/postgresql/data2 > datadir=/usr/share/postgresql > PGPATH=/usr/bin > ENCODING=LATIN1 > ENCODINGID=8 > POSTGRES_SUPERUSERNAME=postgres > POSTGRES_BKI=/usr/share/postgresql/postgres.bki > POSTGRES_DESCR=/usr/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample > PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by user "jeff". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > fixing permissions on existing directory /usr/share/postgresql/data2... ok > creating directory /usr/share/postgresql/data2/base... ok > creating directory /usr/share/postgresql/data2/global... ok > creating directory /usr/share/postgresql/data2/pg_xlog... ok > creating directory /usr/share/postgresql/data2/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/share/postgresql/data2/base/1... > DEBUG: invoking IpcMemoryCreate(size=1081344) > Signal 12 > > initdb: failed > > Anyone as an idea? > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings