headers
Matt Fluet | 3 Oct 2004 06:35
Picon
Favicon

Segmentation Fault on XP (Signal 11)

I'm trying to create a user on a postgreSQL 7.4.1 installation on the cygwin 
platform.  My OS is XP pro SP2.  I keep getting a "Segmentation fault (core 
dumped)" message from the command line (it shows up as a "Signal 11" error 
when run from a shell script).

$ createuser -d -P -A dcts
Enter password for new user:
Enter it again:
Segmentation fault (core dumped)

The psql and createdb commands produce the same error for me.  I have 
installed the exact same version of cygwin on windows 2000 professional, and 
these commands work fine.

I've tried disabling my firewall, uninstalling my McAfee virus software, the 
LSP fix utility, uninstalling SP2, building the database from source, and 
installing the win32 ports for 7.5 and 8.0 beta.  None of these actions made 
a difference.  Is there a known issue with postgres on XP pro SP2?  Has 
anyone gotten this working and can provide any info on similar issues 
encountered?

Thanks,

Matt

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

Permalink | Reply | 0 comments |
headers
Wayne Phillips | 4 Oct 2004 20:23
Picon

on w2k or xp?

Do I have to have Cygwin to run pg on Win2000 or XP?

XP Home doesn't have IIS. Do I have to have IIS to run Apache or any server?
TIA,
Wayne

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

               http://www.postgresql.org/docs/faqs/FAQ.html
Permalink | Reply | 0 comments |
headers
Wayne Phillips | 4 Oct 2004 21:14
Picon

on w2k or xp?

>>Do I have to have Cygwin to run pg on Win2000 or XP?
>
>for 7.x yes, for 8.x no.

Doesn't 8.x have bugs?
Wayne

---------------------------(end of broadcast)---------------------------
TIP 3: 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
Permalink | Reply | 0 comments |
headers
Reini Urban | 4 Oct 2004 23:16
Picon
Gravatar

cygwin test package available

FYI:
Soon an experimantal cygwin package will be available via the cywin
setup.exe installer, based on a post-beta3 cvs snapshot from today.
i.e.
* tablespace issues - junctions - not yet solved.
* without the missing earthdistance

Just to gather more feedback from the cygwin folks.
This time contrib is added to the cygwin package. It was not in 7.4.x.

Name: postgresql-8.0.0cvs-1 (experimental)
--

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

---------------------------(end of broadcast)---------------------------
TIP 3: 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
Permalink | Reply | 5 comments |
headers
Dave Page | 4 Oct 2004 23:27
Picon

Re: cygwin test package available


> -----Original Message-----
> From: pgsql-hackers-owner <at> postgresql.org 
> [mailto:pgsql-hackers-owner <at> postgresql.org] On Behalf Of Reini Urban
> Sent: 04 October 2004 22:17
> To: pgsql-hackers <at> postgresql.org
> Cc: pgsql-cygwin <at> postgresql.org
> Subject: [HACKERS] cygwin test package available
> 
> FYI:
> Soon an experimantal cygwin package will be available via the 
> cywin setup.exe installer, based on a post-beta3 cvs snapshot 
> from today.
> i.e.
> * tablespace issues - junctions - not yet solved.
> * without the missing earthdistance

Earthdistance is there, just umm, hidden. Following a discussion on
another list earlier today, it should be fixed sometime tomorrow.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: 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
Permalink | Reply | 2 comments |
headers
Reini Urban | 4 Oct 2004 23:46
Picon
Gravatar

Re: [HACKERS] cygwin test package available

Dave Page schrieb:
>>-----Original Message-----
>>From: pgsql-hackers-owner <at> postgresql.org 
>>[mailto:pgsql-hackers-owner <at> postgresql.org] On Behalf Of Reini Urban
>>Sent: 04 October 2004 22:17
>>To: pgsql-hackers <at> postgresql.org
>>Cc: pgsql-cygwin <at> postgresql.org
>>Subject: [HACKERS] cygwin test package available
>>
>>FYI:
>>Soon an experimantal cygwin package will be available via the 
>>cywin setup.exe installer, based on a post-beta3 cvs snapshot 
>>from today.
>>i.e.
>>* tablespace issues - junctions - not yet solved.
>>* without the missing earthdistance
> 
> 
> Earthdistance is there, just umm, hidden. Following a discussion on
> another list earlier today, it should be fixed sometime tomorrow.

Yes, I saw it. I was in a hurry because of the tablespace test.
And I actually had it in my previous build early this day.
But then I accidently deleted my whole 8.x archive when I reproduced my 
package building step, so it got deleted.

Anyway, it will be in the next update of course. As soon as the 
tablespace symlinks are fixed and possible other reports lead to more fixes.
--

-- 
Reini Urban
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jason Tishler | 5 Oct 2004 13:04

Re: cygwin test package available

Reini,

On Mon, Oct 04, 2004 at 11:16:49PM +0200, Reini Urban wrote:
> This time contrib is added to the cygwin package. It was not in 7.4.x.

Actually, contrib was included:

    $ tar -tjf postgresql-7.4.5-1.tar.bz2 | fgrep contrib
    usr/share/doc/postgresql-7.4.5/contrib/
    usr/share/doc/postgresql-7.4.5/contrib/autoinc.example
    ...

Jason

--

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

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

               http://archives.postgresql.org
Permalink | Reply | 3 comments |
headers
Marek Lewczuk | 5 Oct 2004 17:22

[PORTS] postgresql 8.0 and tsearch2 install under cygwin

Hello,
I've just made successful installation of PostgreSQL 8.0 on Cygwin but I 
have some problems with installing tsearch2 contrib module. This is what 
make produce:

dict_ispell.o(.text+0x1ec):dict_ispell.c: undefined reference to 
`_pg_strcasecmp
'
dict_ispell.o(.text+0x31e):dict_ispell.c: undefined reference to 
`_pg_strcasecmp
'
dict_ispell.o(.text+0x425):dict_ispell.c: undefined reference to 
`_pg_strcasecmp
'
wparser_def.o(.text+0xd1f):wparser_def.c: undefined reference to 
`_pg_strcasecmp
'
wparser_def.o(.text+0xd7e):wparser_def.c: undefined reference to 
`_pg_strcasecmp
'
wparser_def.o(.text+0xdb7):wparser_def.c: more undefined references to 
`_pg_strc
asecmp' follow
ispell/SUBSYS.o(.text+0x9d3):spell.c: undefined reference to 
`_pg_strncasecmp'
ispell/SUBSYS.o(.text+0xa3a):spell.c: undefined reference to 
`_pg_strncasecmp'
ispell/SUBSYS.o(.text+0xa6a):spell.c: undefined reference to 
`_pg_strncasecmp'
ispell/SUBSYS.o(.text+0xa91):spell.c: undefined reference to
(Continue reading)

Permalink | Reply | 1 comment |
headers
Reini Urban | 5 Oct 2004 18:23
Picon
Gravatar

Re: postgresql 8.0 and tsearch2 install under cygwin

Marek Lewczuk schrieb:
> I've just made successful installation of PostgreSQL 8.0 on Cygwin but I 
> have some problems with installing tsearch2 contrib module. This is what 
> make produce:
> 
> dict_ispell.o(.text+0x1ec):dict_ispell.c: undefined reference to 
> `_pg_strcasecmp

Yes,
Most contrib DLL's miss -lpgport.
You may want to add this to the Makefile:

SHLIB_LINK += -lpgport
or to BE_DLLLIBS in Makefile.cygwin

---------------------------(end of broadcast)---------------------------
TIP 3: 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
Permalink | Reply | 0 comments |
headers
Marek Lewczuk | 6 Oct 2004 10:21

initdb and postgresql 8

I'm trying to initialize postgresql 8.0 but initdb produce below errors:
$ initdb
The files belonging to this database system will be owned by user "ml".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... FATAL: 
could no
t create shared memory segment: Function not implemented
DETAIL:  Failed system call was shmget(key=1, size=1171456, 03600).
child process exited with exit code 1
initdb: failed
initdb: removing data directory "/usr/local/pgsql/data"
[1]+  Done                    ipc-daemon2

Is 8.0 version working on Cygwin ? Thanks for any help.
(Continue reading)

Permalink | Reply | 0 comments |

Gmane