database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
ㆍPostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
PostgreSQL Tutorials 3817 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 3817
PostgreSQL FAQ - Sun Solaris specific
작성자
정재익(advance)
작성일
2001-12-29 10:17
조회수
4,680

============================================================

Frequently Asked Questions (FAQ) for PostgreSQL 7.1

Sun Solaris specific

to be read in conjunction with the installation instructions

============================================================

last updated: $Date: 2001/04/08 16:36:13 $

 

current maintainer: Marc Liyanage (liyanage@access.ch)

original author: Marc Liyanage (liyanage@access.ch)

 

Contents:

 

1) What tools do I need to build and install PostgreSQL on Solaris?

2) Why do I get problems when building with OpenSSL support?

3) Why does configure complain about a failed test program?

4) A bunch of regression tests fail in random, non-reproduceable

patterns. What's wrong?

 

 

1) What tools do I need to build and install PostgreSQL on Solaris?

 

You will need

 

- GNU zip (for installing the documentation)

- GNU make

- GNU readline library (optional)

 

Both GCC and the Sun compiler suite work.

 

If you like Solaris packages, you can find these tools here:

http://www.sunfreeware.com

 

If you prefer sources, look here:

http://www.gnu.org/order/ftp.html

 

 

2) Why do I get problems when building with OpenSSL support?

 

When you build PostgreSQL with OpenSSL support you might get

compilation errors in the following files:

 

src/backend/libpq/crypt.c

src/backend/libpq/password.c

src/interfaces/libpq/fe-auth.c

src/interfaces/libpq/fe-connect.c

 

This is because of a namespace conflict between the standard

/usr/include/crypt.h header and the header files provided by OpenSSL.

 

Upgrading your OpenSSL installation to version 0.9.6a fixes this

problem.

 

 

3) Why does configure complain about a failed test program?

 

This is probably a case of the run-time linker being unable to find

libz or some other non-standard library, such as libssl. To point it

to the right location, set the LD_LIBRARY_PATH environment variable,

e.g.,

 

LD_LIBRARY_PATH=/usr/local/lib:/usr/local/ssl/lib

export LD_LIBRARY_PATH

 

and restart configure. You will also have to keep this setting

whenever you run any of the installed PostgreSQL programs.

 

In the future, consider installing the offending libraries so they

provide their own "rpath".

 

 

4) A bunch of regression tests fail in random, non-reproduceable

patterns. What's wrong?

 

A lot of users have reported that the parallel regression test suite causes a varying, unpredictable set of tests to fail, usually tests in the second half of the run. The failure is usually a failure to connect to the server at all, or an abrupt loss of the connection.

Invariably, these problems go away when the regression test suite is

changed to use TCP/IP sockets instead of Unix domain sockets. (Change line 163 of src/test/regress/pg_regress to match *solaris*; yes, there should be an easier way to do this.) Since a number of users do not seem to have any problems with this at all, we do not claim that "Unix domain sockets are broken on Solaris", but feel free to draw your own

conclusions, or better yet, share your insights with the rest of us.

 

원본 출처 : http://www.ca.postgresql.org/docs/faq-solaris

[Top]
No.
제목
작성자
작성일
조회
3831부분 인덱스 사용법
정재익
2002-01-01
6482
3822Quick HOWTO - connecting StarOffice Win or Lin to PostGreSQL using ODBC
정재익
2001-12-30
5657
3820Freeware PostgreSQL/iX for HP e3000 MPE
정재익
2001-12-30
5048
3817PostgreSQL FAQ - Sun Solaris specific
정재익
2001-12-29
4680
3816PostgreSQL Install FAQ
정재익
2001-12-29
6598
3794PostgreSQL Lecture
정재익
2001-12-27
6224
3788Combining Perl and PostgreSQL - Part 2: Procedures with PL/pgSQL
정재익
2001-12-26
5174
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다