Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit8ab1271

Browse files
committed
From: David Friend <dfriend@atlsci.atlsci.com>
Subject: [PATCHES] INSTALL changesThis patch modifies the INSTALL file. The changes are: - SPARC/Linux-ELF was added to the list of supported platforms. The special notes for it at the bottom of the file were removed. - Changed "database server" to "RDBMS database server". - Modified step 6 so that when you restore your database the tables will be owned by the original owners instead of the postgresql superuser. - Modified step 19 on diagnosing the regression tests for the SPARC Linux platform with a beta release. - Other minor changes.
1 parentcf88367 commit8ab1271

File tree

1 file changed

+33
-51
lines changed

1 file changed

+33
-51
lines changed

‎INSTALL

Lines changed: 33 additions & 51 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ This is file /usr/src/pgsql/INSTALL. It contains notes on how to install
55
PostgreSQL v6.1. Up to date information on PostgreSQL may be found at
66
http://www.postgresql.org.
77

8-
PostgreSQL isa database server. It is not completely ANSI SQL
8+
PostgreSQL isan RDBMS database server. It is not completely ANSI SQL
99
compliant, but with each release it gets closer.
1010

1111
PostgreSQL, formerly called Postgres95, is a derivative of Postgres 4.2
@@ -49,6 +49,7 @@ PostgreSQL has been tested on the following platforms:
4949
i386_solaris i386 Solaris
5050
irix5 SGI MIPS on IRIX 5.3
5151
linux Intel x86 on Linux 2.0 and Linux ELF
52+
SPARC on Linux ELF
5253
(For non-ELF Linux, see LINUX_ELF below).
5354
sparc_solaris SUN SPARC on Solaris 2.4
5455
sunos4 SUN SPARC on SunOS 4.1.3
@@ -82,7 +83,7 @@ To upgrade to PostgreSQL v6.1 do the following:
8283
3) Log into account postgres.
8384

8485
4) Ftp file ftp://ftp.postgresql.org/pub/postgresql-v6.1.tar.gz from the
85-
internet.
86+
internet. Store it in your home directory.
8687

8788
5) Some platforms use flex. If your system uses flex then make sure
8889
you have a good version. Type
@@ -116,15 +117,20 @@ To upgrade to PostgreSQL v6.1 do the following:
116117
/usr/bin/flex++ which points to flex.
117118

118119
6) If you are upgrading an existing system from any version before
119-
version 6.1 beta release 970512 then back up the current
120-
database. Type
120+
version 6.1 beta release 970525 then back up the current
121+
database. (If you don't mind the restored tables being owned by
122+
the postgres account then you may use your current pg_dumpall
123+
script instead of the new pg_dumpall script used below.) Type
124+
(with the gunzip line and the following line typed as one line):
121125
cd
122-
pg_dumpall > db.out
123-
If you wish to preserve object id's (oids), type
124-
cd
125-
pg_dumpall -o > db.out
126-
instead. However, unless you have a special reason for doing this,
127-
don't do it.
126+
gunzip -c postgresql-v6.1.tar.gz |
127+
tar xvf - src/bin/pg_dump/pg_dumpall
128+
chmod a+x src/bin/pg_dump/pg_dumpall
129+
src/bin/pg_dump/pg_dumpall > db.out
130+
rm -rf src
131+
If you wish to preserve object id's (oids), then use the -o
132+
option when running pg_dumpall. However, unless you have a
133+
special reason for doing this, don't do it.
128134

129135
Please note that if you are upgrading from a version prior to
130136
Postgres95 v1.09 then you must back up your database, install
@@ -370,15 +376,22 @@ To upgrade to PostgreSQL v6.1 do the following:
370376
in error handling for those math functions between this platform
371377
and the original Sun (?) Postgres v4.2 development environment.
372378

373-
Here is an example from a SPARC/Linux-ELF platform (note that this is
374-
for an "unsupported" platform). Using the 970516 beta version of
375-
PostgreSQL v6.1 the following tests "failed". float8 and geometry
376-
"failed" due to minor precision differences in floating point numbers.
377-
timespan and horology had different values from the expected
378-
"14 secs ago". datetime, abstime and tinterval had "GMT" for the time
379-
zone rather than "PST" or "PDT". These differences were due to a
380-
mis-typed string for the TZ environment variable from step (18).
381-
select_views failed for unknown reasons.
379+
Here is an example from the SPARC/Linux-ELF platform. Using the
380+
970525 beta version of PostgreSQL v6.1 the following tests "failed".
381+
float8 and geometry "failed" due to minor precision differences in
382+
floating point numbers. float8 also "failed" due to a table being
383+
printed out in place of the expected warning message of a floating
384+
point number being out of range. timespan and horology fail
385+
because of a bug on this platform that causes a timespan of
386+
"14 secs ago" to be returned as "1 day 23 hours 59 mins 46 secs
387+
ago". (If you don't intend to use the timespan data type, then
388+
this will not be a problem for you.) datetime also fails due
389+
to similar problems with the timespan data type. errors fail
390+
due to a parsing error. (This bug was introduced within the
391+
previous week, and is probably in the regression test itself.)
392+
select_views produces massively different output, but the
393+
differences are probably due to the same reasons the other tests
394+
failed.
382395

383396
Conclusion? If you do see failures, try to understand the nature of
384397
the differences and then decide if those differences will affect your
@@ -592,14 +605,8 @@ Linux:
592605
(Jalon Q. Zimmerman
593606
<sneaker@powergrid.electriciti.com> 5/11/95)
594607

595-
To compile with flex, you need a recent version (v2.5.2 or v2.5.4 or
596-
later). Otherwise, you will get a 'yy_flush_buffer' undefined error.
597-
Note, however, that flex v2.5.3 has a bug. See the FAQs.
598-
599608
BSD/OS:
600-
For BSD/OS 2.0 and 2.01, you will need to get flex version 2.5.2 or
601-
flex version 2.5.4 as well as the GNU dld library.
602-
Flex version 2.5.3 has a known bug on all platforms.
609+
For BSD/OS 2.0 and 2.01, you will need to get the GNU dld library.
603610

604611
NeXT:
605612
The NeXT port was supplied by Tom R. Hageman <tom@basil.icce.rug.nl>.
@@ -609,28 +616,3 @@ NeXT:
609616
binary releases of PostgreSQL for NEXTSTEP will be made available to
610617
the general public. Contact Info@RnA.nl for information.
611618

612-
SPARC Linux-elf:
613-
There was not time to finish adding support for this in the v6.1
614-
release. However, if you are running RedHat Linux v4.0 on a
615-
SPARC platform then install flex v2.5.4 and tell configure you
616-
have a "linux-elf" platform. After running "configure" and before
617-
compiling PostgreSQL, make the following changes:
618-
1) Edit src/GNUmakefile to comment out the call to lexflex and
619-
the if-then-else test that follows it. (This may not be
620-
necessary by the time v6.1 gets released.)
621-
2) Edit src/Makefile.global to change "-O2" to "-O".
622-
3) Edit src/backend/libpq/pqcomprim.c, near the start to replace
623-
#ifdef HAVE_ENDIAN_H
624-
# include <endian.h>
625-
#endif
626-
with
627-
/*
628-
#ifdef HAVE_ENDIAN_H
629-
# include <endian.h>
630-
#endif
631-
*/
632-
#define BYTE_ORDER LITTLE_ENDIAN
633-
For more details, look in ftp://ftp.postgresql.org/pub/majordomo/ports
634-
for a May 16, 1997 mail message called "regression tests on a
635-
SPARC/Linux platform".
636-

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp