PostgreSQL for Windows - Cygwin problem, compiling from source

Author

Cygwin problem, compiling from source

Brian Osborne

2005-04-10, 8:24 pm

To whom it may concern,

I ran the configure and make and make install commands, everything seemed to
be fine. I can see that the DLL's have been installed:

153 ~/src/postgresql-8.0.1>find /usr/local/pgsql/ -name '*dll'
/usr/local/pgsql/lib/ascii_and_mic.dll
/usr/local/pgsql/lib/cygpq.dll
/usr/local/pgsql/lib/cyrillic_and_mic.dll
/usr/local/pgsql/lib/ecpg.dll
/usr/local/pgsql/lib/ecpg_compat.dll
/usr/local/pgsql/lib/euc_cn_and_mic.dll
/usr/local/pgsql/lib/euc_jp_and_sjis.dll
/usr/local/pgsql/lib/euc_kr_and_mic.dll
/usr/local/pgsql/lib/euc_tw_and_big5.dll
/usr/local/pgsql/lib/latin2_and_win1250.dll
/usr/local/pgsql/lib/latin_and_mic.dll
/usr/local/pgsql/lib/pgtypes.dll
/usr/local/pgsql/lib/plpgsql.dll
/usr/local/pgsql/lib/utf8_and_ascii.dll
/usr/local/pgsql/lib/utf8_and_big5.dll
/usr/local/pgsql/lib/utf8_and_cyrillic.dll
/usr/local/pgsql/lib/utf8_and_euc_cn.dll
/usr/local/pgsql/lib/utf8_and_euc_jp.dll
/usr/local/pgsql/lib/utf8_and_euc_kr.dll
/usr/local/pgsql/lib/utf8_and_euc_tw.dll
/usr/local/pgsql/lib/utf8_and_gb18030.dll
/usr/local/pgsql/lib/utf8_and_gbk.dll
/usr/local/pgsql/lib/utf8_and_iso8859.dll
/usr/local/pgsql/lib/utf8_and_iso8859_1.dll
/usr/local/pgsql/lib/utf8_and_johab.dll
/usr/local/pgsql/lib/utf8_and_sjis.dll
/usr/local/pgsql/lib/utf8_and_tcvn.dll
/usr/local/pgsql/lib/utf8_and_uhc.dll
/usr/local/pgsql/lib/utf8_and_win1250.dll
/usr/local/pgsql/lib/utf8_and_win1256.dll
/usr/local/pgsql/lib/utf8_and_win874.dll

However, when I run:

>initdb -D /usr/local/pgsql/data -W -E LATIN1

I see a dialog box saying:

This application could not start because cygpq.dll was not found

Do you have any ideas?

postgresql-8.0.1
CYGWIN_NT-5.1 Cognia-brian 1.5.13(0.122/4/2) 2005-03-01 11:01 i686 unknown
unknown Cygwin
Windows XP

Thank you,

Brian O.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reini Urban

2005-04-11, 7:25 am

Brian Osborne schrieb:
> To whom it may concern,
>
> I ran the configure and make and make install commands, everything seemed to
> be fine. I can see that the DLL's have been installed:
....
>
>
> I see a dialog box saying:
>
> This application could not start because cygpq.dll was not found

Ensure you have /usr/bin/cygpg.dll
It must be in the path, not in /usr/local/pgsql/lib/ because it's
resolved by the Win32 process loader, not by cygwin.

> Do you have any ideas?
>
> postgresql-8.0.1
> CYGWIN_NT-5.1 Cognia-brian 1.5.13(0.122/4/2) 2005-03-01 11:01 i686 unknown
> unknown Cygwin
> Windows XP
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
http://phpwiki.org

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Jason Tishler

2005-04-11, 7:25 am

Brian,

On Wed, Apr 06, 2005 at 09:44:10PM -0400, Brian Osborne wrote:
> To whom it may concern,
>
> I ran the configure and make and make install commands, everything seemed to
> be fine. I can see that the DLL's have been installed:
>
> 153 ~/src/postgresql-8.0.1>find /usr/local/pgsql/ -name '*dll'
> /usr/local/pgsql/lib/ascii_and_mic.dll
> /usr/local/pgsql/lib/cygpq.dll
> [snip]
>
> However, when I run:
>
>
> I see a dialog box saying:
>
> This application could not start because cygpq.dll was not found
>
> Do you have any ideas?

The simplest solution is to add /usr/local/pgsql/lib to your PATH.

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Brian Osborne

2005-04-12, 3:24 am

Reini,

Yes, that's it, it must be in PATH.

Thanks again,

BIO

-----Original Message-----
From: Reini Urban [mailto:rurban@x-ray.at]
Sent: Monday, April 11, 2005 2:00 AM
To: Brian Osborne
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Cygwin problem, compiling from source

Brian Osborne schrieb:
> To whom it may concern,
>
> I ran the configure and make and make install commands, everything seemed
to
> be fine. I can see that the DLL's have been installed:
....
>
>
> I see a dialog box saying:
>
> This application could not start because cygpq.dll was not found

Ensure you have /usr/bin/cygpg.dll
It must be in the path, not in /usr/local/pgsql/lib/ because it's
resolved by the Win32 process loader, not by cygwin.

> Do you have any ideas?
>
> postgresql-8.0.1
> CYGWIN_NT-5.1 Cognia-brian 1.5.13(0.122/4/2) 2005-03-01 11:01 i686 unknown
> unknown Cygwin
> Windows XP
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
http://phpwiki.org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Brian Osborne

2005-04-12, 3:24 am

Jason,

Yes, that did it.

Thanks again,

Brian O.

-----Original Message-----
From: Jason Tishler [mailto:jason@tishle
r.net]
Sent: Monday, April 11, 2005 8:36 AM
To: Brian Osborne
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Cygwin problem, compiling from source

Brian,

On Wed, Apr 06, 2005 at 09:44:10PM -0400, Brian Osborne wrote:
> To whom it may concern,
>
> I ran the configure and make and make install commands, everything seemed
to
> be fine. I can see that the DLL's have been installed:
>
> 153 ~/src/postgresql-8.0.1>find /usr/local/pgsql/ -name '*dll'
> /usr/local/pgsql/lib/ascii_and_mic.dll
> /usr/local/pgsql/lib/cygpq.dll
> [snip]
>
> However, when I run:
>
>
> I see a dialog box saying:
>
> This application could not start because cygpq.dll was not found
>
> Do you have any ideas?

The simplest solution is to add /usr/local/pgsql/lib to your PATH.

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sponsored Links