Re: Problem in running PostgreSQL - Mailing list pgsql-cygwin

From s0lao@netscape.net (S. L.)
Subject Re: Problem in running PostgreSQL
Date
Msg-id 55346762.03C7EDDB.00013D13@netscape.net
Whole thread Raw
In response to Problem in running PostgreSQL  ("Dakshinamoorthy Venkataraman" <dakshi.venkat@wipro.com>)
List pgsql-cygwin
[...]
But if I copy this minimal setup to a system without a Cygwin installation, there is a problem.
[...]

Copying a minimal cygwin installation is not enough. There are also several things to do (to have a functional copy):
1. to copy (at least system) registry settings cygwin uses. The mount information is stored there.
2. to reproduce the environment. If you are not a *nix wizard, "cloning" is the best choice (i.e. identically
reproducingenvironment variables and related files that help in their definition -- /etc/passwd, /etc/group, etc.). 

[...]
I am able to start the PostgreSQL server. When I try to connect to the database using psql as a user of the database,
theserver processes get killed and the database crashes. I login a a user who is different from the user that created
thedatabase. When I check the logs, I see that it it because of the shm_get call (shared memory call). I tried to tweek
theparameters, but in vain. I suspect there is a problem in the users. 
[...]

Continuing the above, when cloning the environment there are also some aspects user related.
On a win9x machine, a simple copy is enough, but for network purposes, is also necessary to login to windows as a valid
"/etc/passwd"user. 
On a NT/W2K/XP machine things come more complicated, as there is a real user database, and there are some file
restrictionsarising. If the minimal cygwin environment used to have a PostgreSQL working was established on such
machine,then a good bet is not just to network copy the files between machines, but to tar the installation tree and to
untaron the other side. 

Hope it helps,

SLao

__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/

pgsql-cygwin by date:

Previous
From: "Cheah Ai Meng"
Date:
Subject: Re: Problem with PostgreSQL: unable to connect to database
Next
From: Andrew Klimov
Date:
Subject: Postgres 7.3.1 "make install" fails when trying to install pgtclsh