Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com Message-ID: <20040718215906.70178.qmail@web53706.mail.yahoo.com> Date: Sun, 18 Jul 2004 16:59:06 -0500 (CDT) From: =?iso-8859-1?q?Manuel=20Tejada?= Subject: I can't inicializate PostgreSQL To: cygwin AT cygwin DOT com MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-IsSubscribed: yes I am using PostgreSQL for Cygwin on Windows ME from April 2003 I was working with PostgreSQL 7.4.1-3 very well. Recently I decided to make an upgrade from PostgreSQL 7.4.1-3 to PostgreSQL 7.4.3-1 (the newest for cygwin). After installing the PostgreSQL 7.4.3-1 from Internet with the utility setup.exe, I followed the normal procedure that I was accustomed to use to inicializate the PostgreSQL, but the initdb failed. The following is what I got: ---------------------------------------------------- admin AT alejo ~ $ ipc-daemon2 & [1] 867359 admin AT alejo ~ $ initdb -D /usr/share/postgresql/data The files belonging to this database system will be owned by user "admin". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/share/postgresql/data... ok creating directory /usr/share/postgresql/data/base... ok creating directory /usr/share/postgresql/data/global... ok creating directory /usr/share/postgresql/data/pg_xlog... ok creating directory /usr/share/postgresql/data/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/data/base/1... Signal 12 initdb: failed initdb: removing data directory "/usr/share/postgresql/data" admin AT alejo ~ $ ---------------------------------------------- After reading some answer to various post in the mailing list archive with similar problem and the /usr/share/doc/Cygwin/postgres-7.4.3.README file, I decided to follow the procedure using Cygserver instead ipc-daemon2: - Set the CYGWIN variable enviroment to "server" - Install and configure cygserver - Run cygserver - Initialize PostgreSQL But now the cygserver failled to run because the System says the command is no found, as you can see in the ouptput I show you bellow: ------------------------------- admin AT alejo ~ $ CYGWIN=server admin AT alejo ~ $ export CYGWIN admin AT alejo ~ $ cygserver-config Generating /etc/cygserver.conf file chown: `system.544': invalid user Further configuration options are available by editing the configuration file /etc/cygserver.conf. Please read the inline information in that file carefully. The best option for the start is to just leave it alone. Please keep in mind, that a client application which wants to use the services provided by cygserver *must* have the environment variable CYGWIN set so that it contains the word "server". So, if you don't need any other special CYGWIN setting, just set it to "server". It is advisable to add this setting to the Windows system environment. Basic Cygserver configuration finished. Have fun! admin AT alejo ~ $ cygserver & [1]118735 $bash: cygserver: command not found [1]+ Exit 127 cygserver -------------------------------- My questions are: a) In what I am failling myself? b) Anybody knows how to fix this? c)Supposing there is no way how to fix this. what must I do to reinstall the old PostgreSQL (7.4.1-3) that I still have the tar.gz archive in a directory created by the utility setup.exe.? I tried to reinstall the old one with the utility setup.exe but I can not see it in the windows'utility. Maybe I have to install it using ./configure, make, etc.? Is possible do this? I'll appreciate any answer ===== Manuel TEJADA M. _________________________________________________________ Do You Yahoo!? La mejor conexión a internet y 25MB extra a tu correo por $100 al mes. http://net.yahoo.com.mx -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/