Обсуждение: 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.
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
>> 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.
> 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.