Re: Postgres on Cygwin

David,

Please post instead of sending private email.

On Thu, Mar 11, 2004 at 01:01:40PM +1300, David Mitchell wrote:
> You mentioned in the list a while ago that you succeeded in building
> postgres against cygserver. We are having big trouble with postgres
> hanging and we are trying to get cygserver going because we think it
> is cygipc causing the hang, as you discussed a while back. I can't get
> postgres to build against cygserver though.

What are the details?

> Could you give me a guide to building postgres with cygserver please?

Yes, it is very easy:

1. Uninstall cypipc (if installed)
2. Reinstall Cygwin (if you uninstalled cygipc)
3. Build PostgreSQL (using the normal procedure)

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

>> Could you give me a guide to building postgres with cygserver please?
>
>
>
> Yes, it is very easy:
>
> 1. Uninstall cypipc (if installed)
> 2. Reinstall Cygwin (if you uninstalled cygipc)
> 3. Build PostgreSQL (using the normal procedure)

That's great, thank you. There is still a problem though. Postgres
builds and installs fine, but now when I try to run initdb I get a whole
lot of signal 12 messages:

$ initdb -D /usr/postgres/data
The files belonging to this database system will be owned by user "davidm".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/postgres/data... ok
creating directory /usr/postgres/data/base... ok
creating directory /usr/postgres/data/global... ok
creating directory /usr/postgres/data/pg_xlog... ok
creating directory /usr/postgres/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/postgres/data/base/1... Signal 12

initdb: failed
initdb: removing data directory "/usr/postgres/data"

Your help is very much appreciated, thanks

--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.

>> Could you give me a guide to building postgres with cygserver please?
>
>
>
> Yes, it is very easy:
>
> 1. Uninstall cypipc (if installed)
> 2. Reinstall Cygwin (if you uninstalled cygipc)
> 3. Build PostgreSQL (using the normal procedure)

That's great, thank you. There is still a problem though. Postgres
builds and installs fine, but now when I try to run initdb I get a whole
lot of signal 12 messages:

$ initdb -D /usr/postgres/data
The files belonging to this database system will be owned by user "davidm".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/postgres/data... ok
creating directory /usr/postgres/data/base... ok
creating directory /usr/postgres/data/global... ok
creating directory /usr/postgres/data/pg_xlog... ok
creating directory /usr/postgres/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/postgres/data/base/1... Signal 12

initdb: failed
initdb: removing data directory "/usr/postgres/data"

Your help is very much appreciated, thanks

--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.

David,

Sigh... Please keep your replies on-list.

On Fri, Mar 12, 2004 at 11:18:36AM +1300, David Mitchell wrote:
> >>Could you give me a guide to building postgres with cygserver
> >>please?
> >
> >Yes, it is very easy:
> >
> > 1. Uninstall cypipc (if installed)
> > 2. Reinstall Cygwin (if you uninstalled cygipc)
> > 3. Build PostgreSQL (using the normal procedure)
>
> That's great, thank you. There is still a problem though. Postgres
> builds and installs fine, but now when I try to run initdb I get a
> whole lot of signal 12 messages:
>
> $ initdb -D /usr/postgres/data
> The files belonging to this database system will be owned by user "davidm".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory /usr/postgres/data... ok
> creating directory /usr/postgres/data/base... ok
> creating directory /usr/postgres/data/global... ok
> creating directory /usr/postgres/data/pg_xlog... ok
> creating directory /usr/postgres/data/pg_clog... ok
> selecting default max_connections... Signal 12
> Signal 12
> [snip]
> initdb: failed
> initdb: removing data directory "/usr/postgres/data"
>
> Your help is very much appreciated, thanks

Did you read the cygserver README? Specifically, about setting
CYGWIN=server on the client side? Did you install and start the
cygserver service?

IIRC, you may need to tweak some of the settings in the postgresql.conf
file. This will be clearly documented in my README when I release a
Cygwin PostgreSQL built against cygserver. Note that I am waiting for
Cygwin 1.5.8 before doing so.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

> Did you read the cygserver README? Specifically, about setting
> CYGWIN=server on the client side? Did you install and start the
> cygserver service?

Ack, sorry, you are right. I forgot to set CYGWIN=server before I ran
initdb. Many thanks.

--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.

David,

On Mon, Mar 15, 2004 at 08:26:21AM +1300, David Mitchell wrote:
> >Did you read the cygserver README? Specifically, about setting
> >CYGWIN=server on the client side? Did you install and start the
> >cygserver service?
>
> Ack, sorry, you are right. I forgot to set CYGWIN=server before I ran
> initdb.

No problem.

> Many thanks.

You are welcome.

Does running against cygserver instead of cygipc solve your hanging
problem?

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Jason,

> Does running against cygserver instead of cygipc solve your hanging
> problem?

Yes it does, which is very good; our operations guys were getting fed up
of being woken at 5 in the morning to restart the postmaster.

--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.