Обсуждение: SCO Openserver & pg_hba.conf

Mark,

I saw your posting regarding the problem and if you've already obtained
a solution for this problem you can ignore this message .

There is a problem with Unix domain sockets and  the pg_hba.conf file on
SCO openserver unix . The only way I've been able to access the data on
SCO is via internat domain sockets.
1)To enable access this way , you have to restart the 'postmaster'
process with the '-i' option to enable this
    access method .
2) Any application which needs access to the database  would need to
connect via that same method : Hence  if
     you are connecting with 'psql' on your machine , you would do
something like 'psql -h localhost -d
     <dbname>' (I think that the -d flag is optional , you just need to
specify the database name .)
3) This applies to any application needing a connection (createdb , etc.
etc.)

Good Luck ,
Charles.

Hi,
Thanks for the suggestion! I've been trying to get it to work for ages and
using the -h option was the workaround I was looking for.

However I still have a small problem, in that when I do "CREATE UNIQUE INDEX
AcT_AcNo ON AccountTable (AccountNo);" where AccountNo is NUMERIC or DECIMAL
I get "ERROR:  Can't find a default operator class for type 1700.". If
AccountNo is INT2 or INT8 then there is no problem. Is this another problem
with SCO OpenServer?

To get PostgreSQL to compile, I had to edit Makefile.port after doing
configure, and remove the first 2 lines containing CCFLAGS and LDFLAGS.

Thanks,
Mark.

Mark Alliban wrote:
>
> Hi,
> Thanks for the suggestion! I've been trying to get it to work for ages and
> using the -h option was the workaround I was looking for.
>
> However I still have a small problem, in that when I do "CREATE UNIQUE INDEX
> AcT_AcNo ON AccountTable (AccountNo);" where AccountNo is NUMERIC or DECIMAL
> I get "ERROR:  Can't find a default operator class for type 1700.". If
> AccountNo is INT2 or INT8 then there is no problem. Is this another problem
> with SCO OpenServer?
>
> To get PostgreSQL to compile, I had to edit Makefile.port after doing
> configure, and remove the first 2 lines containing CCFLAGS and LDFLAGS.
>
> Thanks,
> Mark.
>

I believe this is fixed in current sources, since the TODO
shows a '-' in front of any TODO item which is believed to
be addressed in current. To see if it has been fixed, you
could always try the latest snapshot at ftp.postgresql.org.
Here's the TODO entry:

-Add index on NUMERIC/DECIMAL type(Jan)

Hope that helps,

Mike Mascari

Mark,

I think your best bet for a solution to the  index problem would be
posting a question to the sql mailing list , because I don't have a
solution to that .

1) The current postgresql source tree (Version 6.5.3) doesn't recognize
support for shared libraries under
     SCO Openserver 5.0.5 . To get all the shared libraries compiled , I
had to modify Makefile.shlib  to include
     support for sco . I would be interested to know if there's another
way to get this working .
     If oyu haven't got it working , I've attached my version of
'Makefile.shlib' you can take a look at it.
     If you're going to try this then I think you'll have to remove the
CFLAGS component in  'Makefile.port'
     because the  '-dy ' does something completely different on the
SCO native C compiler  as against the
     GNU C compiler . but the LDFLAGS component canremain the same (
LDFLAGS += -Wl,-Bexport ).

2) Were you able to get libpq++ to compile successfully ? I could only
get it to work by using
     GNU c/c++ compilation system (ersion 2.95.2). and I also had to use
this on the command line to make :
     make all  COPT="-g -DSTDC_HEADERS" . You also have to make changes
to  the  'templates/sco' file to
     make provision for the new compiler  & compiler tools that  you're
using (namely gcc,flex,bison etc. etc.).


Best Regards,
Charles.
#-------------------------------------------------------------------------
#
# Makefile.shlib
#    Common rules for building shared libraries
#
# Copyright (c) 1998, Regents of the University of California
#
# IDENTIFICATION
#    $Header: /usr/local/cvsroot/pgsql/src/Makefile.shlib,v 1.12.2.3 1999/07/30 04:13:44 scrappy Exp $
#
#-------------------------------------------------------------------------

# This file should be included by any Postgres module Makefile that wants
# to build a shared library (if possible for the current platform).
# A static library is also built from the same object files.
# RESTRICTION: only one library can be built per makefile...

# Before including this file, the module Makefile must define these variables:
# NAME                Name of library to build (no suffix nor "lib" prefix)
# SO_MAJOR_VERSION    Major version number to use for shared library
# SO_MINOR_VERSION    Minor version number to use for shared library
# OBJS                List of object files to include in library
# SHLIB_LINK        If shared library relies on other libraries, additional
#                    stuff to put in its link command
# (If you want a patchlevel, include it in SO_MINOR_VERSION, eg, "6.2".)
#
# The module Makefile must also include $(SRCDIR)/Makefile.global before
# including this file (Makefile.global sets PORTNAME and other needed symbols).
#
# The first rule in this file is a rule for "all", which causes both the
# static and shared libraries to be built (as well as all the object files).
# If you have other files that need to be made before building object files
# and libraries, put another rule for "all" before you include this file.
#
# Your install rule should look like
#
#    install: install-headers install-lib $(install-shlib-dep)
#
# where install-headers is only needed if you have header files to install
# (and, of course, it has to be provided by your makefile).  The rules
# install-lib and install-shlib are provided by this makefile --- they
# automatically install the plain and shared libraries into $(LIBDIR).
# install-shlib-dep is a variable that expands to install-shlib if the
# shared library needs to be installed, empty if not.
#
# Got that?  Look at src/interfaces/libpq/Makefile.in for an example.


# shlib and install-shlib-dep default to empty, and stay that way if we're
# on a platform where we don't know how to build a shared library.
shlib :=
install-shlib-dep :=

# For each platform we support shlibs on, set shlib and install-shlib-dep,
# and update flags as needed to build a shared lib.  Note we depend on
# Makefile.global (or really Makefile.port) to supply DLSUFFIX and other
# symbols.

# Try to keep the sections in some kind of order, folks...

ifeq ($(PORTNAME), aix)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX)
  SHLIB_LINK        += -lc
endif

ifeq ($(PORTNAME), bsd)
  ifdef BSD_SHLIB
    install-shlib-dep    := install-shlib
    shlib        := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
    ifdef ELF_SYSTEM
      LDFLAGS_SL    := -x -Bshareable -soname $(shlib)
    else
      LDFLAGS_SL    := -x -Bshareable -Bforcearchive
    endif
    CFLAGS        += $(CFLAGS_SL)
  endif
endif

ifeq ($(PORTNAME), bsdi)
  ifdef BSD_SHLIB
    ifeq ($(DLSUFFIX), .so)
      install-shlib-dep := install-shlib
      shlib            := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
      LDFLAGS_SL        += -shared
      CFLAGS            += $(CFLAGS_SL)
    endif
    ifeq ($(DLSUFFIX), .o)
      install-shlib-dep    := install-shlib
      shlib            := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
      LD            := shlicc
      LDFLAGS_SL         += -O -r
      CFLAGS            += $(CFLAGS_SL)
    endif
  endif
endif

ifeq ($(PORTNAME), freebsd)
  ifdef BSD_SHLIB
    install-shlib-dep    := install-shlib
    ifdef ELF_SYSTEM
      shlib        := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
      LDFLAGS_SL    := -x -shared -soname $(shlib)
    else
      shlib        := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
      LDFLAGS_SL    := -x -Bshareable -Bforcearchive
    endif
    CFLAGS        += $(CFLAGS_SL)
  endif
endif

ifeq ($(PORTNAME), hpux)
  install-shlib-dep    := install-shlib
# HPUX doesn't believe in version numbers for shlibs
  shlib                := lib$(NAME)$(DLSUFFIX)
  LDFLAGS_SL        := -b
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), irix5)
  install-shlib-dep := install-shlib
  shlib := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL := -shared
  CFLAGS += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), linux)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -Bdynamic -shared -soname $(shlib)
  LDFLAGS_ODBC        := -Bsymbolic -lc -lm
  SHLIB_LINK        += -lc
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), sco)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G -Bdynamic
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), solaris_i386)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G
  SHLIB_LINK        += -ldl -lsocket -lresolv -lnsl -lm -lc
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), solaris_sparc)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G
  SHLIB_LINK        += -ldl -lsocket -lresolv -lnsl -lm -lc
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), alpha)
  install-shlib-dep    := install-shlib
  shlib            := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        += -shared -expect_unresolved '*'
endif

ifeq ($(PORTNAME), svr4)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G
  CFLAGS            += $(CFLAGS_SL)
endif

ifeq ($(PORTNAME), univel)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G -z text
  CFLAGS            += $(CFLAGS_SL)
  ifeq ($(CXX), CC)
    CXXFLAGS += -Xw
    COMPILE.cc = $(CXX) $(CXXFLAGS:ll,alloca=ll) $(CPPFLAGS) $(TARGET_ARCH) -c
  endif
endif

ifeq ($(PORTNAME), unixware)
  install-shlib-dep    := install-shlib
  shlib                := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
  LDFLAGS_SL        := -G -z text
  CFLAGS            += $(CFLAGS_SL)
  ifeq ($(CXX), CC)
    CXXFLAGS += -Xw
    COMPILE.cc = $(CXX) $(CXXFLAGS:ll,alloca=ll) $(CPPFLAGS) $(TARGET_ARCH) -c
  endif
endif

ifeq ($(PORTNAME), win)
  install-shlib-dep    := install-shlib
  shlib                := $(NAME)$(DLSUFFIX)
endif

# Default target definition.  Note shlib is empty if not building a shlib.

all: lib$(NAME).a $(shlib)

# Rules to build regular and shared libraries

ifneq ($(PORTNAME), win)

lib$(NAME).a: $(OBJS)
ifdef MK_NO_LORDER
    $(AR) $(AROPT) $@ $(OBJS)
else
    $(AR) $(AROPT) $@ `lorder $(OBJS) | tsort`
endif
    $(RANLIB) $@

endif

ifneq ($(shlib),)
ifneq ($(PORTNAME), win)
ifneq ($(PORTNAME), aix)

# Normal case
$(shlib): $(OBJS)
    $(LD) $(LDFLAGS_SL) -o $@ $(OBJS) $(SHLIB_LINK)
    if [ "$(shlib)" != "lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)" ]; then \
        rm -f lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION); \
        $(LN_S) $(shlib) lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION); \
    fi
    if [ "$(shlib)" != "lib$(NAME)$(DLSUFFIX)" ]; then \
        rm -f lib$(NAME)$(DLSUFFIX); \
        $(LN_S) $(shlib) lib$(NAME)$(DLSUFFIX); \
    fi

else

# AIX case
$(shlib): lib$(NAME).a
    $(MKLDEXPORT) lib$(NAME).a $(LIBDIR) > lib$(NAME)$(EXPSUFF)
    $(LD) -H512 -bM:SRE -bI:$(SRCDIR)/backend/$(POSTGRES_IMP) -bE:lib$(NAME)$(EXPSUFF) -o $@ $< $(LDFLAGS)
$(SHLIB_LINK)

endif

else

# WIN case
$(shlib) lib$(NAME).a: $(OBJS) $(SRCDIR)/utils/dllinit.o
    $(DLLTOOL) --export-all --output-def $(NAME).def $(OBJS)
    $(DLLWRAP) -o $(shlib) --dllname $(shlib) --def $(NAME).def $(OBJS) $(SRCDIR)/utils/dllinit.o $(DLLINIT)
$(SHLIB_LINK)
    $(DLLTOOL) --dllname $(shlib) --def $(NAME).def --output-lib lib$(NAME).a

$(SRCDIR)/utils/dllinit.o: $(SRCDIR)/utils/dllinit.c
    $(MAKE) -C $(SRCDIR)/utils dllinit.o

endif
endif

# Rules to install regular and shared libraries

.PHONY: all install-lib install-shlib

install-lib: lib$(NAME).a
    $(INSTALL) $(INSTL_LIB_OPTS) lib$(NAME).a $(LIBDIR)/lib$(NAME).a

install-shlib: $(shlib)
    $(INSTALL) $(INSTL_SHLIB_OPTS) $(shlib) $(LIBDIR)/$(shlib)
ifneq ($(PORTNAME), win)
    if [ "$(shlib)" != "lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)" ]; then \
        cd $(LIBDIR); \
        rm -f lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION); \
        $(LN_S) $(shlib) lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION); \
    fi
    if [ "$(shlib)" != "lib$(NAME)$(DLSUFFIX)" ]; then \
        cd $(LIBDIR); \
        rm -f lib$(NAME)$(DLSUFFIX); \
        $(LN_S) $(shlib) lib$(NAME)$(DLSUFFIX); \
    fi
endif

# Rule to delete shared library during "make clean"

.PHONY: clean-shlib

clean-shlib:
    rm -f $(shlib) lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) lib$(NAME)$(DLSUFFIX)