Обсуждение: Re: CYGWin-Postgres

Ravi,

Please post to <pgsql-cygwin@postgresql.org> instead of sending private
email.

On Fri, Jun 14, 2002 at 01:02:32PM +0530, ravi(hotmail) wrote:
> hi jatson,
> This is Ravi Shankar, i am working on a project using postgresql database
> server, I have installed cygwin with postgresql database server. but the
> database is not getting initilised.
> i tryed as below.
>
> as administrator Created directory.
> $ /var/lib/pgsql/data
>
> now typed the command to initilise the database as follows.
>
> & initdb -D /var/lib/pgsql/data
> The files belonging to this database system will be owned by user
> "Administrator".
> This user must also own the server process.
>
> Fixing permissions on existing directory /lib/postgresql/data... ok
> creating directory /lib/postgresql/data/base... ok
> creating directory /lib/postgresql/data/global... ok
> creating directory /lib/postgresql/data/pg_xlog... ok
> creating directory /lib/postgresql/data/pg_clog... ok
> creating template1 database in /lib/postgresql/data/base/1...
>
> and the  process hangs it goes in to infinite loop...
> hoping for an early responce, please...

You forgot to start ipc-daemon.  Please read the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.2.1.README

Jason

thanks for the help, Jason.
i had one more question,
can i run postgresql's postmaster as the service under windows NT/2000 ,with
out the need of cygwin console?
if yes, how to specify the data path?

--Ravi Shankar--

----- Original Message -----
From: "Jason Tishler" <jason@tishler.net>
To: "ravi(hotmail)" <banka_ravi@hotmail.com>
Cc: "Pgsql-Cygwin" <pgsql-cygwin@postgresql.org>
Sent: Friday, June 14, 2002 3:51 PM
Subject: Re: CYGWin-Postgres


> Ravi,
>
> Please post to <pgsql-cygwin@postgresql.org> instead of sending private
> email.
>
> On Fri, Jun 14, 2002 at 01:02:32PM +0530, ravi(hotmail) wrote:
> > hi jatson,
> > This is Ravi Shankar, i am working on a project using postgresql
database
> > server, I have installed cygwin with postgresql database server. but the
> > database is not getting initilised.
> > i tryed as below.
> >
> > as administrator Created directory.
> > $ /var/lib/pgsql/data
> >
> > now typed the command to initilise the database as follows.
> >
> > & initdb -D /var/lib/pgsql/data
> > The files belonging to this database system will be owned by user
> > "Administrator".
> > This user must also own the server process.
> >
> > Fixing permissions on existing directory /lib/postgresql/data... ok
> > creating directory /lib/postgresql/data/base... ok
> > creating directory /lib/postgresql/data/global... ok
> > creating directory /lib/postgresql/data/pg_xlog... ok
> > creating directory /lib/postgresql/data/pg_clog... ok
> > creating template1 database in /lib/postgresql/data/base/1...
> >
> > and the  process hangs it goes in to infinite loop...
> > hoping for an early responce, please...
>
> You forgot to start ipc-daemon.  Please read the README:
>
>
http://www.tishler.net/jason/software/postgresql/postgresql-7.2.1.README
>
> Jason

Ravi,

On Tue, Jun 18, 2002 at 01:58:03PM +0530, ravi(hotmail) wrote:
> thanks for the help, Jason.

You are welcome.

> i had one more question,

Sigh... You forgot to read the README.

> can i run postgresql's postmaster as the service under windows NT/2000 ,with
> out the need of cygwin console?

Yes.

> if yes, how to specify the data path?

As indicated in the README:

4. Install postmaster as a NT service:

    # cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep
ipc-daemon--termsig INT --user postgres --shutdown # [5] [6] 

Please read the README.

Thanks,
Jason

Ravi,

Please keep your replies on-list.

On Wed, Jun 19, 2002 at 09:53:10AM +0530, ravi(hotmail) wrote:
> i went through the README file but i was confused with the directory
> structure of the linux with the windows. so, i asked u again.

Maybe you should peruse the Cygwin site?

    http://www.cygwin.com/

> I think the linux envronment is provided by the utility 'cygrunsrv'

No, see above.  cygrunsrv is a utility that enables Unix daemons to run
as NT services.

Jason