Antony | 1 Sep 2005 13:04

Postgres 7.4.5 fails with Cygwin 1.5.18-1 (core dump)

An old W2K installation now fails with core dump after postmaster.
A new WXP installation fails in the same way.

Cygserver is running as a service and is started

Postmaster core dumps when run.

Running postmaster with debug gives:

bash-3.00$ postmaster -d 5
DEBUG:  postmaster: PostmasterMain: initial environ dump:
DEBUG:  -----------------------------------------
DEBUG:          HOMEPATH=\Documents and Settings\adb
DEBUG:          TERM=cygwin
DEBUG:          PROCESSOR_IDENTIFIER=x86 Family 15 Model 47 Stepping 2,
AuthenticAMD
DEBUG:          WINDIR=C:\WINDOWS
DEBUG:          USERDOMAIN=ACONCAGUA
DEBUG:          OS=Windows_NT
DEBUG:          !::=::\
DEBUG:          COMMONPROGRAMFILES=C:\Program Files\Common Files
DEBUG:          PROCESSOR_LEVEL=15
DEBUG:         
PATH=/usr/bin:/cygdrive/c/WINDOWS/system32:/cygdrive/c/WINDOWS:
/cygdrive/c/WINDOWS/System32/Wbem:
/cygdrive/c/Program Files/ATI Technologies/ATI Control Panel
DEBUG:          FP_NO_HOST_CHECK=NO
DEBUG:          PWD=/usr/bin
DEBUG:          SYSTEMDRIVE=C:
DEBUG:          CYGWIN=server ntsec tty
(Continue reading)

Antony | 1 Sep 2005 13:36

Re: Postgres 7.4.5 fails with Cygwin 1.5.18-1 (core dump)

Antony <adb <at> teamware.com> writes:

I have tried the 19th August snapshot of cygwin dll, which is the earliest on
the snapshot page, but that reports as incompatible.

Another postee reports successfully using the 9th Aug snapshot.  Anyone know
where I can get that?

Regards
Antony

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Roland Walter | 1 Sep 2005 13:46

Re: Postgres 7.4.5 fails with Cygwin 1.5.18-1 (core dump)

Antony schrieb:

> An old W2K installation now fails with core dump after postmaster.
> A new WXP installation fails in the same way.
> 
> Cygserver is running as a service and is started
> 
> Postmaster core dumps when run.
> 
> Running postmaster with debug gives:
> 
> bash-3.00$ postmaster -d 5
> DEBUG:  postmaster: PostmasterMain: initial environ dump:
> DEBUG:  -----------------------------------------
> DEBUG:          HOMEPATH=\Documents and Settings\adb
> DEBUG:          TERM=cygwin
> DEBUG:          PROCESSOR_IDENTIFIER=x86 Family 15 Model 47 Stepping 2,
> AuthenticAMD
> DEBUG:          WINDIR=C:\WINDOWS
> DEBUG:          USERDOMAIN=ACONCAGUA
> DEBUG:          OS=Windows_NT
> DEBUG:          !::=::\
> DEBUG:          COMMONPROGRAMFILES=C:\Program Files\Common Files
> DEBUG:          PROCESSOR_LEVEL=15
> DEBUG:         
> PATH=/usr/bin:/cygdrive/c/WINDOWS/system32:/cygdrive/c/WINDOWS:
> /cygdrive/c/WINDOWS/System32/Wbem:
> /cygdrive/c/Program Files/ATI Technologies/ATI Control Panel
> DEBUG:          FP_NO_HOST_CHECK=NO
> DEBUG:          PWD=/usr/bin
(Continue reading)

Roland Walter | 1 Sep 2005 13:57

Re: Postgres 7.4.5 fails with Cygwin 1.5.18-1 (core dump)

Roland Walter schrieb:

> 
> This seems to be a problem of cygwin 1.5.18. Snapshots of the upcoming 
> 1.5.19 solved for some people on this list their problem to run 
> PostgreSQL. See the mail from Jeff Lu from 2005-08-12.

The author of the mail was VT Student. But you had found it already.

-- 
Roland Walter                  phone: +49 (0) 22 25 / 88 2-41 1
MOSAIC SOFTWARE AG               fax: +49 (0) 22 25 / 88 2-20 1
Am Pannacker 3                mailto: rwa (at) mosaic-ag (dot) com
D-53340 Meckenheim              http://www.mosaic-ag.com
-------  L E G A L    D I S C L A I M E R  ---------

Die Informationen in dieser Nachricht sind vertraulich 
und ausschliesslich fuer den Adressaten bestimmt. 
Kenntnisnahme durch Dritte ist unzulaessig. Die 
Erstellung von Kopien oder das Weiterleiten an weitere, 
nicht originaere und benannte Adressaten ist nicht 
vorgesehen und kann ungesetzlich sein. Die Meinungen 
in dieser Nachricht stellen lediglich die Meinungen 
des Senders dar. Falls Sie vermuten, dass diese 
Nachricht veraendert wurde, setzen Sie sich mit dem 
Absender in Verbindung. Der Absender uebernimmt ohne 
weitere Ueberpruefung keine Verantwortung fuer die 
Richtigkeit und Vollstaendigkeit des Inhalts. Unbefugte 
Empfaenger werden gebeten, die Vertraulichkeit der 
Nachricht zu wahren und den Absender sofort ueber 
(Continue reading)

Reini Urban | 5 Sep 2005 07:22
Picon
Gravatar

Re: Trouble initdb Postgresql 8.0.3 Cygwin

Alain Bouju schrieb:
> I compile Postgresql with cygwin.
> configure --prefix=/opt/postgresql-8.0.3
> make
> make install
> I change Path.
> All seems OK.
> But I try to use initdb nothing happen.
> Can you some tell me what I'm missing?

That nothing happens is very unlikely.
I assume your initdb fails with signal 12
like
creating configuration files... ok
creating template1 database in /var/postgresql/data/base/1... Signal 12

initdb: failed

This tells you that IPC couldn't be initialized, most likely that 
cygserver is not running or your /etc/cygserver.conf settings are too small.

--

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/

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

Picon
Favicon

Doubts

Hi

I just starting to get involved on the open source environment, my name is 
juan and really interested on learning about Postgre SQL.

Accordding what I have read, PostgreSQL is based on two main function or 
capabilities:

1.- Server Side, which main functions are Database Creating and Managing, as 
well as Maintenance and Troubleshooting.

2.-Client Side, which main functions are Database Query, and remote data 
Handling.

I am trying to install PostgreSQL on my computer, however it seems i require 
Unix System intalled on it before creating any table on PostgreSQL. Actually 
i have MS-DOS sistem on my computer so i will have to install Linux. My 
question is, can i install Mandrake 10.1 on my computer before installing 
PostgreSQL?, is that enough?. I think once Linux gets installed the whole 
syste will work on Unix Operating System then i would be able to install 
PostgreSQL, right?,or do i have to install a more powerfull Linux version in 
order to start creating the Database.

On the other hand, i downloaded "postgresql-8.0.3.zip" from postgreSQL page, 
is this the package the one i must install to initiate creating my database?

Thanks for your answers.
Kind Regards

---------------------------(end of broadcast)---------------------------
(Continue reading)

Picon
Favicon

doubt

Hi,

I just starting to get involved on the open source environment, my name is 
juan and really interested on learning about Postgre SQL.

Accordding what I have read, PostgreSQL is based on two main function or 
capabilities:

1.- Server Side, which main functions are Database Creating and Managing, as 
well as Maintenance and Troubleshooting.

2.-Client Side, which main functions are Database Query, and remote data 
Handling.

I am trying to install PostgreSQL on my computer, however it seems i require 
Unix System intalled on it before creating any table on PostgreSQL. Actually 
i have MS-DOS sistem on my computer so i will have to install Linux. My 
question is, can i install Mandrake 10.1 on my computer before installing 
PostgreSQL?, is that enough?. I think once Linux gets installed the whole 
syste will work on Unix Operating System then i would be able to install 
PostgreSQL, right?,or do i have to install a more powerfull Linux version in 
order to start creating the Database.

On the other hand, i downloaded "postgresql-8.0.3.zip" from postgreSQL page, 
is this the package the one i must install to initiate creating my database?

Thanks for your answers.
Kind Regards

---------------------------(end of broadcast)---------------------------
(Continue reading)

Problem while running initdb

I want to run the postmaster.
For that I have followed the steps which you have given.
I am getting the following error while running the initdb commend.
bash: initdb: command not found
Can u give the solution to solve this problem?

Regards,
Natrayan.
DISCLAIMER 
This message and any attachment(s) contained here are information that is confidential, proprietary to
HCL Technologies 
and its customers. Contents may be privileged or otherwise protected by law. The information is solely
intended for the 
individual or the entity it is addressed to. If you are not the intended recipient of this message, you are
not authorized to 
read, forward, print, retain, copy or disseminate this message or any part of it. If you have received this
e-mail in error, 
please notify the sender immediately by return e-mail and delete it from your computer

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo <at> postgresql.org so that your
       message can get through to the mailing list cleanly

William Makowski | 6 Sep 2005 16:40
Picon

Re: Doubts

> From: "JUAN ERNESTO FLORES BELTRAN" 
> Date: 2005/09/05 Mon PM 02:51:50 EDT
...
> I am trying to install PostgreSQL on my computer, however it seems i require 
> Unix System intalled on it before creating any table on PostgreSQL. Actually 
> i have MS-DOS sistem on my computer so i will have to install Linux. My 
> question is, can i install Mandrake 10.1 on my computer before installing 
> PostgreSQL?, is that enough?. I think once Linux gets installed the whole 
> syste will work on Unix Operating System then i would be able to install 
> PostgreSQL, right?,or do i have to install a more powerfull Linux version in 
> order to start creating the Database.

PostgreSQL can be run on several different operating 
systems.  A good place to start is by reading over the 
FAQ at the postgresql website - http://www.postgresql.org/docs/faq/.

This particular mailing list talks about running PostgreSQL
using Cygwin which is Linux like environment for Win9x, WinNT, etc.

Mandrake 10.1 (which is now Mandriva Linux 10.1) will have
no problem running PostgreSQL.  Mandriva actually comes 
with PostgreSQL as an installable package so you don't have
to download anything unless you want the most recently 
released version.

The real question is, "Can your computer handle Mandriva?".
Mandriva takes a decent amount of horsepower to run.
If you are running MS-DOS it must be an older computer.  
Depending on the capabilities of your computer you may be
forced to go with an older version of Linux or a Windows
(Continue reading)

William Makowski | 6 Sep 2005 16:57
Picon

Re: Problem while running initdb

> From: "Natrayan Kuppusamy - CTD , Chennai" 
> Date: 2005/09/05 Mon AM 01:23:54 EDT
> 
> I want to run the postmaster.
> For that I have followed the steps which you have given.
> I am getting the following error while running the initdb commend.
> bash: initdb: command not found
> Can u give the solution to solve this problem?

Looks like you are trying to initialize your database, not 
run postmaster.  It appears that initdb is not in your
search path.  Depending on how you installed, it should be
in either /usr/local/bin or /usr/bin.  These would need to
be added to the PATH environment variable for the user that
is executing the command.

Another way to locate initdb would be use the find command.
For example, at the / directory type find -iname initdb.

Bill

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


Gmane