Thread: error in cygwin - please help me
Hello, I ´ve got some problems with cygwin. Let me explain: I run the ipc-daemon and type the command: $ initdb -D /var/psql . The message showed is the following: The files belonging to this database system will be owned by user "caroline". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory /var/psql... ok creating directory /var/psql/base.. ok creating directory /var/psql/global.. ok creating directory /var/psql/pg_xlog.. ok creating directory /var/psql/pg_clog.. ok selecting defaulr max_connections... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 10 slecting 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 /var/psql/base/1... Signal 12 initdb failed I wonder if you might explain me what could be my error while trying to run this program. Have a nice day Caroline Perlin.
Hi, ipc-daemon is no longer used. You need to start cygserver and make sure it is in your path. Whatever instruction list youare following is out of date. Are you following the readme included with the package? I thought that had been updated last release but perhaps not.... On Wed, Sep 22, 2004 at 11:22:03AM -0400, Caroline Perlin wrote: > Hello, > > I ´ve got some problems with cygwin. Let me explain: > > I run the ipc-daemon and type the command: > $ initdb -D /var/psql . > The message showed is the following: > > > The files belonging to this database system will be owned by user "caroline". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > fixing permissions on existing directory /var/psql... ok > creating directory /var/psql/base.. ok > creating directory /var/psql/global.. ok > creating directory /var/psql/pg_xlog.. ok > creating directory /var/psql/pg_clog.. ok > selecting defaulr max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > slecting 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 /var/psql/base/1... Signal 12 > > initdb failed > > > I wonder if you might explain me what could be my error while trying > to run this program. > Have a nice day > Caroline Perlin. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
Mike G. schrieb: >>I ´ve got some problems with cygwin. Let me explain: >> >>I run the ipc-daemon and type the command: >>$ initdb -D /var/psql . >>The message showed is the following: >> >> >>The files belonging to this database system will be owned by user "caroline". >>This user must also own the server process. >> >>The database cluster will be initialized with locale C. >> >>fixing permissions on existing directory /var/psql... ok >>creating directory /var/psql/base.. ok >>creating directory /var/psql/global.. ok >>creating directory /var/psql/pg_xlog.. ok >>creating directory /var/psql/pg_clog.. ok >>selecting defaulr max_connections... Signal 12 >>Signal 12 >>Signal 12 >>Signal 12 >>Signal 12 >>Signal 12 >>10 these signals (aborts) are okay: it tries to find the max_connections settings the hard way, until it works. it found 10 is okay for you. >>slecting 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 same as above, 50 buffers are found to be good for you. >>creating configuration files... ok >>creating template1 database in /var/psql/base/1... Signal 12 this is a real unexpected error. typically some file permission problem. pid file, logfile, sock file >> >>initdb failed >> >> >>I wonder if you might explain me what could be my error while trying >>to run this program. >>Have a nice day >>Caroline Perlin. -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/
This error appears to have been submitted on 24 Sep 2004, but I can't find
the solution.
I am running a fresh complete install of Cygwin as well as the download
for PostrgreSQL 7.4.5.
When I do the 'initdb -D /var/postgresql/data' I get the following result:
The files belonging to this database system will be owned by user "Chip".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /var/postgresql/data... ok
creating directory /var/postgresql/data/base... ok
creating directory /var/postgresql/data/global... ok
creating directory /var/postgresql/data/pg_xlog... ok
creating directory /var/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 /var/postgresql/data/base/1... Signal 12
initdb: failed
initdb: removing data directory "/var/postgresql/data"
From what I read, i understand the initial 'Signal 12's are fine. But it
still doesn't install the DB. I have CYGSERVER installed and it appears
to be running correctly. I have opened all of the permissions in the
following folders in hopes of avoiding the permission error:
/var/*
/usr/*
/tmp/*
Thank you for your help!
Chip
=====
Chip Long
Home Phone: 720-289-4751
Work Phone: 800-583-4747 x102
303-448-9948 x102
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
On Sat, 9 Oct 2004 22:44:10 -0700 (PDT), Chip Long <chip_long@yahoo.com> wrote:
> The database cluster will be initialized with locale C.
>
> creating directory /var/postgresql/data... ok
> creating directory /var/postgresql/data/base... ok
> creating directory /var/postgresql/data/global... ok
> creating directory /var/postgresql/data/pg_xlog... ok
> creating directory /var/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 /var/postgresql/data/base/1... Signal 12
>
> initdb: failed
> initdb: removing data directory "/var/postgresql/data"
>
> >From what I read, i understand the initial 'Signal 12's are fine. But it
> still doesn't install the DB. I have CYGSERVER installed and it appears
> to be running correctly. I have opened all of the permissions in the
> following folders in hopes of avoiding the permission error:
> /var/*
> /usr/*
> /tmp/*
>
> Thank you for your help!
Looks like the exact errors I get with the cygserver not running. Have
you run cygserver-config? I had a few problems before I ran this.
Check the CYGWIN environment variable as well. I had a typo in mine
that caused all sorts of problems.
$ net stop cygserver
The CYGWIN cygserver service is stopping.
The CYGWIN cygserver service was stopped successfully.
$ initdb -D /tmp/atest2
The files belonging to this database system will be owned by user "klint".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /tmp/atest2... ok
creating directory /tmp/atest2/base... ok
creating directory /tmp/atest2/global... ok
creating directory /tmp/atest2/pg_xlog... ok
creating directory /tmp/atest2/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 /tmp/atest2/base/1... Signal 12
initdb: failed
initdb: removing data directory "/tmp/atest2"
$ net start cygserver
The CYGWIN cygserver service is starting..
The CYGWIN cygserver service was started successfully.
$ initdb -D /tmp/atest2
The files belonging to this database system will be owned by user "klint".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /tmp/atest2... ok
creating directory /tmp/atest2/base... ok
creating directory /tmp/atest2/global... ok
creating directory /tmp/atest2/pg_xlog... ok
creating directory /tmp/atest2/pg_clog... ok
selecting default max_connections... 40
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /tmp/atest2/base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/bin/postmaster -D /tmp/atest2
or
/usr/bin/pg_ctl -D /tmp/atest2 -l logfile start
$
+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+
I just wanted to follow up this post, which solved upgrade issues for me with the same symptoms. http://archives.postgresql.org/pgsql-cygwin/2004-10/msg00020.php Setting up cygserver fixed the problem and I suggest the PostgreSQL install notes should include this dependency. There are notes on cygserver set up in the system documentation, but I thought these summary points might be helpful to others searching the mail archive. First, you must be logged in as a Windows Administrator. In a Cygwin console run the cygserver configuration script: % bin/cygserver-config Overwrite existing /etc/cygserver.conf file? (yes/no) yes Generating /etc/cygserver.conf file chown: `system.544': invalid user Warning: The following function requires administrator privileges! Do you want to install cygserver as service? (Say "no" if it's already installed as service) (yes/no) yes The service has been installed under LocalSystem account. To start it, call `net start cygserver' or `cygrunsrv -S cygserver'. 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! =========================================================== Then go to Start > Settings > Control Panel > System. Choose the Advanced tab and select Environment Variables. In the System Variables section, select New... and enter these settings: Variable Name: CYGWIN Variable Value: server Close any active Cygwin console, open a fresh one and enter: % env | less This list should include the line: CYGWIN=server Press Q to exit less. Now when you want to start cygserver manually, type: $ net start cygserver You will see two processes in the Windows Task Manager: cygserver.exe and cygrunsrv.exe Hope this helps. Phil -- <URL:http://www.codestyle.org/>