Re: PostgreSQL 11.4 Availability

[Marco Atzeri]

Am 01.07.2019 um 14:51 schrieb Marco Atzeri:

Am 28.06.2019 um 01:30 schrieb Yaakov (Cygwin Ports):

On Thu, 2019-06-27 at 17:47 +, Stevenson, Bob [US] (MS) wrote:

Are there plans to make the postgresql 11.4 packages available to the
Cygwin community?


https://cygwin.com/faq/faq.html#faq.using.old-packages

--
Yaakov



building of 11.4 underway.

I am currently in slow mode due to personal priority.

Regards
Marco



unfortunately some test failures appeared, so I will need
time to understand what happened between last 11.2 build
and current version.

Regards
Marco


---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL 11.4 Availability

[Marco Atzeri]

Am 28.06.2019 um 01:30 schrieb Yaakov (Cygwin Ports):

On Thu, 2019-06-27 at 17:47 +, Stevenson, Bob [US] (MS) wrote:

Are there plans to make the postgresql 11.4 packages available to the Cygwin 
community?


https://cygwin.com/faq/faq.html#faq.using.old-packages

--
Yaakov



building of 11.4 underway.

I am currently in slow mode due to personal priority.

Regards
Marco

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL 11.4 Availability

[Yaakov (Cygwin Ports)]

On Thu, 2019-06-27 at 17:47 +, Stevenson, Bob [US] (MS) wrote:
> Are there plans to make the postgresql 11.4 packages available to the Cygwin 
> community?

https://cygwin.com/faq/faq.html#faq.using.old-packages

--
Yaakov


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: Postgresql 10.5 Availability

[Marco Atzeri]

Am 16.08.2018 um 21:15 schrieb Parker, Shaun [US] (MS):

Are there plans to make the postgresql 10.5 package available to the cygwin 
community?



It is now available

Regards
Marco

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: Postgresql 9.6.8 Availability

[Marco Atzeri]

On 08/03/2018 16:50, Parker, Shaun [US] (MS) wrote:

Are there plans to make the postgresql 9.6.8 package available to the cygwin 
community?



I am not currently supporting more than one generation of postgresql.
Any problem with version 10.3 (10.x) ?
Any specific reason to stay with  9.6.x ?

Regards
Marco

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Marco Atzeri]

can you stop to top post ?
The standard here is bottom post

On 22/03/2017 07:07, Francis ANDRE wrote:

BTW, why installing libpq-devel on Cygwin differs from Linux install


[FrancisANDRE@idefix include ]$uname -a
CYGWIN_NT-6.1-WOW idefix 2.7.0(0.306/5/3) 2017-02-12 13:13 i686 Cygwin
[FrancisANDRE@idefix ~ ]$find /usr/include -name "libpq*.*"
/usr/include/libpq/libpq-fs.h
/usr/include/libpq-events.h
/usr/include/libpq-fe.h
/usr/include/postgresql/internal/libpq-int.h
/usr/include/postgresql/server/libpq/libpq-be.h
/usr/include/postgresql/server/libpq/libpq-fs.h
/usr/include/postgresql/server/libpq/libpq.h
/usr/include/pqxx/internal/libpq-forward.hxx


while on Ubuntu for exemple, one have

/usr/include/postgresql/internal/c.h
/usr/include/postgresql/internal/libpq-int.h
/usr/include/postgresql/internal/libpq/pqcomm.h
/usr/include/postgresql/internal/port.h
/usr/include/postgresql/internal/postgres_fe.h
/usr/include/postgresql/internal/pqexpbuffer.h
/usr/include/postgresql/libpq-events.h
/usr/include/postgresql/libpq-fe.h
/usr/include/postgresql/libpq/libpq-fs.h
/usr/include/postgresql/pg_config.h
/usr/include/postgresql/pg_config_ext.h
/usr/include/postgresql/pg_config_manual.h
/usr/include/postgresql/pg_config_os.h
/usr/include/postgresql/postgres_ext.h



I am not changing anything from default source
settings about installation

May be Ubuntu is changing that.



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Francis ANDRE]

BTW, why installing libpq-devel on Cygwin differs from Linux install


[FrancisANDRE@idefix include ]$uname -a
CYGWIN_NT-6.1-WOW idefix 2.7.0(0.306/5/3) 2017-02-12 13:13 i686 Cygwin
[FrancisANDRE@idefix ~ ]$find /usr/include -name "libpq*.*"
/usr/include/libpq/libpq-fs.h
/usr/include/libpq-events.h
/usr/include/libpq-fe.h
/usr/include/postgresql/internal/libpq-int.h
/usr/include/postgresql/server/libpq/libpq-be.h
/usr/include/postgresql/server/libpq/libpq-fs.h
/usr/include/postgresql/server/libpq/libpq.h
/usr/include/pqxx/internal/libpq-forward.hxx


while on Ubuntu for exemple, one have

/usr/include/postgresql/internal/c.h
/usr/include/postgresql/internal/libpq-int.h
/usr/include/postgresql/internal/libpq/pqcomm.h
/usr/include/postgresql/internal/port.h
/usr/include/postgresql/internal/postgres_fe.h
/usr/include/postgresql/internal/pqexpbuffer.h
/usr/include/postgresql/libpq-events.h
/usr/include/postgresql/libpq-fe.h
/usr/include/postgresql/libpq/libpq-fs.h
/usr/include/postgresql/pg_config.h
/usr/include/postgresql/pg_config_ext.h
/usr/include/postgresql/pg_config_manual.h
/usr/include/postgresql/pg_config_os.h
/usr/include/postgresql/postgres_ext.h


Le 20/03/2017 à 12:02, Marco Atzeri a écrit :
> On 20/03/2017 11:26, Francis ANDRE wrote:
>> I am not asking for changing the packaging or the package name... just
>> to display it in the window when searching for "postgres"
>>
>
> the search is based on the package name
>
>
>>
>> Le 20/03/2017 à 11:01, Marco Atzeri a écrit :
>>> reply on mailing list.
>>>
>>> On 20/03/2017 10:26, Francis ANDRE wrote:
 It would be nice to add the libpq-devel package when looking for
 postgres as it is missing (see below)

>>>
>>> the package is called in the same way on major Linux
>>> distributions.
>>>
>>> I will not change it.
>>>
>>> Regards
>>> Marco
>>>
>
> -- 
> Problem reports:   http://cygwin.com/problems.html
> FAQ:   http://cygwin.com/faq/
> Documentation: http://cygwin.com/docs.html
> Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
>
>


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Marco Atzeri]

On 20/03/2017 11:26, Francis ANDRE wrote:

I am not asking for changing the packaging or the package name... just
to display it in the window when searching for "postgres"



the search is based on the package name




Le 20/03/2017 à 11:01, Marco Atzeri a écrit :

reply on mailing list.

On 20/03/2017 10:26, Francis ANDRE wrote:

It would be nice to add the libpq-devel package when looking for
postgres as it is missing (see below)



the package is called in the same way on major Linux
distributions.

I will not change it.

Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Francis ANDRE]

I am not asking for changing the packaging or the package name... just
to display it in the window when searching for "postgres"


Le 20/03/2017 à 11:01, Marco Atzeri a écrit :
> reply on mailing list.
>
> On 20/03/2017 10:26, Francis ANDRE wrote:
>> It would be nice to add the libpq-devel package when looking for
>> postgres as it is missing (see below)
>>
>
> the package is called in the same way on major Linux
> distributions.
>
> I will not change it.
>
> Regards
> Marco
>
>
> -- 
> Problem reports:   http://cygwin.com/problems.html
> FAQ:   http://cygwin.com/faq/
> Documentation: http://cygwin.com/docs.html
> Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
>
>


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Marco Atzeri]

reply on mailing list.

On 20/03/2017 10:26, Francis ANDRE wrote:

It would be nice to add the libpq-devel package when looking for
postgres as it is missing (see below)



the package is called in the same way on major Linux
distributions.

I will not change it.

Regards
Marco


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-client-9.6.2-1: Where is the libpq-fe.h include?

[Marco Atzeri]

On 20/03/2017 08:52, Francis ANDRE wrote:

Hi

I installed both the file:

//C:/cygwin/var/cache/setup/http%3a%2f%2fcygwin.mirror.constant.com%2f/x86/release/postgresql/postgresql-client/postgresql-client-9.6.2-1.tar.xz

and the file

 
file://C:/cygwin/var/cache/setup/http%3a%2f%2fcygwin.mirror.constant.com%2f/x86/release/postgresql/postgresql-devel/postgresql-devel-9.6.2-1.tar.xz

but none of these installations provide the libpq-fe.h include.

[FrancisANDRE@idefix ~ ]$find /usr/include -name "*libpq-*.*"
/usr/include/postgresql/server/libpq/libpq-be.h
/usr/include/postgresql/server/libpq/libpq-fs.h

How can I get this include?

Thank for any pointer.

FA



Use "https://cygwin.com/packages/; or "cygcheck -p  libpq-fe.h"

As you can see from:
https://cygwin.com/cgi-bin2/package-grep.cgi?grep=libpq-fe.h=x86_64

you need to install libpq-devel-9.6.2-1

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql - Cannot initialize new Postgres database on Cygwin - Super User

[Marco Atzeri]

On 11/01/2017 23:02, Chloe wrote:

When I try to initialize a new database, I get an error:

$ /usr/sbin/pg_ctl init
no data was returned by command ""/usr/sbin/initdb.exe" -V"
The program "initdb" is needed by pg_ctl but was not found in the
same directory as "/usr/sbin/pg_ctl".
Check your installation.

$ /usr/sbin/initdb.exe -V
initdb (PostgreSQL) 9.6.1

$ "/usr/sbin/initdb.exe" -V
initdb (PostgreSQL) 9.6.1

$ /usr/sbin/initdb.exe -D /usr/share/postgresql
no data was returned by command ""/usr/sbin/postgres.exe" -V"
The program "postgres" is needed by initdb but was not found in the
same directory as "/usr/sbin/initdb".
Check your installation.

$ /usr/sbin/postgres -V
postgres (PostgreSQL) 9.6.1

Cygwin 2.6.1, Postgres 9.6.1


http://superuser.com/questions/1166177/cannot-initialize-new-postgres-database-on-cygwin



Inizialization works for me

$ cygrunsrv -S cygserver

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

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 30
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... sysv
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

pg_ctl -D /usr/local/pgsql/data -l logfile start

$ pg_ctl -D /usr/local/pgsql/data -l logfile start
server starting

$ psql -l
  List of databases
   Name| Owner | Encoding |   Collate   |Ctype| Access 
privileges

---+---+--+-+-+---
 postgres  | marco | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
 template0 | marco | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/marco 
 +

   |   |  | | | marco=CTc/marco
 template1 | marco | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/marco 
 +

   |   |  | | | marco=CTc/marco
(3 rows)


can you provide your cygcheck.out ?
https://www.cygwin.com/problems.html

Regards
Marco





--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: missing catalog/genbki.h server header

[Marco Atzeri]

On 26/08/2016 11:57, Marco Atzeri wrote:

On 25/08/2016 23:15, Yaakov Selkowitz wrote:

Marco,

Just ran into the following on both arches:

In file included from
qt-x11-free-3.3.8b/src/sql/drivers/psql/qsql_psql.cpp:61:0:
/usr/include/postgresql/server/catalog/pg_type.h:22:28: fatal error:
catalog/genbki.h: No such file or directory

Looks like this header needs to be moved from postgresql-devel to
libpq-devel.




Noted.
It seems also debian has doubts on where to put this header

https://packages.debian.org/search?suite=sid=contents=genbki.h


Regards
Marco


looking at latest debian 9.6 split
it seems I should move all
/usr/include/postgresql/server
under postgresql-devel.

$ grep "usr/include/" *
libecpg-dev.install:usr/include/postgresql/ecpg*.h
libecpg-dev.install:usr/include/postgresql/informix/*
libecpg-dev.install:usr/include/postgresql/pgtypes_*.h
libecpg-dev.install:usr/include/postgresql/sql3types.h
libecpg-dev.install:usr/include/postgresql/sqlca.h
libecpg-dev.install:usr/include/postgresql/sqlda*.h
libpq-dev.install:usr/include/postgresql/internal/*
libpq-dev.install:usr/include/postgresql/libpq-fe.h
libpq-dev.install:usr/include/postgresql/libpq-events.h
libpq-dev.install:usr/include/postgresql/libpq/libpq-fs.h
libpq-dev.install:usr/include/postgresql/pg_config*.h
libpq-dev.install:usr/include/postgresql/postgres_ext.h
postgresql-server-dev-9.6.install:usr/include/postgresql/*/server

and realign a bit the other headers.

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: missing catalog/genbki.h server header

[Marco Atzeri]

On 25/08/2016 23:15, Yaakov Selkowitz wrote:

Marco,

Just ran into the following on both arches:

In file included from
qt-x11-free-3.3.8b/src/sql/drivers/psql/qsql_psql.cpp:61:0:
/usr/include/postgresql/server/catalog/pg_type.h:22:28: fatal error:
catalog/genbki.h: No such file or directory

Looks like this header needs to be moved from postgresql-devel to
libpq-devel.




Noted.
It seems also debian has doubts on where to put this header

https://packages.debian.org/search?suite=sid=contents=genbki.h

Regards
Marco

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault

[Marco Atzeri]

On 04/04/2016 21:49, Chloe wrote:

Can you please change the Postgres packages to use postgres94,
postgres95, postgres96, etc. names? Each version is incompatible with
the previous. This will allow installing Postgres in separate binary
directories to enable upgrades. Alternatively, please increase the
'previous version' history to allow installing old versions. Setup only
has 1 previous version, and if the current version is 9.5.2 and the
previous version is 9.5.1, then there is no way (or very difficult) to
install 9.4!


Hi Chloe,

setup can only manage 1 previous version anyway.

postgres94, postgres95, postgres96 solution will force me to maintain
multiple versions, and I have not the bandwith to manage that.


http://serverfault.com/questions/532379/how-do-i-upgrade-postgres-database-in-cygwin


I uploaded again the 9.4.5 previous version at
  http://matzeri.altervista.org/

You can use that for downgrade your installation.

Regards
Marco

PS: I suggest you to subscribe
https://www.cygwin.com/ml/cygwin-announce/
(from https://www.cygwin.com/cygwin/lists.html )

so that future upgrade won't catch you by surprise anymore.




--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault

[Warren Young]

On Apr 4, 2016, at 2:02 PM, Marco Atzeri  wrote:
> 
> On 04/04/2016 21:46, Chloe wrote:
>> 
>> $ /usr/sbin/postgres
>> FATAL:  could not create shared memory segment: Function not implemented
>> DETAIL:  Failed system call was shmget(key=5432001, size=40, 03600).
> 
> The shared memory capability depends on cygserver.
> https://cygwin.com/cygwin-ug-net/using-cygserver.html

Also: https://cygwin.com/cygwin-api/std-notes.html

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault

[Marco Atzeri]

On 04/04/2016 21:46, Chloe wrote:

OK now I really need help. I tried to install version 9.4.4-2 of
Postgres with
ftp://www.fruitbat.org/pub/cygwin/circa/2015/09/25/151012/index.html,
but now it won't start. I also tried to install 9.4.4-1 but that won't
work either. I also tried to exit all Cygwin processes and run 'dash'
and 'rebaseall', but it didn't help. How do I install an old version of
Postgres 9.4 to upgrade to 9.5?

$ /usr/sbin/postgres --version
postgres (PostgreSQL) 9.4.4

$ /usr/sbin/postgres
FATAL:  could not create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=5432001, size=40, 03600).


have you configured cygserver as service and run it ?

The shared memory capability depends on cygserver.
https://cygwin.com/cygwin-ug-net/using-cygserver.html

Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql - How do I upgrade Postgres database in Cygwin? - Server Fault

[Chloe]

OK now I really need help. I tried to install version 9.4.4-2 of
Postgres with
ftp://www.fruitbat.org/pub/cygwin/circa/2015/09/25/151012/index.html,
but now it won't start. I also tried to install 9.4.4-1 but that won't
work either. I also tried to exit all Cygwin processes and run 'dash'
and 'rebaseall', but it didn't help. How do I install an old version of
Postgres 9.4 to upgrade to 9.5?

$ /usr/sbin/postgres --version
postgres (PostgreSQL) 9.4.4

$ /usr/sbin/postgres
FATAL:  could not create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=5432001, size=40, 03600).

$ /setup-x86 -X -q -P postgresql-9.4.4-1
note: Hand installation over to elevated child process.

$ /usr/sbin/postgres --version
postgres (PostgreSQL) 9.4.4

$ /usr/sbin/postgres
FATAL:  could not create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=5432001, size=40, 03600).

http://stackoverflow.com/questions/36411485/how-do-i-install-postgres-9-4-on-cygwin


On 4/4/2016 3:19 PM, Chloe wrote:
> Can you please change the Postgres packages to use postgres94,
> postgres95, postgres96, etc. names? Each version is incompatible with
> the previous. This will allow installing Postgres in separate binary
> directories to enable upgrades. Alternatively, please increase the
> 'previous version' history to allow installing old versions. Setup
> only has 1 previous version, and if the current version is 9.5.2 and
> the previous version is 9.5.1, then there is no way (or very
> difficult) to install 9.4!
>
> http://serverfault.com/questions/532379/how-do-i-upgrade-postgres-database-in-cygwin
>




signature.asc
Description: OpenPGP digital signature

Re: postgresql: use system tzcode

[Marco Atzeri]

On 11/16/2014 9:09 AM, Yaakov Selkowitz wrote:

Marco,

Currently, postgresql ships with a bundled (and old) version of tzdata.
  Instead, could you configure postgresql with
--with-system-tzdata=/usr/share/zoneinfo and add tzcode to
postgresql_REQUIRES?

--
Yaakov


done with 9.4.0-1

Regards
Marco

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 16/06/2014 22:24 +0200, Marco Atzeri wrote:

 On 16/06/2014 19:04, Filipp Gunbin wrote:
 On 27/07/2013 09:57 +0200, marco atzeri wrote:

 Currently postgres with ossp-uuid module (--with-ossp-uuid added to
 CYGCONF_ARGS) builds with OSSP uuid library
 (http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
 included in util-linux.  I do not have enough skills to identify
 problem, but it seems that function uuid_export is missing there.
 Maybe the OSSP uuid library needs to be added as a separate package in
 Cygwin?  It builds from original source with no patches.


 It seems that uuid-ossp and util-linux uuid are two complete
 not compatible libraries.

Yes.

 Anyway, until someone add the uuid-ossp package on cygwin,
 I will not add such dependency on postgres

I tried to prepare a package for uuid-ossp, but the result files produce
naming conflicts with libuuid and I don't know how to resolve them.  If
someone helps me, I'm willing to continue.

If someone just needs the uuid-ossp postgresql extension, here's the
ugly solution:

1. make  make install uuid-ossp library (it will install into
/usr/local)

2. add --with-ossp-uuid to CYGCONF_ARGS and build Cygwin postgresql

3. just copy uuid-related files from inst subdirectory to the postgres
directory

4. CREATE EXTENSION uuid-ossp now should work


Thanks Marco.

Filipp

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 27/07/2013 09:57 +0200, marco atzeri wrote:

 Il 7/27/2013 9:25 AM, Filipp Gunbin ha scritto:
 On 26/07/2013 19:02 +0400, marco atzeri wrote:

 Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
 Hello again,

 It would be useful to include uuid-ossp module in the default
 distribution.  Here's a patch which does that.

 The mailing list filters didn't like the PACKAGE_BUGREPORT=... line
 with email address just before the patched line, so I had to set context
 lines to 0.

 Filipp



 noted. There is any additional dependency for that ?

 Marco

 Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
 Cygwin's libuuid1 or libuuid-devel modules installed.

 that is a problem. We need to understand why

Returning to this old problem,

Currently postgres with ossp-uuid module (--with-ossp-uuid added to
CYGCONF_ARGS) builds with OSSP uuid library
(http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
included in util-linux.  I do not have enough skills to identify
problem, but it seems that function uuid_export is missing there.
Maybe the OSSP uuid library needs to be added as a separate package in
Cygwin?  It builds from original source with no patches.


 The correct files are in my /usr/local so I remembered I built libuuid
 specially for postgres.  I'll try to clarify what is required.

That was OSSP uuid library in my /usr/local, clearly.

Filipp

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Marco Atzeri]

On 16/06/2014 19:04, Filipp Gunbin wrote:

On 27/07/2013 09:57 +0200, marco atzeri wrote:




Returning to this old problem,

Currently postgres with ossp-uuid module (--with-ossp-uuid added to
CYGCONF_ARGS) builds with OSSP uuid library
(http://www.ossp.org/pkg/lib/uuid/), but not with libuuid which is
included in util-linux.  I do not have enough skills to identify
problem, but it seems that function uuid_export is missing there.
Maybe the OSSP uuid library needs to be added as a separate package in
Cygwin?  It builds from original source with no patches.



It seems that uuid-ossp and util-linux uuid are two complete
not compatible libraries.

http://stackoverflow.com/questions/2566964/uuid-library-for-c


The correct files are in my /usr/local so I remembered I built libuuid
specially for postgres.  I'll try to clarify what is required.


That was OSSP uuid library in my /usr/local, clearly.

Filipp


Anyway, until someone add the uuid-ossp package on cygwin,
I will not add such dependency on postgres

Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql missing pg_restore executable?

[David Stacey]

On 05/03/14 20:17, Jim Garrison wrote:

I may be missing something obvious, but I can find pg_restore anywhere.


Cygwin puts pg_restore in /usr/sbin/

*
Cheers,

Dave.

*


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[Filipp Gunbin]

On 26/07/2013 19:02 +0400, marco atzeri wrote:

 Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:
 Hello again,

 It would be useful to include uuid-ossp module in the default
 distribution.  Here's a patch which does that.

 The mailing list filters didn't like the PACKAGE_BUGREPORT=... line
 with email address just before the patched line, so I had to set context
 lines to 0.

 Filipp



 noted. There is any additional dependency for that ?

 Marco

Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
Cygwin's libuuid1 or libuuid-devel modules installed.

The correct files are in my /usr/local so I remembered I built libuuid
specially for postgres.  I'll try to clarify what is required.

Filipp

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[marco atzeri]

Il 7/27/2013 9:25 AM, Filipp Gunbin ha scritto:

On 26/07/2013 19:02 +0400, marco atzeri wrote:


Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:

Hello again,

It would be useful to include uuid-ossp module in the default
distribution.  Here's a patch which does that.

The mailing list filters didn't like the PACKAGE_BUGREPORT=... line
with email address just before the patched line, so I had to set context
lines to 0.

Filipp




noted. There is any additional dependency for that ?

Marco


Oh yes, it's libuuid, and unfortunately ossp-uuid does not build with
Cygwin's libuuid1 or libuuid-devel modules installed.


that is a problem. We need to understand why



The correct files are in my /usr/local so I remembered I built libuuid
specially for postgres.  I'll try to clarify what is required.

Filipp



Marco

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: manual is not included in the package

[marco atzeri]

Il 7/26/2013 1:26 PM, Filipp Gunbin ha scritto:

Hello,

I see that the manual is not built during the make process in the doc
directory.  Of course it is missing in the result packages.  I tried
changing cygmake to cygmake world in cygport file, but it didn't
help.  Is there a way to build it?

It would be great to include it by default in the postgresql-doc
package.

Thanks.




I assume you mean HTML documentation as man is available

$ cygcheck -l postgresql |grep \/man\/
/usr/share/man/man1/initdb.1.gz
/usr/share/man/man1/pg_controldata.1.gz
/usr/share/man/man1/pg_ctl.1.gz
/usr/share/man/man1/pg_resetxlog.1.gz
/usr/share/man/man1/postgres.1.gz
/usr/share/man/man1/postmaster.1.gz

$ cygcheck -l postgresql-client |grep \/man\/
/usr/share/man/man1/clusterdb.1.gz
/usr/share/man/man1/createdb.1.gz
/usr/share/man/man1/createlang.1.gz
/usr/share/man/man1/createuser.1.gz
/usr/share/man/man1/dropdb.1.gz
..
/usr/share/man/man7/TRUNCATE.7.gz
/usr/share/man/man7/UNLISTEN.7.gz
/usr/share/man/man7/UPDATE.7.gz
/usr/share/man/man7/VACUUM.7.gz
/usr/share/man/man7/VALUES.7.gz
/usr/share/man/man7/WITH.7.gz


For HTML version, I will look for next 9.3 release

Regards
Marco




--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: ossp-uuid module

[marco atzeri]

Il 7/26/2013 2:17 PM, Filipp Gunbin ha scritto:

Hello again,

It would be useful to include uuid-ossp module in the default
distribution.  Here's a patch which does that.

The mailing list filters didn't like the PACKAGE_BUGREPORT=... line
with email address just before the patched line, so I had to set context
lines to 0.

Filipp




noted. There is any additional dependency for that ?

Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: manual is not included in the package

[Filipp Gunbin]

Hello Marco,

On 26/07/2013 18:58 +0400, marco atzeri wrote:

 I assume you mean HTML documentation as man is available

Yes.  The postgresql.org site calls the html docs manual, that's why I
used that word.  Man pages are present.

 For HTML version, I will look for next 9.3 release

For me it would be ok to build it locally, but currently I can't find a
way to do it.

Filipp

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-9.2.4-2: manual is not included in the package

[marco atzeri]

Il 7/26/2013 5:36 PM, Filipp Gunbin ha scritto:

Hello Marco,

On 26/07/2013 18:58 +0400, marco atzeri wrote:


I assume you mean HTML documentation as man is available


Yes.  The postgresql.org site calls the html docs manual, that's why I
used that word.  Man pages are present.


For HTML version, I will look for next 9.3 release


For me it would be ok to build it locally, but currently I can't find a
way to do it.

Filipp



I suspect it needs the sgml files in the build tree.
Currently the source and build tree are separated
for the package

Marco





--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[Danjel McGougan]

On 2013-06-08 15:01, marco atzeri wrote:
 Il 6/7/2013 7:27 AM, Yaakov (Cygwin/X) ha scritto:
 On 2013-06-06 14:55, marco atzeri wrote:
 Il 6/6/2013 9:30 PM, Yaakov (Cygwin/X) ha scritto:
 libpq.a was always an import library for the libpq DLL, but in
 libpq-devel-9.2.4-1, it is an ordinary static library, but there is no
 libpq.dll.a implib either.  Could you please fix this?

 give me some time to review again the unusal postgresql
 build system.
 When I patched to remove the dlltool/dllwrap I probably forgot something

 While you're at it, is the 9.x libpq DLL really ABI compatible with the
 8.x version?  I haven't analyzed them, but just from history, I wouldn't
 be surprised if it wasn't, in which case the DLL really needs to be
 versioned so it doesn't collide with the old, unversioned 8.x DLL.

 
 libqp seems so, major version 5 is unchanged.
 Most of the others no.
 

 Yaakov
 
 I uploaded a test version, here
 http://matzeri.altervista.org/32bit/postgresql/
 
 that should solve the issue and have the dll versioning,
 plus I removed the last trace of dlltool/dllwrap usage.
 
 Could you please test before I replace all the others 9.2.x version ?
 
 
 To download
 wget -r -np -nH --cut-dirs=1 \
 http://matzeri.altervista.org/32bit/postgresql/index.html
 
 find postgresql -name index.html -o -name md5.sum | xargs rm
 

It seems the latest libpq5 (9.2.4-2) installs /bin/cygpq-5.dll, but at least 
xemacs fails to find this lib (it looks for cygpq.dll) and fails to load. 
Downgrading libpq5 to 8.2.11-1 solves the xemacs issue for me. Before I 
downgraded I tried to symlink cygpq.dll to cygpq-5.dll, but this caused xemacs 
to silently fail to start. So I gather libpq 9 is not binary compatible with 
libpq 8. 

BR,
Danjel McGougan


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[Yaakov (Cygwin/X)]

On 2013-06-13 03:08, Danjel McGougan wrote:

It seems the latest libpq5 (9.2.4-2) installs /bin/cygpq-5.dll, but at
least xemacs fails to find this lib (it looks for cygpq.dll) and fails
to load. Downgrading libpq5 to 8.2.11-1 solves the xemacs issue for me.


Marco,

While I'm glad to finally have properly versioned PostgreSQL DLLs, we do 
need to worry about not breaking everything in the distro (and Ports) 
which is linked against the old, unversioned cygpq.dll.


I suggest renaming the old libpq5-8.x packages on sourceware to libpq, 
and changing all libpq5 deps in the distro to libpq, namely for:


algol68g
clisp
libQtSql4
libsasl2-sql
odbc-psql
xemacs

Can you take care of this, or shall I?


Before I downgraded I tried to symlink cygpq.dll to cygpq-5.dll, but this
caused xemacs to silently fail to start.


The Windows runtime linker doesn't understand symlinks, so that wouldn't 
have worked.



Yaakov


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[marco atzeri]

Il 6/13/2013 11:19 AM, Yaakov (Cygwin/X) ha scritto:

On 2013-06-13 03:08, Danjel McGougan wrote:

It seems the latest libpq5 (9.2.4-2) installs /bin/cygpq-5.dll, but at
least xemacs fails to find this lib (it looks for cygpq.dll) and fails
to load. Downgrading libpq5 to 8.2.11-1 solves the xemacs issue for me.


Marco,

While I'm glad to finally have properly versioned PostgreSQL DLLs, we do
need to worry about not breaking everything in the distro (and Ports)
which is linked against the old, unversioned cygpq.dll.

I suggest renaming the old libpq5-8.x packages on sourceware to libpq,
and changing all libpq5 deps in the distro to libpq, namely for:

algol68g
clisp
libQtSql4
libsasl2-sql
odbc-psql
xemacs

Can you take care of this, or shall I?


Done, please check nothing else is broken.




Before I downgraded I tried to symlink cygpq.dll to cygpq-5.dll, but this
caused xemacs to silently fail to start.


The Windows runtime linker doesn't understand symlinks, so that wouldn't
have worked.


Copying cygpq-5.dll to cygpq.dll should have worked.

As soon the solution proposed by Yaakov will spread to the mirrors,
setup should pick the right solution.




Yaakov


Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[marco atzeri]

Il 6/7/2013 7:27 AM, Yaakov (Cygwin/X) ha scritto:

On 2013-06-06 14:55, marco atzeri wrote:

Il 6/6/2013 9:30 PM, Yaakov (Cygwin/X) ha scritto:

libpq.a was always an import library for the libpq DLL, but in
libpq-devel-9.2.4-1, it is an ordinary static library, but there is no
libpq.dll.a implib either.  Could you please fix this?


give me some time to review again the unusal postgresql
build system.
When I patched to remove the dlltool/dllwrap I probably forgot something


While you're at it, is the 9.x libpq DLL really ABI compatible with the
8.x version?  I haven't analyzed them, but just from history, I wouldn't
be surprised if it wasn't, in which case the DLL really needs to be
versioned so it doesn't collide with the old, unversioned 8.x DLL.



libqp seems so, major version 5 is unchanged.
Most of the others no.



Yaakov


I uploaded a test version, here
http://matzeri.altervista.org/32bit/postgresql/

that should solve the issue and have the dll versioning,
plus I removed the last trace of dlltool/dllwrap usage.

Could you please test before I replace all the others 9.2.x version ?


To download
wget -r -np -nH --cut-dirs=1 \
http://matzeri.altervista.org/32bit/postgresql/index.html

find postgresql -name index.html -o -name md5.sum | xargs rm

Regards
Marco

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[marco atzeri]

Il 6/6/2013 9:30 PM, Yaakov (Cygwin/X) ha scritto:

Marco,

libpq.a was always an import library for the libpq DLL, but in
libpq-devel-9.2.4-1, it is an ordinary static library, but there is no
libpq.dll.a implib either.  Could you please fix this?


Yaakov


give me some time to review again the unusal postgresql
build system.
When I patched to remove the dlltool/dllwrap I probably forgot something

Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql: libpq.a not an import library

[Yaakov (Cygwin/X)]

On 2013-06-06 14:55, marco atzeri wrote:

Il 6/6/2013 9:30 PM, Yaakov (Cygwin/X) ha scritto:

libpq.a was always an import library for the libpq DLL, but in
libpq-devel-9.2.4-1, it is an ordinary static library, but there is no
libpq.dll.a implib either.  Could you please fix this?


give me some time to review again the unusal postgresql
build system.
When I patched to remove the dlltool/dllwrap I probably forgot something


While you're at it, is the 9.x libpq DLL really ABI compatible with the 
8.x version?  I haven't analyzed them, but just from history, I wouldn't 
be surprised if it wasn't, in which case the DLL really needs to be 
versioned so it doesn't collide with the old, unversioned 8.x DLL.



Yaakov


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Angelo Graziosi]

Christopher Faylor wrote:


Do you see linux64 and linux64 a lot?  No?

It should just be cygwin.


if you read the citation [*], you will find,

...
linuxfor i386 Linux with gcc = 3
linuxicc for i386 Linux with Intel's icc
...
linuxppcgcc  for PPC Linux with gcc
linuxppc64gccfor PPC 64 Linux  with gcc = 3
linuxx8664gccfor x86-64 Linux with gcc = 3.x
linuxx8664iccfor x86-64 Linux with Intel icc =10.x
...
macosx   for MacOS X = 10.4 with gcc
macosxiccfor MacOS X = 10.4 with Intel icc (Intel only)
macosx64 for MacOS X = 10.5 with gcc 4.0 64 bit mode

...


The first public release of ROOT was in 1995. Perhaps at that time they 
thought that 'win32gcc' was enough...


Anyway, I will try to suggest that they change the option in cygwin..


Ciao,
 Angelo.

---
[*] http://cygwin.com/ml/cygwin/2013-05/msg00013.html

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Andrey Repin]

Greetings, Angelo Graziosi!

 win32gcc for Win32 with cygwin/gcc

Cygwin gcc? Or mingw gcc? Or, ... ?
In short, ... yeah, what Earnie Boyd said earlier. Just plain wrong.


--
WBR,
Andrey Repin (anrdae...@freemail.ru) 02.05.2013, 21:29

Sorry for my terrible english...


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Angelo Graziosi]

Il 02/05/2013 19.30, Andrey Repin ha scritto:

Greetings, Angelo Graziosi!


 win32gcc for Win32 with cygwin/gcc


Cygwin gcc? Or mingw gcc? Or, ... ?
In short, ... yeah, what Earnie Boyd said earlier. Just plain wrong.




The Supported Architectures cited in [*] are configure options:

$ PATH-TO/configure win32gcc [...]   # for the Cygwin build

$ PATH-TO/configure win32 [...]  # for the Windows native build 
(using VC++)



For some historical reason, win32gcc identifies Cygwin. Probably, 
these days, they should change the option to cygwin  (better: 
cygwin32 or cygwin64, in view of Cygwin development)


I am building ROOT on Cygwin since 2003. Usually the build on Cygwin 
results in these features:


$ root-config --features
asimage astiff builtin_afterimage builtin_ftgl builtin_glew builtin_zlib 
cintex explicitlink fftw3 gdml genvector ldap mathmore minuit2 mysql 
odbc opengl pgsql pythia6 python qt qtgsi reflex roofit ruby shared 
soversion ssl table tmva unuran x11 xft xml thread


The next generation of ROOT (ROOT 6) will use clang++ (possibly 
bootstrapping it if it isn't found...)


For what I know, they dont't use Mingw.


Ciao,
 Angelo.


---
[*] http://cygwin.com/ml/cygwin/2013-05/msg00013.html


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Christopher Faylor]

On Thu, May 02, 2013 at 11:24:44PM +0200, Angelo Graziosi wrote:
Il 02/05/2013 19.30, Andrey Repin ha scritto:
 Greetings, Angelo Graziosi!

  win32gcc for Win32 with cygwin/gcc

 Cygwin gcc? Or mingw gcc? Or, ... ?
 In short, ... yeah, what Earnie Boyd said earlier. Just plain wrong.



The Supported Architectures cited in [*] are configure options:

$ PATH-TO/configure win32gcc [...]   # for the Cygwin build

$ PATH-TO/configure win32 [...]  # for the Windows native build 
(using VC++)

Do you see linux64 and linux64 a lot?  No?

It should just be cygwin.

cgf

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[marco atzeri]

On 4/30/2013 11:52 PM, Angelo Graziosi wrote:

Jim Garrison wrote:

but had to add four library dependencies to the makefile, libssl,
libldap, libcrypto and libintl due to unresolved dependencies from libpq:



Just for the record, recently trying to build ROOT [*], I had problems
with libpq and postgresql- The ROOT build failed as

[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-connect.o): nella
funzione ldapServiceLookup:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3541:
riferimento non definito a _ldap_init
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3553:
riferimento non definito a _ldap_simple_bind
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3563:
riferimento non definito a _ldap_result
[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-misc.o): nella
funzione libpq_gettext:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-misc.c:1202:
riferimento non definito a _libintl_bindtextdomain
[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-secure.o): nella
funzione initialize_SSL:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-secure.c:1094:
riferimento non definito a _SSL_CTX_use_certificate_chain_file
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-secure.c:1104:
riferimento non definito a _SSL_use_certificate_file

 
  Not sure if I need to notify anybody of this...


looking at libpq5 dependency:

requires: libintl8 libopenldap2_4_2 libopenssl100 crypt openssl _autorebase

so likely you need the devel libs of some of that




Ciao,
  Angelo.


---
[*] http://root.cern.ch/drupal/content/patch-release-53407




--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Angelo Graziosi]

marco atzeri wrote:

looking at libpq5 dependency:

requires: libintl8 libopenldap2_4_2 libopenssl100 crypt openssl _autorebase

so likely you need the devel libs of some of that


No, I did a build a few week ago and it was completed.

If ROOT configure doesn't find the right headers and library files, it 
doesn't add support for that library in the build. I have all the needed 
libraries installed. It isn't the first time I build ROOT...


The tricks suggested by Jim Garrison 
(http://cygwin.com/ml/cygwin/2013-04/msg00507.html) works also for me. 
Adding on command line


-lssl -lldap -lcrypto -lintl

fixes the failure.

Let's see what ROOT guys think about this... ;-)


Ciao,
 Angelo.

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[marco atzeri]

On 5/1/2013 12:38 PM, Angelo Graziosi wrote:

marco atzeri wrote:

looking at libpq5 dependency:

requires: libintl8 libopenldap2_4_2 libopenssl100 crypt openssl
_autorebase

so likely you need the devel libs of some of that


No, I did a build a few week ago and it was completed.

If ROOT configure doesn't find the right headers and library files, it
doesn't add support for that library in the build. I have all the needed
libraries installed. It isn't the first time I build ROOT...

The tricks suggested by Jim Garrison
(http://cygwin.com/ml/cygwin/2013-04/msg00507.html) works also for me.
Adding on command line

-lssl -lldap -lcrypto -lintl


that are the devel lib of openssl, openldap, crypt and libintl8



fixes the failure.

Let's see what ROOT guys think about this... ;-)


I guess they do not support cygwin (and windows)



Ciao,
  Angelo.


Ciao
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Angelo Graziosi]

marco atzeri wrote:

I guess they do not support cygwin (and windows)


$ ./root/configure --help
[...]

Supported Architectures:
   aix5 for AIX 5.x with xlC
   aixgcc   for AIX 5.x with gcc = 3
   alphacxx6for DEC Unix with cxx6
   alphagcc for DEC Unix with gcc
   freebsd4 for FreeBSD 4.x with gcc
   freebsd5 for FreeBSD 5.x and 6.x with gcc
   freebsd7 for FreeBSD 7.x with gcc
   hpuxacc  for HP-UX 10.20 with HP aCC
   hpuxgcc  for HP-UX 10.20 with gcc
   hpuxia64acc  for HP-UX 11i v1.5 (IA-64) with HP aCC
   hurddeb  for Debian GNU/Hurd with gcc
   ios  for Apple iOS on armv7 device
   iossim   for Apple iOS on i386 simulator
   linuxfor i386 Linux with gcc = 3
   linuxicc for i386 Linux with Intel's icc
   linuxalphagccfor Alpha Linux with gcc
   linuxarm for ARM Linux with gcc
   linuxhppafor HPPA Linux with gcc
   linuxia64ecc for Itanium Linux with Intel icc
   linuxia64gcc for Itanium Linux with gcc = 3
   linuxmipsfor MIPS Linux with gcc
   linuxppcgcc  for PPC Linux with gcc
   linuxppc64gccfor PPC 64 Linux  with gcc = 3
   linuxx8664gccfor x86-64 Linux with gcc = 3.x
   linuxx8664iccfor x86-64 Linux with Intel icc =10.x
   linuxx8664k1omiccfor x86-64 Intel Many Integrated Cores Linux 
with Intel icc =13.x

   lynxos   for LynxOS with gcc
   macosx   for MacOS X = 10.4 with gcc
   macosxiccfor MacOS X = 10.4 with Intel icc (Intel only)
   macosx64 for MacOS X = 10.5 with gcc 4.0 64 bit mode
   openbsd  for OpenBSD = 3.7 with gcc
   sgiccfor SGI IRIX 6.x with CC
   sgicc64  for SGI IRIX 6.x with CC 64 bits
   sgigcc   for SGI IRIX 6.x with gcc
   sgin32gccfor SGI IRIX 6.4 with gcc using n32 ABI
   solaris  for Solaris with CC
   solarisCC5   for Solaris with CC 5.0
   solaris64CC5 for Solaris with CC 5.0 64 bits
   win32for Win32 with VC++ and gdk based GUI
   win32gcc for Win32 with cygwin/gcc


Ciao,
 Angelo.

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Earnie Boyd]

On Wed, May 1, 2013 at 10:44 AM, Angelo Graziosi wrote:
win32for Win32 with VC++ and gdk based GUI
win32gcc for Win32 with cygwin/gcc

That's just some bad juju.  What kind of witchcrafter came up with
these bad tokens?  Who in their right minds would think Cygwin oh,
yea, I use win32gcc?  Or if I have MSVC I use just win32?

-- 
Earnie
-- https://sites.google.com/site/earnieboyd

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Achim Gratz]

Jim Garrison writes:
 Any suggestions on how find pg_config so I can install DBD::Pg?

Entering pg_config.exe into the search box on this page will tell you to
install libpq-devel:

http://cygwin.com/packages/


Regards,
Achim.
-- 
+[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]+

Samples for the Waldorf Blofeld:
http://Synth.Stromeko.net/Downloads.html#BlofeldSamplesExtra


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

RE: postgresql-devel package missing pg_config?

[Jim Garrison]

 -Original Message-
 Behalf Of Achim Gratz
 Sent: Tuesday, April 30, 2013 12:59 PM
 Subject: Re: postgresql-devel package missing pg_config?
 
 Jim Garrison writes:
  Any suggestions on how find pg_config so I can install DBD::Pg?
 
 Entering pg_config.exe into the search box on this page will tell you to 
 install
 libpq-devel:
 
 http://cygwin.com/packages/

Thanks, that helped.

I successfully built DBD::Pg, but had to add four library dependencies to the 
makefile, libssl, libldap, libcrypto and libintl due to unresolved dependencies 
from libpq:

EXTRALIBS = -L/usr/lib -lpq -lm -lssl -lldap -lcrypto -lintl LDLOADLIBS = 
-L/usr/lib -lpq -lm -lssl -lldap -lcrypto -lintl

Not sure if I need to notify anybody of this...

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql-devel package missing pg_config?

[Angelo Graziosi]

Jim Garrison wrote:

but had to add four library dependencies to the makefile, libssl, libldap, 
libcrypto and libintl due to unresolved dependencies from libpq:



Just for the record, recently trying to build ROOT [*], I had problems 
with libpq and postgresql- The ROOT build failed as


[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-connect.o): nella 
funzione ldapServiceLookup:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3541: 
riferimento non definito a _ldap_init
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3553: 
riferimento non definito a _ldap_simple_bind
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-connect.c:3563: 
riferimento non definito a _ldap_result

[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-misc.o): nella 
funzione libpq_gettext:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-misc.c:1202: 
riferimento non definito a _libintl_bindtextdomain

[...]
/usr/lib/gcc/i686-pc-cygwin/4.5.3/../../../libpq.a(fe-secure.o): nella 
funzione initialize_SSL:
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-secure.c:1094: 
riferimento non definito a _SSL_CTX_use_certificate_chain_file
/pub/devel/postgresql/postgresql-9.2.4-1/src/postgresql-9.2.4/src/interfaces/libpq/fe-secure.c:1104: 
riferimento non definito a _SSL_use_certificate_file



 Not sure if I need to notify anybody of this...


Ciao,
 Angelo.


---
[*] http://root.cern.ch/drupal/content/patch-release-53407

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL, getting it up

[Corinna Vinschen]

On Mar 22 20:39, d. henman wrote:
 Marco, thanks for the direction. ($ cygrunsrv.exe -S cygserver )
 
 I might have tried $ cygrunsrv -s server   (without the cyg prefix)
 
 According to: /usr/share/doc/Cygwin/postgresql.README
cygrunsrv is not required anymore, pg_ctl has now the service
 functions included.
  cygserver must run as service, CYGWIN must contain server.
 
 That phrase cygrunsrv is not required anymore  threw me off.
 So the above is wrong in that it is needed to start cygserver.
 And the environment variable CYGWIN needs to contain the text, server in it.

CYGWIN=server is old and not needed anymore:

http://cygwin.com/cygwin-ug-net/using-cygwinenv.html#cygwinenv-removed-options


Corinna

-- 
Corinna Vinschen  Please, send mails regarding Cygwin to
Cygwin Maintainer cygwin AT cygwin DOT com
Red Hat

Re: PostgreSQL, getting it up

[marco atzeri]

On 3/22/2013 12:39 PM, d. henman wrote:

Marco, thanks for the direction. ($ cygrunsrv.exe -S cygserver )

I might have tried $ cygrunsrv -s server   (without the cyg prefix)

According to: /usr/share/doc/Cygwin/postgresql.README
cygrunsrv is not required anymore, pg_ctl has now the service
functions included.
  cygserver must run as service, CYGWIN must contain server.


I will look on the documentation;
I have not reviewed it for 9.x series as busy fighting other
serious issues



That phrase cygrunsrv is not required anymore  threw me off.
So the above is wrong in that it is needed to start cygserver.
And the environment variable CYGWIN needs to contain the text, server in it.

I'll try that.



Regards
Marco

Re: PostgreSQL not working from start

[marco atzeri]

On 3/22/2013 8:17 AM, Wynfield Henman wrote:

This is apparently a common problem.
I' m trying to install and get PostgreSQL up and running.

Yes, CYGWIN, the environment variable is set to server and file/dir
permissions are set for the user and have r/w permissions.

No matter if I use:

initdb or  pg_ctl initdb -D $DBDIR -l $DB_ADMINLOG -o -X $XLOGDIR
-U $DB_OWNER

No database is initialized and the Bad system call messages in a
downward counting loop of shared_buffers appears on the screen. ending
with]



have you started cygserver before ?

$ cygrunsrv.exe -S cygserver

If still it does not work, please follow:

Problem reports:   http://cygwin.com/problems.html



Run cygcheck -s -v -r  cygcheck.out and include that file as an 
attachment in your report. Please do not compress or otherwise encode 
the output. Just attach it as a straight text file so that it can be 
easily viewed. 


Regards
Marco



--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL plperl crash on Cygwin 1.7.5

[Andrew Dunstan]

Reini Urban wrote:

2010/5/2 Andrew Dunstan :
  

On Cygwin version 1.7.5 I am trying to run set up a member of the PostgreSQL
Buildfarm http://www.pgbuildfarm.org/cgi-bin/show_status.pl. We have a
current Cygwin member (run by me) using Cygwin version 1.5.25, which for the
most part runs without major problems.

The good news is that even on the latest code, both stable and development,
PostgreSQL builds and its core regression tests run with 100% success.

The bad news is that I get a segfault when trying to run the regression
tests for the embedded PLPerl language. The test fails when it tries to load
Postgres' plperl.dll.



Hi Andrew,

This is because cygwin perl is compiled with gcc-4 and -fstack-protector
and you are trying with gcc-3 without -fstack-protector.

Installing gcc-4 and doing the configure with
CC=gcc-4 should do the trick.

  


Can you please give a set of configure settings that will work? I have 
not been able to find one.


cheers

andrew

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL plperl crash on Cygwin 1.7.5

[Reini Urban]

2010/5/2 Andrew Dunstan :
 On Cygwin version 1.7.5 I am trying to run set up a member of the PostgreSQL
 Buildfarm http://www.pgbuildfarm.org/cgi-bin/show_status.pl. We have a
 current Cygwin member (run by me) using Cygwin version 1.5.25, which for the
 most part runs without major problems.

 The good news is that even on the latest code, both stable and development,
 PostgreSQL builds and its core regression tests run with 100% success.

 The bad news is that I get a segfault when trying to run the regression
 tests for the embedded PLPerl language. The test fails when it tries to load
 Postgres' plperl.dll.

Hi Andrew,

This is because cygwin perl is compiled with gcc-4 and -fstack-protector
and you are trying with gcc-3 without -fstack-protector.

Installing gcc-4 and doing the configure with
CC=gcc-4 should do the trick.

-- 
Reini Urban
perl and postgresql maintainer :)

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL plperl crash on Cygwin 1.7.5

[Andrew Dunstan]

Reini Urban wrote:

2010/5/2 Andrew Dunstan :
  

On Cygwin version 1.7.5 I am trying to run set up a member of the PostgreSQL
Buildfarm http://www.pgbuildfarm.org/cgi-bin/show_status.pl. We have a
current Cygwin member (run by me) using Cygwin version 1.5.25, which for the
most part runs without major problems.

The good news is that even on the latest code, both stable and development,
PostgreSQL builds and its core regression tests run with 100% success.

The bad news is that I get a segfault when trying to run the regression
tests for the embedded PLPerl language. The test fails when it tries to load
Postgres' plperl.dll.



Hi Andrew,

This is because cygwin perl is compiled with gcc-4 and -fstack-protector
and you are trying with gcc-3 without -fstack-protector.

Installing gcc-4 and doing the configure with
CC=gcc-4 should do the trick.

  


Oh, cool, thanks Reini. I'm testing this now.

If standard packages like perl are compiled with gcc-4, shouldn't it be 
the default?


cheers

andrew

--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: PostgreSQL plperl crash on Cygwin 1.7.5

[Andrew Dunstan]

Reini Urban wrote:

2010/5/2 Andrew Dunstan :
  

On Cygwin version 1.7.5 I am trying to run set up a member of the PostgreSQL
Buildfarm http://www.pgbuildfarm.org/cgi-bin/show_status.pl. We have a
current Cygwin member (run by me) using Cygwin version 1.5.25, which for the
most part runs without major problems.

The good news is that even on the latest code, both stable and development,
PostgreSQL builds and its core regression tests run with 100% success.

The bad news is that I get a segfault when trying to run the regression
tests for the embedded PLPerl language. The test fails when it tries to load
Postgres' plperl.dll.



Hi Andrew,

This is because cygwin perl is compiled with gcc-4 and -fstack-protector
and you are trying with gcc-3 without -fstack-protector.

Installing gcc-4 and doing the configure with
CC=gcc-4 should do the trick.

  


Sadly, this doesn't fix it. And if I add  CFLAGS=-fstack-protector to 
the build it doesn't even finish linking let alone run. I get errors like:


   /home/Andrew/bf/root/HEAD/pgsql.1428/src/interfaces/libpq/fe-auth.c:967:
   undefined reference to `___stack_chk_guard'

cheers

andrew


--
Problem reports:   http://cygwin.com/problems.html
FAQ:   http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple

Re: postgresql

[Reini Urban]

Marco Atzeri schrieb:

--- Stephen Gallaghan  ha scritto:

Hi
I am trying to connect to a remote (on local lan)
postgresql server 
using cygwin.

When I try to run the psql program I am getting no
results (no messages 
at all)

i am runing the version in /usr/bin

even if I try using the -V option I get no output...
 
this is a clear indication of a missing library


try 
$cygcheck psql


to find which one


libpq5 with /bin/cygpq.dll is most likely missing.
It is properly required by postgresql-client though.

Stephen,
Following the advise in http://cygwin.com/problems.html would have 
helped. cygcheck -s -v -r  cygcheck.out


--
Reini Urban
http://phpwiki.org/  http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql

[Marco Atzeri]

--- Stephen Gallaghan  ha scritto:

 Hi
 I am trying to connect to a remote (on local lan)
 postgresql server 
 using cygwin.
 When I try to run the psql program I am getting no
 results (no messages 
 at all)
 i am runing the version in /usr/bin
 
 even if I try using the -V option I get no output...
 
this is a clear indication of a missing library

try 
$cygcheck psql

to find which one
 Cheers
 Stephen

Regards
Marco


  

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client 8.2.9-1 - psql.exe returns nothing, just goes back to the prompt

[Mark Tunnell]

 | Sounds like a missing dependency.  Try 'cygcheck psql.exe' to see if it
 | complains about any missing DLLs.  If it does, you need to install the
 | packages with the missing DLLs.  See http://cygwin.com/packages/ if
 | you need to find the package a DLL is in (or 'cygcheck -p file').
 |
 |
 | Thanks very much!  That was indeed the problem.  It's working fine now.

 So that we might be able to fix it for future users, would you please tell
 us which package was missing?


I installed the following files and psql started working again.
However, I'd been playing around earlier adding and removing things so
I'm pretty sure I caused the problem.  I just didn't know how to
correct it.

libpq5-8.2.5-1.tar.bz2
libpq4-8.2.5-1.tar.bz2
libpq5-8.2.9-1.tar.bz2
libopenldap2_3_0-2.3.39-1.tar.bz2
libsasl2-2.1.19-3.tar.bz2

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client 8.2.9-1 - psql.exe returns nothing, just goes back to the prompt

[Reini Urban]

2008/8/5 Mark Tunnell:
 | Sounds like a missing dependency.  Try 'cygcheck psql.exe' to see if it
 | complains about any missing DLLs.  If it does, you need to install the
 | packages with the missing DLLs.  See http://cygwin.com/packages/ if
 | you need to find the package a DLL is in (or 'cygcheck -p file').
 |
 |
 | Thanks very much!  That was indeed the problem.  It's working fine now.

 So that we might be able to fix it for future users, would you please tell
 us which package was missing?


 I installed the following files and psql started working again.
 However, I'd been playing around earlier adding and removing things so
 I'm pretty sure I caused the problem.  I just didn't know how to
 correct it.

 libpq5-8.2.5-1.tar.bz2
 libpq4-8.2.5-1.tar.bz2
 libpq5-8.2.9-1.tar.bz2
 libopenldap2_3_0-2.3.39-1.tar.bz2
 libsasl2-2.1.19-3.tar.bz2

It was most likely the scenario which we outlined a couple of weeks ago,
but was not fixed yet.

Install latest libpq5 + uninstall old libpq4, which deleted
bin/cygpq.dll which is used by both packages. reinstalling
libpq5-8.2.9 should fix it. The other deps should be correct AFAIK.

The fix is to rename the libpq5 and libpq4 packages to libpq.
I'll fix it with the upcoming 8.3.x packages.
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client 8.2.9-1 - psql.exe returns nothing, just goes back to the prompt

[Larry Hall (Cygwin)]

Mark Tunnell wrote:

Typing psql.exe at the Cygwin Bash prompt results in no output; I just
get the shell prompt back, no matter what switch I add, -V, etc.  I
don't use psql every day so I'm not positive when it stopped working
but I'm pretty sure it was fine before my last Cygwin update.
However, downgrading to the 8.2.5-1 does not resolve the issue.  Is
there any sort of logging I can enable that might help me determine
what's going on?  Or, not going on?


Sounds like a missing dependency.  Try 'cygcheck psql.exe' to see if it
complains about any missing DLLs.  If it does, you need to install the
packages with the missing DLLs.  See http://cygwin.com/packages/ if
you need to find the package a DLL is in (or 'cygcheck -p file').

--
Larry Hall  http://www.rfk.com
RFK Partners, Inc.  (508) 893-9779 - RFK Office
216 Dalton Rd.  (508) 893-9889 - FAX
Holliston, MA 01746

_

A: Yes.
 Q: Are you sure?
 A: Because it reverses the logical flow of conversation.
 Q: Why is top posting annoying in email?

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client 8.2.9-1 - psql.exe returns nothing, just goes back to the prompt

[Mark Tunnell]

 Mark Tunnell wrote:

 Typing psql.exe at the Cygwin Bash prompt results in no output; I just
 get the shell prompt back, no matter what switch I add, -V, etc.  I
 don't use psql every day so I'm not positive when it stopped working
 but I'm pretty sure it was fine before my last Cygwin update.
 However, downgrading to the 8.2.5-1 does not resolve the issue.  Is
 there any sort of logging I can enable that might help me determine
 what's going on?  Or, not going on?


On Mon, Aug 4, 2008 at 3:55 PM, Larry Hall (Cygwin)
[EMAIL PROTECTED] wrote:

 Sounds like a missing dependency.  Try 'cygcheck psql.exe' to see if it
 complains about any missing DLLs.  If it does, you need to install the
 packages with the missing DLLs.  See http://cygwin.com/packages/ if
 you need to find the package a DLL is in (or 'cygcheck -p file').


Thanks very much!  That was indeed the problem.  It's working fine now.

Mark

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client 8.2.9-1 - psql.exe returns nothing, just goes back to the prompt

[Eric Blake]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

According to Mark Tunnell on 8/4/2008 5:25 PM:
| Sounds like a missing dependency.  Try 'cygcheck psql.exe' to see if it
| complains about any missing DLLs.  If it does, you need to install the
| packages with the missing DLLs.  See http://cygwin.com/packages/ if
| you need to find the package a DLL is in (or 'cygcheck -p file').
|
|
| Thanks very much!  That was indeed the problem.  It's working fine now.

So that we might be able to fix it for future users, would you please tell
us which package was missing?

- --
Don't work too hard, make some time for fun as well!

Eric Blake [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (Cygwin)
Comment: Public key at home.comcast.net/~ericblake/eblake.gpg
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkiXrP8ACgkQ84KuGfSFAYD7OwCfUbGeTC15lU4VpG7uSTEj7zBt
3BYAn0YHHY8k9rCXSgafkRtnQALFJouI
=Dzd/
-END PGP SIGNATURE-

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql: libpq4 and libpq5 collide

[Reini Urban]

2008/7/21 Yaakov (Cygwin Ports):
 Both libpq4 and libpq5 contain the same /usr/bin/cygpq.dll file.
 setup.exe cannot handle a file coming from more than one package; this
 is bound to cause problems.

Yes, I did this on purpose, resp. all the libpq packagers don't
version their so's.
The postgresql team does not like versioned so's.
Version 5 contains all the backwards compatible functions from version 4.

I see no technical problems with setup.
First uninstall (remove it), the install (installs the new, which is the same).

Oops. You mean when you want to install both and then uninstall libpq4?
Hmm, maybe a preremove script for libpq4 is needed therefore.
But this does not help.
Or just a re-install of libpq5.

Probably best is to remove libpq4 when installing libpq5.
Can setup handle this? No. Hmm...
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql: libpq4 and libpq5 collide

[Corinna Vinschen]

On Jul 21 14:15, Reini Urban wrote:
 2008/7/21 Yaakov (Cygwin Ports):
  Both libpq4 and libpq5 contain the same /usr/bin/cygpq.dll file.
  setup.exe cannot handle a file coming from more than one package; this
  is bound to cause problems.
 
 Yes, I did this on purpose, resp. all the libpq packagers don't
 version their so's.
 The postgresql team does not like versioned so's.
 Version 5 contains all the backwards compatible functions from version 4.
 
 I see no technical problems with setup.
 First uninstall (remove it), the install (installs the new, which is the 
 same).
 
 Oops. You mean when you want to install both and then uninstall libpq4?
 Hmm, maybe a preremove script for libpq4 is needed therefore.
 But this does not help.
 Or just a re-install of libpq5.
 
 Probably best is to remove libpq4 when installing libpq5.
 Can setup handle this? No. Hmm...

I think the basic problem is that two versioned libs exist (4, 5),
even though no versioning is provided, nor necessary.  The versioning
is only required as soon as backward compatibility is broken by the
new lib version.  This isn't the case, so libpq4 should never have been
created in the first place, rather just a libpq.  Since libpq4 exists
now, I think the right thing to do would be to use this name until
a new lib version breaks backward compatibility.  Then it's time for
a libpq4 and the DLL in it should start to use versioning, too.


Corinna

-- 
Corinna Vinschen  Please, send mails regarding Cygwin to
Cygwin Project Co-Leader  cygwin AT cygwin DOT com
Red Hat

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql: libpq4 and libpq5 collide

[Reini Urban]

Corinna Vinschen schrieb:

On Jul 21 14:15, Reini Urban wrote:

2008/7/21 Yaakov (Cygwin Ports):

Both libpq4 and libpq5 contain the same /usr/bin/cygpq.dll file.
setup.exe cannot handle a file coming from more than one package; this
is bound to cause problems.

Yes, I did this on purpose, resp. all the libpq packagers don't
version their so's.
The postgresql team does not like versioned so's.
Version 5 contains all the backwards compatible functions from version 4.

I see no technical problems with setup.
First uninstall (remove it), the install (installs the new, which is the same).

Oops. You mean when you want to install both and then uninstall libpq4?
Hmm, maybe a preremove script for libpq4 is needed therefore.
But this does not help.
Or just a re-install of libpq5.

Probably best is to remove libpq4 when installing libpq5.
Can setup handle this? No. Hmm...


I think the basic problem is that two versioned libs exist (4, 5),
even though no versioning is provided, nor necessary.  The versioning
is only required as soon as backward compatibility is broken by the
new lib version.  This isn't the case, so libpq4 should never have been
created in the first place, rather just a libpq.  Since libpq4 exists
now, I think the right thing to do would be to use this name until
a new lib version breaks backward compatibility.  Then it's time for
a libpq4 and the DLL in it should start to use versioning, too.


As far as I understand the postgresql team promised to always keep 
backwards compatibility in its client library. New features and 
enhancements always use new functions and don't change old ones. So I'd 
rather want to rename the library to libpq and obsolete the versioned 
libpq4 and libpq5.


This would just require a small change in some setup.hints which I can 
easily do.

--
Reini Urban
http://phpwiki.org/  http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql package and error message translations

[Dmitry Teslenko]

On Thu, May 15, 2008 at 12:58 AM, Reini Urban [EMAIL PROTECTED] wrote:
 Dmitry Teslenko schrieb:
 That's an expensive feature you are annoyed at :)
 export LC_MESSAGES=C
 should do it theoretically.

 However for me it didn't work.
 You can delete or rename your locale catalog as last ressort.
  /usr/share/locale/ru/LC_MESSAGES/psql.mo

Wiping out all nazi crap from /usr/share/locale works fine!
Big thanks!

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql package and error message translations

[Larry Hall (Cygwin)]

Dmitry Teslenko wrote:

Hello!
I use postgresql tools such as psql, pg_dump, etc.
If I invoke them as /bin/psql they product error (and probably other) messages
in english; but if I invoke them as psql or /usr/bin/psql they
produce messages
in my native language (russian) in koi8-r encoding and windows' default encoding
for text in my native language is cp1251 (or windows-1251). That means I get
garbage in terminal.
I've chosen unix file format when installing cygwin and problem
described can be
observed with both current and experimental versions of cygwin packages.
I have no interest in error messages in my native language so is there way
to turn them off once and for all?


Sounds to me like you have a non-Cygwin version of 'psql' somewhere.  Look
around.  If you don't have a non-Cygwin version and want to follow-up with
your problem on this list, please read and follow the problem reporting
guidelines outlined here:

http://cygwin.com/problems.html

--
Larry Hall  http://www.rfk.com
RFK Partners, Inc.  (508) 893-9779 - RFK Office
216 Dalton Rd.  (508) 893-9889 - FAX
Holliston, MA 01746

_

A: Yes.
 Q: Are you sure?
 A: Because it reverses the logical flow of conversation.
 Q: Why is top posting annoying in email?

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql package and error message translations

[Reini Urban]

Dmitry Teslenko schrieb:

Hello!
I use postgresql tools such as psql, pg_dump, etc.
If I invoke them as /bin/psql they product error (and probably other) messages
in english; but if I invoke them as psql or /usr/bin/psql they
produce messages
in my native language (russian) in koi8-r encoding and windows' default encoding
for text in my native language is cp1251 (or windows-1251). That means I get
garbage in terminal.
I've chosen unix file format when installing cygwin and problem
described can be
observed with both current and experimental versions of cygwin packages.
I have no interest in error messages in my native language so is there way
to turn them off once and for all?


That's an expensive feature you are annoyed at :)
export LC_MESSAGES=C
should do it theoretically.

However for me it didn't work.
You can delete or rename your locale catalog as last ressort.
  /usr/share/locale/ru/LC_MESSAGES/psql.mo
--
Reini Urban
http://phpwiki.org/  http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql packaging questions

[Reini Urban]

Dr. Volker Zell schrieb:

Reini Urban writes:

 Reini Urban schrieb:
 2008/3/6, Dr. Volker Zell:
 setup.ini claims the following:
 
 @ libecpg-compat1
 sdesc: Older version of run-time library for ECPG programs
 ldesc: The ecpg_compat.dll shared library is used by programs built 
with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1
 
 @ libecpg4

 sdesc: Run-time library for ECPG programs
 ldesc: The ecpg.dll shared library is used by programs built with ECPG
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 requires: libecpg-compat1
 [test]
 version: 7.4.5-1
 
 @ libpgtypes1

 sdesc: Shared library pgtypes.dll for PostgreSQL 7.4.x
 ldesc: The pgtypes shared library is used by programs built with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1
 
 
 Are these really test versions or actually old dll versions from the

 post 8.0.7 area ?
 Right, the [test] looks wrong. I'll check it where this comes from.

 I have no idea where this was coming from. Should be [prev]

Still not fixed


I have an idea, why it was [test] and not [prev].
I never touched these 7.4.5 libs, and Jason probably thought those 
special libs, which are not really needed, could be useful for testing.


Anyway, I fixed it now.

--
Reini Urban
http://phpwiki.org/  http://murbreak.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql packaging questions

[Dr. Volker Zell]

 Reini Urban writes:

 Reini Urban schrieb:
 2008/3/6, Dr. Volker Zell [EMAIL PROTECTED]:
 setup.ini claims the following:
 
 @ libecpg-compat1
 sdesc: Older version of run-time library for ECPG programs
 ldesc: The ecpg_compat.dll shared library is used by programs built 
with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1
 
 @ libecpg4
 sdesc: Run-time library for ECPG programs
 ldesc: The ecpg.dll shared library is used by programs built with ECPG
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 requires: libecpg-compat1
 [test]
 version: 7.4.5-1
 
 @ libpgtypes1
 sdesc: Shared library pgtypes.dll for PostgreSQL 7.4.x
 ldesc: The pgtypes shared library is used by programs built with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1
 
 
 Are these really test versions or actually old dll versions from the
 post 8.0.7 area ?
 Right, the [test] looks wrong. I'll check it where this comes from.

 I have no idea where this was coming from. Should be [prev]

Still not fixed

Ciao
  Volker
  

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql packaging questions

[Reini Urban]

Reini Urban schrieb:

2008/3/6, Dr. Volker Zell [EMAIL PROTECTED]:

 setup.ini claims the following:
 
 @ libecpg-compat1
 sdesc: Older version of run-time library for ECPG programs
 ldesc: The ecpg_compat.dll shared library is used by programs built with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1

 @ libecpg4
 sdesc: Run-time library for ECPG programs
 ldesc: The ecpg.dll shared library is used by programs built with ECPG
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 requires: libecpg-compat1
 [test]
 version: 7.4.5-1

 @ libpgtypes1
 sdesc: Shared library pgtypes.dll for PostgreSQL 7.4.x
 ldesc: The pgtypes shared library is used by programs built with ecpg.
 (Embedded PostgreSQL for C).
 .
 PostgreSQL is an object-relational SQL database management system.
 category: Libs
 [test]
 version: 7.4.5-1
 

 Are these really test versions or actually old dll versions from the
 post 8.0.7 area ?


Right, the [test] looks wrong. I'll check it where this comes from.


I have no idea where this was coming from. Should be [prev]


8.1.4-2 was a memory hog, 8.2.5-1 was better and very well tested,
8.2.6-1 is the currently best version, but I'm not confident enough to
upload it.
8.3.0 should be really good, but I haven't enough time to test it yet.


I've found time for 8.3.0, and it doesn't look good at all.
So I will fall back to 8.2.6, until I get the necessary fixes upstream 
included.

--
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql packaging questions

[Reini Urban]

2008/3/6, Dr. Volker Zell [EMAIL PROTECTED]:
  setup.ini claims the following:

  
  @ libecpg-compat1
  sdesc: Older version of run-time library for ECPG programs
  ldesc: The ecpg_compat.dll shared library is used by programs built with 
 ecpg.
  (Embedded PostgreSQL for C).
  .
  PostgreSQL is an object-relational SQL database management system.
  category: Libs
  [test]
  version: 7.4.5-1

  @ libecpg4
  sdesc: Run-time library for ECPG programs
  ldesc: The ecpg.dll shared library is used by programs built with ECPG
  (Embedded PostgreSQL for C).
  .
  PostgreSQL is an object-relational SQL database management system.
  category: Libs
  requires: libecpg-compat1
  [test]
  version: 7.4.5-1

  @ libpgtypes1
  sdesc: Shared library pgtypes.dll for PostgreSQL 7.4.x
  ldesc: The pgtypes shared library is used by programs built with ecpg.
  (Embedded PostgreSQL for C).
  .
  PostgreSQL is an object-relational SQL database management system.
  category: Libs
  [test]
  version: 7.4.5-1
  

  Are these really test versions or actually old dll versions from the
  post 8.0.7 area ?

Right, the [test] looks wrong. I'll check it where this comes from.

  Postgresql 8.1.4-2 is marked as test since more than a year I
  think. Will it ever be moved to curr or will it eventually be replaced
  with a completely new version ?

Not to curr.
8.1.4-2 is good, but not good enough for stable.
8.0.7 is really stable, and my redhat servers still run with 7.4.

I'm constantly testing the current versions and used to upload it to my
private setup site. http://rurban.xarch.at/cygr/postgresql/ (new
versions deleted now)

Whenever I feel confident with the package, an update with some fix or
feature enhancement arrives upstream so the build-test cycle begins
again.

8.1.4-2 was a memory hog, 8.2.5-1 was better and very well tested,
8.2.6-1 is the currently best version, but I'm not confident enough to
upload it.
8.3.0 should be really good, but I haven't enough time to test it yet.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-client-8.0.7-1.tar.bz2 filesize is 0 in setup.ini

[Reini Urban]

Igor Peshansky schrieb:

Hi,

I just noticed that the size of postgresql-client-8.0.7-1.tar.bz2 (the
curr version) is set to 0.  Is that intentional?  It doesn't seem to break
setup, but is something to look into, nonetheless.


Yes, that's on purpose.
There are three main packages: postgresql, libpq4 and postgresql-client.
All three of them have existing curr and test packages. The two client 
packages should have correct cross-dependencies.


1. Empty not to conflict with the existing postgresql-8.0.7-1, which has 
all the client binaries.
2. Existing, because when installing postgresql-client-8.0.7-1 after 
having installed 8.1.4-2, to pull in the correct dependencies.

--
Reini

Re: postgresql-client-8.0.7-1.tar.bz2 filesize is 0 in setup.ini

[Igor Peshansky]

On Sat, 29 Jul 2006, Reini Urban wrote:

 Igor Peshansky schrieb:
  Hi,
 
  I just noticed that the size of postgresql-client-8.0.7-1.tar.bz2 (the
  curr version) is set to 0.  Is that intentional?  It doesn't seem to
  break setup, but is something to look into, nonetheless.

 Yes, that's on purpose.
 There are three main packages: postgresql, libpq4 and postgresql-client.
 All three of them have existing curr and test packages. The two client
 packages should have correct cross-dependencies.

 1. Empty not to conflict with the existing postgresql-8.0.7-1, which has
 all the client binaries.
 2. Existing, because when installing postgresql-client-8.0.7-1 after
 having installed 8.1.4-2, to pull in the correct dependencies.

Hmm, the usual way of doing this is creating an empty .tar.bz2 archive,
which is not 0 bytes (it's something like 46).  I'm surprised setup
doesn't croak on a 0-byte archive file.  Oh, well...
Igor
-- 
http://cs.nyu.edu/~pechtcha/
  |\  _,,,---,,_[EMAIL PROTECTED] | [EMAIL PROTECTED]
ZZZzz /,`.-'`'-.  ;-;;,_Igor Peshansky, Ph.D. (name changed!)
 |,4-  ) )-,_. ,\ (  `'-'   old name: Igor Pechtchanski
'---''(_/--'  `-'\_) fL a.k.a JaguaR-R-R-r-r-r-.-.-.  Meow!

Las! je suis sot... -Mais non, tu ne l'es pas, puisque tu t'en rends compte.
But no -- you are no fool; you call yourself a fool, there's proof enough in
that! -- Rostand, Cyrano de Bergerac

Re: postgresql-client-8.0.7-1.tar.bz2 filesize is 0 in setup.ini

[Christopher Faylor]

On Sat, Jul 29, 2006 at 11:07:29AM -0400, Igor Peshansky wrote:
On Sat, 29 Jul 2006, Reini Urban wrote:

 Igor Peshansky schrieb:
  Hi,
 
  I just noticed that the size of postgresql-client-8.0.7-1.tar.bz2 (the
  curr version) is set to 0.  Is that intentional?  It doesn't seem to
  break setup, but is something to look into, nonetheless.

 Yes, that's on purpose.
 There are three main packages: postgresql, libpq4 and postgresql-client.
 All three of them have existing curr and test packages. The two client
 packages should have correct cross-dependencies.

 1. Empty not to conflict with the existing postgresql-8.0.7-1, which has
 all the client binaries.
 2. Existing, because when installing postgresql-client-8.0.7-1 after
 having installed 8.1.4-2, to pull in the correct dependencies.

Hmm, the usual way of doing this is creating an empty .tar.bz2 archive,
which is not 0 bytes (it's something like 46).  I'm surprised setup
doesn't croak on a 0-byte archive file.  Oh, well...

I've recreated this as a standard 46 byte empty .tar.bz2 file.

cgf

Re: postgresql-client-8.0.7-1.tar.bz2 filesize is 0 in setup.ini

[Reini Urban]

Christopher Faylor schrieb:

On Sat, Jul 29, 2006 at 11:07:29AM -0400, Igor Peshansky wrote:

...

Hmm, the usual way of doing this is creating an empty .tar.bz2 archive,
which is not 0 bytes (it's something like 46).  I'm surprised setup
doesn't croak on a 0-byte archive file.  Oh, well...


I've recreated this as a standard 46 byte empty .tar.bz2 file.


Thanks.

--
Reini

Re: PostgreSQL 8.1.2 crashes diring import...

[Reini Urban]

I see in your previous mail, that your cygserver SHM settings
are already at the maximum. Hope that your have that much RAM/Virtual Memory.

The previous error was an interrupted call error 2, which is not the case
with your problem.
Jason's Problem:
3 [main] postmaster 1144 transport_layer_pipes::connect: lost connection
to cygserver, error = 2
...
FATAL:  could not create shared memory segment: Interrupted system call
DETAIL:  Failed system call was shmget(key=5432001, size=8970240, 03600).

Your problem:
9 [main] postmaster 656 transport_layer_pipes::connect: lost
connection to cygserver, error = 121

Can you try running cygserver with -d. For testing best started from the
console, not as service. Maybe within a sysbash to have the same
permissions.

BTW: My cygwin packages 8.06 and 8.1.2 to test against are at
the setup User Url: http://xarch.tu-graz.ac.at/publ/cygwin/

I haven't tested yet such a big 3-4GIG import, a huge index might need
more than with 8.0, but the heavy and parallel regressions do all pass
so far.

 Adding to my own message.

 Just found this, which is from two years ago and reflects on the same
 problem -

 http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00014.html

 This e-mail says that cygserver simply exits upon high load upon
 PostgreSQL.

 This e-mail says that the problem is fixed -

 http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00179.html

 Could it be that the problem has come back?

Could be but I doubt it.
-- 
Reini Urban
http://phpwiki.org/   http://xarch.tu-graz.ac.at/home/rurban/



--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL 8.1.2 crashes diring import...

[[EMAIL PROTECTED]]

Reini Urban wrote:

I see in your previous mail, that your cygserver SHM settings
are already at the maximum. Hope that your have that much RAM/Virtual Memory.


I did this just desperately looking for solution, but seems the problem 
is not there.



Your problem:
9 [main] postmaster 656 transport_layer_pipes::connect: lost
connection to cygserver, error = 121

Can you try running cygserver with -d. For testing best started from the
console, not as service. Maybe within a sysbash to have the same
permissions.


Yes, I did that but did not include it in the e-mail, as I did not see 
anything meaningful there (no obvious error message). I'll do it again 
and send it to the list in the next 2-3 days (lost time the last 1-2 
days with this).



BTW: My cygwin packages 8.06 and 8.1.2 to test against are at
the setup User Url: http://xarch.tu-graz.ac.at/publ/cygwin/


I went back to 8.0.4. I need something which I understand how it happens 
and why. Thanks, however.



I haven't tested yet such a big 3-4GIG import, a huge index might need
more than with 8.0, but the heavy and parallel regressions do all pass
so far.


OK I'll do the -d option and then we will see if we can do something.

Thanks for your input,
Iv


--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL 8.1.2 crashes diring import...

[[EMAIL PROTECTED]]

Adding to my own message.

Just found this, which is from two years ago and reflects on the same 
problem -


http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00014.html

This e-mail says that cygserver simply exits upon high load upon PostgreSQL.

This e-mail says that the problem is fixed -

http://www.cygwin.com/ml/cygwin-apps/2004-01/msg00179.html

Could it be that the problem has come back?

Iv


--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL : Bad system calls

[Larry Hall (Cygwin)]

Alex Goldman wrote:

On 10/30/05, Larry Hall (Cygwin) [EMAIL PROTECTED] wrote:


Alex Goldman wrote:


Hi

I get Bad system call errors, when I try to run 'initdb'. I searched
the net for cygwin + postgresql + bad system call, and saw that
others are complaining about this problem too, but I found no
explanations or solutions. I tried both 7.4.3-1 and 7.4.5-1 versions
of postgresql. Any idea what's going on? Here's a sample of the
output:



snip

Please read and follow the problem reporting guidelines found at:



Problem reports:   http://cygwin.com/problems.html


Given your description though, I'm wondering if you read
'/usr/share/doc/Cygwin/postgresql-7.4.3.README'.  If not, check it out.
I believe you'll find appropriate information to resolve this problem.
If not, then I point you back to my previous advice.



According to the README, I wasn't running cygserver (and
cygserver-config). I tried doing that, but get bad system call
errors anyway.



OK, so you still have something mis-configured then on your end.  Given
the information you've provided so far, that's all the feedback I can
give you.



If your previous advice is about sending cygcheck.out to the list,
I'm going to have to say no. Otherwise, I don't understand your
complaint.



As I mentioned above, without the details of your problem, neither I nor
anyone else on this list can help you figure out what your problem is.
The output of 'cygcheck' is part of the requested information that I
pointed you to.  Specifics about what you did and how you did them is
even more important.  FWIW, I wasn't complaining about anything.  I
was simply pointing out that you hadn't provided much in the way of
information to form the basis of useful feedback to you.  Pointing you
at the Postgresql readme was my best guess at the probable source of
your problem.



Anyway, I found out that PostgreSQL seems to support Win32 directly,
so I'll try that.



That's certainly another option.


--
Larry Hall  http://www.rfk.com
RFK Partners, Inc.  (508) 893-9779 - RFK Office
838 Washington Street   (508) 893-9889 - FAX
Holliston, MA 01746

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL : Bad system calls

[Alexander Gottwald]

On Mon, 2005-10-31 at 10:32 -0500, Larry Hall (Cygwin) wrote:

  According to the README, I wasn't running cygserver (and
  cygserver-config). I tried doing that, but get bad system call
  errors anyway.

You must have set server in the CYGWIN environment variable too.
CYGWIN=server $CYGWIN postmaster

  Anyway, I found out that PostgreSQL seems to support Win32 directly,
  so I'll try that.

 That's certainly another option.

It works like a charm for me.

bye
ago


signature.asc
Description: This is a digitally signed message part

Re: PostgreSQL : Bad system calls

[Larry Hall (Cygwin)]

Alex Goldman wrote:

Hi

I get Bad system call errors, when I try to run 'initdb'. I searched
the net for cygwin + postgresql + bad system call, and saw that
others are complaining about this problem too, but I found no
explanations or solutions. I tried both 7.4.3-1 and 7.4.5-1 versions
of postgresql. Any idea what's going on? Here's a sample of the
output:



snip

Please read and follow the problem reporting guidelines found at:


Problem reports:   http://cygwin.com/problems.html


Given your description though, I'm wondering if you read
'/usr/share/doc/Cygwin/postgresql-7.4.3.README'.  If not, check it out.
I believe you'll find appropriate information to resolve this problem.
If not, then I point you back to my previous advice.

--
Larry Hall  http://www.rfk.com
RFK Partners, Inc.  (508) 893-9779 - RFK Office
838 Washington Street   (508) 893-9889 - FAX
Holliston, MA 01746

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL : Bad system calls

[Alex Goldman]

On 10/30/05, Larry Hall (Cygwin) [EMAIL PROTECTED] wrote:
 Alex Goldman wrote:
  Hi
 
  I get Bad system call errors, when I try to run 'initdb'. I searched
  the net for cygwin + postgresql + bad system call, and saw that
  others are complaining about this problem too, but I found no
  explanations or solutions. I tried both 7.4.3-1 and 7.4.5-1 versions
  of postgresql. Any idea what's going on? Here's a sample of the
  output:
 

 snip

 Please read and follow the problem reporting guidelines found at:

  Problem reports:   http://cygwin.com/problems.html

 Given your description though, I'm wondering if you read
 '/usr/share/doc/Cygwin/postgresql-7.4.3.README'.  If not, check it out.
 I believe you'll find appropriate information to resolve this problem.
 If not, then I point you back to my previous advice.

According to the README, I wasn't running cygserver (and
cygserver-config). I tried doing that, but get bad system call
errors anyway.

If your previous advice is about sending cygcheck.out to the list,
I'm going to have to say no. Otherwise, I don't understand your
complaint.

Anyway, I found out that PostgreSQL seems to support Win32 directly,
so I'll try that.

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL : Bad system calls

[Christopher Faylor]

On Sun, Oct 30, 2005 at 07:49:19PM -0800, Alex Goldman wrote:
On 10/30/05, Larry Hall (Cygwin) [EMAIL PROTECTED] wrote:
 Alex Goldman wrote:
  Hi
 
  I get Bad system call errors, when I try to run 'initdb'. I searched
  the net for cygwin + postgresql + bad system call, and saw that
  others are complaining about this problem too, but I found no
  explanations or solutions. I tried both 7.4.3-1 and 7.4.5-1 versions
  of postgresql. Any idea what's going on? Here's a sample of the
  output:
 

 snip

 Please read and follow the problem reporting guidelines found at:

  Problem reports:   http://cygwin.com/problems.html

 Given your description though, I'm wondering if you read
 '/usr/share/doc/Cygwin/postgresql-7.4.3.README'.  If not, check it out.
 I believe you'll find appropriate information to resolve this problem.
 If not, then I point you back to my previous advice.

According to the README, I wasn't running cygserver (and
cygserver-config). I tried doing that, but get bad system call
errors anyway.

If your previous advice is about sending cygcheck.out to the list,
I'm going to have to say no. Otherwise, I don't understand your
complaint.

Anyway, I found out that PostgreSQL seems to support Win32 directly,
so I'll try that.

That's great, then people from the Postgres project can complain by
asking for details when you request help and you can just say no to
them as well.

At least we won't have to insult you by asking for details here.

cgf

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: postgresql-8.01 and 8.1 ready

[Corinna Vinschen]

On Sep 29 21:14, Reini Urban wrote:
 [I don't see my answer in gmail, and the nameserver of my main domain
 is dead today, so I repost]
 Reini Urban schrieb:
 ...
  More info in the announcement at the cygwin list.
 ...
  8.0.0cvs-1 and 7.4.3-1 can be deleted.
  8.1beta2 has some minor problems, I'll upload 8.1beta3 then.
 
 I've added some minor changes to the README and init.d script for the
 recommended usage of --termsig INT in favor of --termsig TERM.
 Thanks Jason!
 
 [curr]
 http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2.tar.bz2
   6620119 b4e8a87b4196ff55ce10df311e400ca2
 http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2-src.tar.bz2
   10932419 14a3f004c648606c6e98799d2eb747ba
 http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/setup.hint
 
 [test]
 http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2.tar.bz2
   6732703 fba25b3c6463f2b615362a2bb2f6a73f
 http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2-src.tar.bz2
   11275901 ee3eb8500033119d5d6e109615f4f8d9
 
 For the freegis packages using postgresql:
 geos is ready, gdal broke recently but I still have an old one,
 so postgis will be soon out and ITP'd.
 For mapserver I'd prefer apache-php, but as cgi it will work also fine.
 slony-I and pgcluster afterwards.

Jason, could you please review this package?


Thanks,
Corinna

-- 
Corinna Vinschen  Please, send mails regarding Cygwin to
Cygwin Project Co-Leader  cygwin AT cygwin DOT com
Red Hat, Inc.

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

[I don't see my answer in gmail, and the nameserver of my main domain
is dead today, so I repost]
Reini Urban schrieb:
...
 More info in the announcement at the cygwin list.
...
 8.0.0cvs-1 and 7.4.3-1 can be deleted.
 8.1beta2 has some minor problems, I'll upload 8.1beta3 then.

I've added some minor changes to the README and init.d script for the
recommended usage of --termsig INT in favor of --termsig TERM.
Thanks Jason!

[curr]
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2.tar.bz2
  6620119 b4e8a87b4196ff55ce10df311e400ca2
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2-src.tar.bz2
  10932419 14a3f004c648606c6e98799d2eb747ba
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/setup.hint

[test]
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2.tar.bz2
  6732703 fba25b3c6463f2b615362a2bb2f6a73f
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2-src.tar.bz2
  11275901 ee3eb8500033119d5d6e109615f4f8d9

For the freegis packages using postgresql:
geos is ready, gdal broke recently but I still have an old one,
so postgis will be soon out and ITP'd.
For mapserver I'd prefer apache-php, but as cgi it will work also fine.
slony-I and pgcluster afterwards.
--
Reini Urban
http://phpwiki.org/

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

Reini Urban schrieb:
...

More info in the announcement at the cygwin list.

...

8.0.0cvs-1 and 7.4.3-1 can be deleted.
8.1beta2 has some minor problems, I'll upload 8.1beta3 then.


I've added some minor changes to the README and init.d script for the
recommended usage of --termsig INT in favor of --termsig TERM.
Thanks Jason!

[curr]
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2.tar.bz2 


  6620119 b4e8a87b4196ff55ce10df311e400ca2
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.0.3-2-src.tar.bz2 


  10932419 14a3f004c648606c6e98799d2eb747ba
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/setup.hint

[test]
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2.tar.bz2
  6732703 fba25b3c6463f2b615362a2bb2f6a73f
http://xarch.tu-graz.ac.at/publ/cygwin/release/postgresql/postgresql-8.1beta1-2-src.tar.bz2
  11275901 ee3eb8500033119d5d6e109615f4f8d9

For the freegis packages using postgresql:
geos is ready, gdal broke recently but I still have an old one,
so postgis will be soon out and ITP'd.
For mapserver I'd prefer apache-php, but as cgi it will work also fine.
slony-I and pgcluster afterwards.
--
Reini Urban
http://phpwiki.org/

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

Jason Tishler wrote:

On Mon, Sep 26, 2005 at 01:45:45PM +0100, Reini Urban wrote:

Signal TERM is correctly handled by postmaster, postmaster running as
SYSTEM owned service.  So --termsig INT is not needed anymore.


AFAICT, SIGTERM was always handled by postmaster.


I'd prefer TERM over INT: smart shutdown vs. fast shutdown


The problem with smart shutdown is it waits for all clients to
disconnect before shutting down.  So, Windows will eventually just kill
postmaster during machine shut down if at least one client is still
connected.  This is why I recommended using SIGINT in my README.  IMO, a
fast shutdown is better than the possibility of an aborted smart
shutdown.  Of course, a DBA if free to configure PostgreSQL however they
see fit.


Thanks for the explanation! I should add this to the new README as well.
I'll release an updated package with the minor --termsig INT change in 
the init.d script then.

Just building gdal, geos, postgis and slony-I, BTW.
--
Reini

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

Signal TERM is correctly handled by postmaster,
postmaster running as SYSTEM owned service.
So --termsig INT is not needed anymore.
I'd prefer TERM over INT: smart shutdown vs. fast shutdown

For more technical details later or in a seperate cygwin discussion,
not here in -apps
I'll have to wade through the sources in between.

See below:

SYSTEM $ kill -TERM first postmaster pid
SYSTEM $ cat /var/log/postgresql.log
LOG:  database system was shut down at 2005-09-26 09:54:28 WEST
LOG:  checkpoint record is at 0/38CB50
LOG:  redo record is at 0/38CB50; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 562; next OID: 10791
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system is ready
LOG:  transaction ID wrap limit is 2147484144, limited by database postgres
LOG:  received smart shutdown request
LOG:  shutting down
LOG:  database system is shut down

SYSTEM $ /etc/init.d/postgresql start
SYSTEM $ kill -INT first postmaster pid
SYSTEM $ tail /var/log/postgresql.log
LOG:  received fast shutdown request
LOG:  shutting down
LOG:  database system is shut down

On 9/24/05, Jason Tishler [EMAIL PROTECTED] wrote:
 On Sat, Sep 24, 2005 at 03:07:05PM +0200, Reini Urban wrote:
  To be specific, why doesn't the following (excerpt) from my
  PostgreSQL 7.x README work for 8.x?
  
  $ cygserver-config
  $ net user postgres $password /add /fullname:postgres
  /comment:'PostgreSQL user account' /homedir:$(cygpath -w
  /home/postgres)
  $ mkpasswd -l -u postgres /etc/passwd
  $ cmd /c secpol.msc # grant postgres Log on as a service user right
  $ cygrunsrv --install postmaster --path /usr/bin/postmaster --args -D
  /var/postgresql/data -i --dep cygserver --termsig INT --user postgres
  --shutdown
 
  Because 8.x put postmaster into /usr/sbin

 With the the minor change to postmaster's path, does the above still
 work?

  I haven't checked --termsig INT though.

 I would expect the above to still work too.  But, you should verify to
 make sure of clean database shutdown semantics when the machine is
 shutdown.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

Jason Tishler schrieb:

On Fri, Sep 23, 2005 at 11:37:46AM +0200, Corinna Vinschen wrote:

On Sep 23 10:30, Gerrit P. Haase wrote:

Reini Urban wrote:

Gerrit P. Haase schrieb:

Reini Urban wrote:
Installing as service is quite hard without sysbash, 
[snip]


So it is not possible to run this as service?


No, now you have two options to run it as service: cygrunsrv and pg_ctl.


What is the problem with the method used in postgres 7?


Nothing.

What is sysbash?

Not yet a package unfortunately.
http://sources.redhat.com/ml/cygwin/2004-08/msg01177.html


[snip]


Good questions.  Ideally I'd assume that the new postgresql just works
as a replacement for the old postgresql so that existing service
installations using cygrunsrv are not suddenly broken.


postgresql-8.x work with various types of service registrations
and start methods:
* The native one is via pg_ctl (new).
* My new init.d script is to mimic the old and wellknown behaviour using 
cygrunsvr (as before).
* And then you can always start postmaster as before, without service 
and without pg_ctl.


Important changes from 7.x to 8.x:
* admin binaries in /usr/sbin, and not in /usr/bin anymore.
  (similar to debian)
* native windows service functions added to pg_ctl
* contrib binaries in /usr/lib/postgresql/bin

I recommend to set PGDATA to /usr/share/postgresql/data-8.0.
PGDATA is versioned and you can easily have multiple PGDATA dirs.
I have data-7.4, data-8.0 and data-8.1


To be specific, why doesn't the following (excerpt) from my PostgreSQL
7.x README work for 8.x?

$ cygserver-config
$ net user postgres $password /add /fullname:postgres /comment:'PostgreSQL user 
account' /homedir:$(cygpath -w /home/postgres)
$ mkpasswd -l -u postgres /etc/passwd
$ cmd /c secpol.msc # grant postgres Log on as a service user right
$ cygrunsrv --install postmaster --path /usr/bin/postmaster --args -D 
/var/postgresql/data -i --dep cygserver --termsig INT --user postgres --shutdown


Because 8.x put postmaster into /usr/sbin
I haven't checked --termsig INT though.
--
Reini

Re: postgresql-8.01 and 8.1 ready

[Jason Tishler]

Reini,

On Sat, Sep 24, 2005 at 03:07:05PM +0200, Reini Urban wrote:
 To be specific, why doesn't the following (excerpt) from my
 PostgreSQL 7.x README work for 8.x?
 
 $ cygserver-config
 $ net user postgres $password /add /fullname:postgres 
 /comment:'PostgreSQL user account' /homedir:$(cygpath -w 
 /home/postgres)
 $ mkpasswd -l -u postgres /etc/passwd
 $ cmd /c secpol.msc # grant postgres Log on as a service user right
 $ cygrunsrv --install postmaster --path /usr/bin/postmaster --args -D 
 /var/postgresql/data -i --dep cygserver --termsig INT --user postgres 
 --shutdown
 
 Because 8.x put postmaster into /usr/sbin

With the the minor change to postmaster's path, does the above still
work?

 I haven't checked --termsig INT though.

I would expect the above to still work too.  But, you should verify to
make sure of clean database shutdown semantics when the machine is
shutdown.

Thanks,
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

Re: postgresql-8.01 and 8.1 ready

[Gerrit P. Haase]

Reini Urban wrote:


Gerrit P. Haase schrieb:


Reini Urban wrote:

Installing as service is quite hard without sysbash, so I put 
everything into the sysvinit file /etc/rc.0/init.d/postgresql:
start|stop|status|initdb|install|uninstall|startlocal|restart|condrestart 




How does this work without logging into the system and starting a
cygwin shell?



Not at all.
My sysvinit init.d script was enhanced for the installation / 
uninstallation steps.

pg_ctl does almost the same, but without using cygrunsrv.


So it is not possible to run this as service?
What is the problem with the method used in postgres 7?
What is sysbash?


Gerrit
--
=^..^=

Re: postgresql-8.01 and 8.1 ready

[Corinna Vinschen]

On Sep 23 10:30, Gerrit P. Haase wrote:
 Reini Urban wrote:
 
 Gerrit P. Haase schrieb:
 
 Reini Urban wrote:
 
 Installing as service is quite hard without sysbash, so I put 
 everything into the sysvinit file /etc/rc.0/init.d/postgresql:
 start|stop|status|initdb|install|uninstall|startlocal|restart|condrestart 
 
 
 
 How does this work without logging into the system and starting a
 cygwin shell?
 
 
 Not at all.
 My sysvinit init.d script was enhanced for the installation / 
 uninstallation steps.
 pg_ctl does almost the same, but without using cygrunsrv.
 
 So it is not possible to run this as service?
 What is the problem with the method used in postgres 7?
 What is sysbash?

Good questions.  Ideally I'd assume that the new postgresql just works as
a replacement for the old postgresql so that existing service installations
using cygrunsrv are not suddenly broken.

Also, since sysvinit has no active maintainer anymore, according to Sergey,
it might also be dropped from the distro in a couple of weeks so you can't
rely on it.

For service installations, cygrunsrv is usually the way to go.  Lots of
changes has been made to it in 2001 by Fred Yankowski especially to get it
working smoothly with postgresql.


Corinna

-- 
Corinna Vinschen  Please, send mails regarding Cygwin to
Cygwin Project Co-Leader  cygwin AT cygwin DOT com
Red Hat, Inc.

Re: postgresql-8.01 and 8.1 ready

[Jason Tishler]

On Fri, Sep 23, 2005 at 11:37:46AM +0200, Corinna Vinschen wrote:
 On Sep 23 10:30, Gerrit P. Haase wrote:
  Reini Urban wrote:
  Gerrit P. Haase schrieb:
  Reini Urban wrote:
  Installing as service is quite hard without sysbash, 
  [snip]
  
  So it is not possible to run this as service?
  What is the problem with the method used in postgres 7?
  [snip]
 
 Good questions.  Ideally I'd assume that the new postgresql just works
 as a replacement for the old postgresql so that existing service
 installations using cygrunsrv are not suddenly broken.

To be specific, why doesn't the following (excerpt) from my PostgreSQL
7.x README work for 8.x?

$ cygserver-config
$ net user postgres $password /add /fullname:postgres /comment:'PostgreSQL 
user account' /homedir:$(cygpath -w /home/postgres)
$ mkpasswd -l -u postgres /etc/passwd
$ cmd /c secpol.msc # grant postgres Log on as a service user right
$ cygrunsrv --install postmaster --path /usr/bin/postmaster --args -D 
/var/postgresql/data -i --dep cygserver --termsig INT --user postgres 
--shutdown
...

Thanks,
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

Re: postgresql-8.01 and 8.1 ready

[Gerrit P. Haase]

Reini Urban wrote:

Installing as service is quite hard without sysbash, so I put everything 
into the sysvinit file /etc/rc.0/init.d/postgresql:

start|stop|status|initdb|install|uninstall|startlocal|restart|condrestart


How does this work without logging into the system and starting a
cygwin shell?


Gerrit
--
=^..^=

Re: postgresql-8.01 and 8.1 ready

[Reini Urban]

Gerrit P. Haase schrieb:

Reini Urban wrote:

Installing as service is quite hard without sysbash, so I put 
everything into the sysvinit file /etc/rc.0/init.d/postgresql:

start|stop|status|initdb|install|uninstall|startlocal|restart|condrestart


How does this work without logging into the system and starting a
cygwin shell?


Not at all.
My sysvinit init.d script was enhanced for the installation / 
uninstallation steps.

pg_ctl does almost the same, but without using cygrunsrv.
--
Reini Urban
http://phpwiki.org/

Re: Postgresql package broken?

[Jason Tishler]

Max,

On Tue, Sep 06, 2005 at 01:38:47PM +0100, Max Bowsher wrote:
 Wanting to eliminate possible oddities with my system as a cause, I
 did a totally clean install on Cygwin Base + postgresql onto a
 different computer, but still postmaster immediately segfaults.
 
 Is the current postgresql package faulty, or am I just extremely
 unlucky?

Does the following help?

http://cygwin.com/ml/cygwin/2005-08/msg00394.html

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

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: Postgresql package broken?

[Max Bowsher]

Jason Tishler wrote:

Max,

On Tue, Sep 06, 2005 at 01:38:47PM +0100, Max Bowsher wrote:

Wanting to eliminate possible oddities with my system as a cause, I
did a totally clean install on Cygwin Base + postgresql onto a
different computer, but still postmaster immediately segfaults.

Is the current postgresql package faulty, or am I just extremely
unlucky?


Does the following help?

   http://cygwin.com/ml/cygwin/2005-08/msg00394.html


Yes thanks.

Sorry - I didn't remember seeing anything in the last couple of weeks, and 
didn't think there would be anything relevant in the archives further back 
than that.


Max.


--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL: logon failure

[Krzysztof Duleba]

George wrote:

 I followed the instructions for installing postgresql as an NT service
 as outlined in the postgresql README, but ended up with the following
 error: 
 
 $ cygrunsrv -S postmaster
 cygrunsrv: Error starting a service: StartService:  Win32 error 1069:
 The service did not start due to a logon failure.

What does postgresql's log say? Look for it in /var/log.

Krzysztof Duleba


--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL: logon failure

[George]

On Thu, Jun 16, 2005 at 06:32:39PM +0200, Krzysztof Duleba wrote:
 George wrote:
 
  I followed the instructions for installing postgresql as an NT service
  as outlined in the postgresql README, but ended up with the following
  error: 
  
  $ cygrunsrv -S postmaster
  cygrunsrv: Error starting a service: StartService:  Win32 error 1069:
  The service did not start due to a logon failure.
 
 What does postgresql's log say? Look for it in /var/log.

Thanks for the reply, Krzyszstof.  No log file exists at the moment.
Should there be one?

$ cygrunsrv --query postmaster
Service : postmaster
Current State   : Stopped
Command : /usr/bin/postmaster -D /var/postgresql/data -i

-- 
George

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/

Re: PostgreSQL: logon failure

[Reini Urban]

George schrieb:

I followed the instructions for installing postgresql as an NT service
as outlined in the postgresql README, but ended up with the following
error: 


$ cygrunsrv -S postmaster
cygrunsrv: Error starting a service: StartService:  Win32 error 1069:
The service did not start due to a logon failure.


As what user do you start the service?
The service could not logon as this user.

--
Unsubscribe info:  http://cygwin.com/ml/#unsubscribe-simple
Problem reports:   http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ:   http://cygwin.com/faq/