agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFAQ
8+ messages / 7 participants
[nested] [flat]
* FAQ
@ 1992-08-14 16:24 Ng Kin Yee <ngkinyee@engin.umich.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Ng Kin Yee @ 1992-08-14 16:24 UTC (permalink / raw)
To: legacy
Can someone send me an FAQ on ver 3.0.1?
Thanks.
^ permalink raw reply [nested|flat] 8+ messages in thread
* FAQ
@ 1993-07-06 20:36 Joseph Rajkumar <rajkumar@rajkumar.worldbank.org>
1993-07-06 21:41 ` Re: FAQ Paul M. Aoki <aoki@postgres.berkeley.edu>
0 siblings, 1 reply; 8+ messages in thread
From: Joseph Rajkumar @ 1993-07-06 20:36 UTC (permalink / raw)
To: legacy
Hi Folks
Recently I have installed postgres on my sun workstation
running SunOS 4.1.3. This is Postgres Release 4.1.
I have a couple of questions:-
1) First of all, where I can get the FAQ for postgres.
2) After having able to run the sample given on page 10
of the postgres installation instruction sheet, when I executed
the query, I got only postgres, (this is what I expected), but
when I tried to createuser while logged in as postgres, I am
getting the message:
postgres@rajkumar[83]:createuser
/usr/local/postgres/bin/createuser: postgres cannot create users.
Thanks
Joseph Rajkumar
PS: According to the man1/createuser.1, I should be able to
create a user, when I am logged in as postgres??
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: FAQ
1993-07-06 20:36 FAQ Joseph Rajkumar <rajkumar@rajkumar.worldbank.org>
@ 1993-07-06 21:41 ` Paul M. Aoki <aoki@postgres.berkeley.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Paul M. Aoki @ 1993-07-06 21:41 UTC (permalink / raw)
To: legacy
rajkumar@rajkumar.worldbank.org (Joseph Rajkumar) writes:
> 1) First of all, where I can get the FAQ for postgres.
from the 4.1 distribution directory:
postgres.berkeley.edu:pub/postgres/postgres-v4r1/postgres-faq
> when I tried to createuser while logged in as postgres, I am
> getting the message:
> postgres@rajkumar[83]:createuser
> /usr/local/postgres/bin/createuser: postgres cannot create users.
the new (one-week-old) postgres-setup.cat tells you not to run the
regression test as user postgres. (the old one did not..)
to fix it up, run
replace pg_user (usesuper="t"::bool)
where pg_user.usename="postgres"
as user postgres.
i think this should be fixed in the distribution but that's not my
decision.
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
^ permalink raw reply [nested|flat] 8+ messages in thread
* FAQ
@ 1993-07-14 05:46 Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 0 replies; 8+ messages in thread
From: Paul M. Aoki @ 1993-07-14 05:46 UTC (permalink / raw)
To: legacy
since we are still being inundated with DEL requests..
Frequently Asked Questions about Postgres
Q: What Is Postgres?
Postgres is a database research project under Prof. Michael Stonebraker
at U. C. Berkeley. To facilitate research efforts, a software test-bed was
created; this is the "Postgres" DBMS software. The Postgres DBMS
is extended relational or object oriented, depending on the buzzword du
jour.
The major purpose of this software is to provide a platform and a basis
for the testing of implementations of new ideas in database research.
Several graduate students, staff members, as well as undergraduate
programmers have been working on the implementation of the Postgres
software. After this paragraph, all references to "Postgres" refer to the
software itself.
Postgres Is:
o Relational. One of the major goals of Postgres is to show that
an essentially relational DBMS can be extended to handle complex objects,
rules, and be highly extensible.
o Highly extensible. Postgres allows user-defined operators, user-defined
objects, and user-defined functions.
o While Postgres is relational, object oriented ideas have been implemented
in Postgres (inheritance, etc).
o Numerous other features, such as query language procedures, rules, etc.
which are beyond the scope of this discussion.
For more info on the Postgres research itself, you can get the
Postgres technical documentation described below.
Q. What is the connection between Postgres and Ingres?
A. There is none, aside from Prof. Stonebraker. There is no compatibility
between the two software packages, and the research projects have
differing objectives. We do not support University Ingres at all;
questions about it should be sent to the USENET group "comp.databases".
Q. How do I get the Postgres software package?
A. In one of two ways:
1. Via anonymous FTP from postgres.berkeley.edu (Internet 128.32.149.1);
the directory that contains relevent files is
pub/postgres/postgres-v4r1
(Note: transmit .Z files in BINARY mode.)
2. If you don't have Internet access, you can get Postgres by sending
a check for US $150 payable to
Regents of the University of California
This should be addressed to
The Postgres Project
557 Evans Hall
University of California
Berkeley, CA 94720
Indicate in your accompanying letter whether you want the system on a
9-track tape at 1600 BPI, at 6250 BPI, on a Sun cartridge tape (QIC 24
format), or on a TK50 DEC cartridge tape.
Sorry - we cannot deliver Postgres via e-mail, netnews, or in a finger .plan
file.
Q. What is the Postgres query language?
A. Postquel, which is an incompatible superset of Quel.
Q. What about SQL support?
A. We do not support SQL at this time.
Q. What does Postgres run on?
A. Postgres 4.1 is supported on Sparc, and DECstations running Ultrix
4.2 or higher.
The experience of outside developers indicates that Postgres is relatively
easy to port to any system that supports:
1. Berkeley-style sockets
2. System V shared memory and semaphores
3. A K & R compatible C compiler
4. Other "normal" Unix system calls
Some header file problems may be encountered; these are easily fixed by
a programmer knowledgable with the local OS. The most difficult part
of the port is porting the dynamic object code loader, which requires
interpreting object file headers.
Q. How do I get papers about Postgres?
A. The documents and manpages are available directly in the POSTGRES source.
At the top level there are pre-formatted manual pages and a reference
manual. There a re a number of other documents in the src/old_doc directory
and there is a directory in there that has pre-formatted postscript files.
To order hard-copies of technical reports individually; for more details,
send e-mail or call Sarah Burke at (510) 642-3417; her e-mail address
is
elisa@postgres.berkeley.edu
Q. What is the status of the Postgres implementation?
A. It is not up to commercial levels of reliability. I would not want
_my_ payroll records in it :-) However, it is quite adaquate for
managing scientific and experimental datasets and as an instructional
system. Its speed on applications which stress transaction processing
is not particularly good, but it is within about 50% of commercial systems
on the more "report-oriented" Wisconsin benchmark, and is twice as fast
as University Ingres on the Wisconsin.
Q. Does Postgres have a user interface? A report generator?
A. No and no, not as shipped.
Q. What about a C-callable interface for writing applications?
A. There most definitiely is one, called libpq. There is also an interface
for referencing Postgres data from shell scripts. Get the Postgres
reference manual for details.
Q. Is there a BBS/discussion group about Postgres?
A. Yes - the mailing list
postgres@postgres.berkeley.edu
has over two hundred readers and gateways; you can subscribe to the mailing
list by sending mail to
postgres-request@postgres.berkeley.edu
with "ADD" as the Subject.
You UNsubscribe from the mailing list by sending mail to
postgres-request@postgres.berkeley.edu
with "DEL" as the Subject.
Q. How do I make a bug report?
A. If you find a bug, send a description of your database schema, queries,
and a stack dump (type "where" in DBX) if possible to
bug-postgres@postgres.berkeley.edu
Q. How do I find out about known bugs?
A. The known bug list for version 4.1 does not exist yet, but will
be placed in the file
pub/postgres/postgres-v4r1/postgres.bugs
as soon as we start getting feedback on the release.
Q. Please summarize the important files on postgres.berkeley.edu
A. Please see pub/postgres/postgres-v4r1/README
Q. Please summarize the important Postgres mailing aliases
A. Mailing Address Purpose
postgres@postgres Postgres general discussion and announcements
postgres-request@postgres Administrative requests (ADD/DEL)
bug-postgres@postgres Postgres bug reports
postgres-questions@postgres Questions to the developers of Postgres
Q. Please summarize the main contacts at the Postgres group
A. Address/Phone Role
Marc Teitelbaum Postgres Chief Programmer
marc@postgres.berkeley.edu
(510) 643-6448
Michelle Mattera Assistant to the Postgres group
michelle@postgres.berkeley.edu
(510) 642-3417
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
^ permalink raw reply [nested|flat] 8+ messages in thread
* FAQ
@ 1994-05-18 09:26 David Alan Nelson <D.A.Nelson@newcastle.ac.uk>
1994-05-18 09:52 ` Re: FAQ Paul M. Aoki <aoki@postgres.Berkeley.EDU>
1994-05-18 23:54 ` Re: FAQ Chris Bitmead <chrisb@cssc-syd.tansu.com.au>
0 siblings, 2 replies; 8+ messages in thread
From: David Alan Nelson @ 1994-05-18 09:26 UTC (permalink / raw)
To: legacy
Can anybody tell me if there's a Postgres FAQ around, and where it is?
Cheers
Dave
--
Mail ID : D.A.Nelson@newcastle.ac.uk
Computing Science, University of Newcastle upon Tyne, UK. (091) 222 8789
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: FAQ
1994-05-18 09:26 FAQ David Alan Nelson <D.A.Nelson@newcastle.ac.uk>
@ 1994-05-18 09:52 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
1 sibling, 0 replies; 8+ messages in thread
From: Paul M. Aoki @ 1994-05-18 09:52 UTC (permalink / raw)
To: David Alan Nelson <D.A.Nelson@newcastle.ac.uk>; +Cc: legacy
"David Alan Nelson" <D.A.Nelson@newcastle.ac.uk> writes:
> Can anybody tell me if there's a Postgres FAQ around, and where it is?
ftp://s2k-ftp.CS.Berkeley.EDU/pub/postgres/postgres.faq
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: FAQ
1994-05-18 09:26 FAQ David Alan Nelson <D.A.Nelson@newcastle.ac.uk>
@ 1994-05-18 23:54 ` Chris Bitmead <chrisb@cssc-syd.tansu.com.au>
1 sibling, 0 replies; 8+ messages in thread
From: Chris Bitmead @ 1994-05-18 23:54 UTC (permalink / raw)
To: D.A.Nelson@newcastle.ac.uk; +Cc: legacy
Following is a Postgres FAQ although it is a little old.
Frequently Asked Questions about POSTGRES
Q. What Is POSTGRES?
A. POSTGRES was a database research project directed by Prof. Michael
Stonebraker at U. C. Berkeley. To facilitate research efforts, a
software test-bed was created; this is the "POSTGRES" DBMS
software. The POSTGRES DBMS is extended relational or object
oriented, depending on the buzzword du jour.
The major purpose of this software is to provide a platform and a
basis for the testing of implementations of new ideas in database
research. Several graduate students, staff members, as well as
undergraduate programmers have contributed to the implementation
of the POSTGRES software. After this paragraph, all references to
"POSTGRES" refer to the software itself.
As of this writing, POSTGRES is no longer an official research
effort at U.C. Berkeley.
POSTGRES is:
o Relational. One of the major goals of POSTGRES was to show
that an essentially relational DBMS can be extended to handle
complex objects, rules, and be highly extensible.
o Highly extensible. POSTGRES allows user-defined operators,
types, functions and access methods.
o While POSTGRES is relational, object-oriented ideas have been
implemented in POSTGRES (inheritance, etc).
POSTGRES also has many other features, such as query language
procedures, rules, triggers, etc., which are beyond the scope of
this discussion.
For more info on the POSTGRES research itself, you should get the
POSTGRES technical documentation described below.
Q. What is the connection between POSTGRES and University Ingres?
A. There is none, aside from Prof. Stonebraker. There is no
compatibility between the two software packages, and the research
projects had differing objectives. We do not support University
Ingres at all. Questions about it should be sent to the USENET
newsgroup "comp.databases" or "comp.databases.ingres". You can
also, in a pinch, try the mailing list:
ingres-mail@idiom.berkeley.ca.us
Q. How do I get the POSTGRES software package?
A. In one of two ways:
1. Via anonymous FTP from the host s2k-ftp.CS.Berkeley.EDU
(IP address as of this writing: 128.32.149.157)
The directory that contains the relevant files is:
pub/postgres/postgres-v4r2
(Note: transmit .Z files in BINARY mode.)
2. If you don't have Internet access, you can get POSTGRES by sending a
check for US$150 payable to
Regents of the University of California
This should be addressed to
The POSTGRES Project
557 Evans Hall
University of California
Berkeley, CA 94720
Indicate in your accompanying letter whether you want the
system on a 9-track tape at 1600 BPI or 6250 BPI, a QIC 24
cartridge tape, a DEC TK50 cartridge tape, a 4mm DAT tape, or
an Exabyte 2GB 8mm tape.
We do not distribute POSTGRES in any other format (such as
FTPmail). However, you can also get POSTGRES on a variety of
"freeware" CDROMs (such as those from PrimeTime Freeware or
Yggdrasil Computing). We have nothing to do with the distributors
of these CDROMs, and if you are interested in obtaining POSTGRES
this way you should contact your local computer bookstore. Do
note that, if you can get them, they will cost much less than
US$150.
Q. What is the POSTGRES query language?
A. PostQUEL, which is an incompatible, extended version of QUEL (the
Ingres query language).
Q. What about SQL support?
A. POSTGRES does not support SQL. A commercial version of POSTGRES
produced by Montage Software, Inc. (see below) does support SQL.
Q. What does POSTGRES run on?
A. POSTGRES 4.2 is known to run on Sun-4 (SPARC) computers running SunOS
4.1.2 or higher, DECstation 3100 and 5000 (MIPS) computers running
Ultrix 4.2 or higher, H-P 9000 Model 700 and 800 (PA-RISC)
computers running HP-UX 9.00 or higher, DECstation 3000 (Alpha
AXP) running OSF/1 1.3, and IBM RS/6000 (POWER) running AIX 3.2.3
or higher.
The experience of outside developers indicates that POSTGRES is
relatively easy to port to any system that supports:
1. Berkeley-style sockets
2. System V shared memory and semaphores
3. A K&R-compatible C compiler
4. Other "normal" Unix system calls
For example, versions of POSTGRES have been ported to Windows NT.
Some header file problems may be encountered; these are easily
fixed by a programmer knowledgable with the local OS.
Q. How do I get papers about POSTGRES?
A. The documents and manpages are available directly in the POSTGRES
source. At the top level there are pre-formatted manual pages and
a reference manual. There are a number of other documents in the
src/doc directory and there is a directory in there that has
pre-formatted postscript files. You can order hard-copies of
technical reports individually. For more details, send e-mail or
call Michelle Mattera at (510) 642-3417; her e-mail address is
michelle@postgres.berkeley.edu
Q. What is the status of the POSTGRES implementation?
A. It is not up to commercial levels of reliability. I would not want
_my_ payroll records in it :-) However, it is quite adequate for
managing scientific and experimental datasets and as an
instructional system. Its speed on applications which stress
transaction processing is not particularly good, but it is within
about 50% of commercial systems on the more "report-oriented"
Wisconsin benchmark, and is twice as fast as University Ingres on
the Wisconsin.
Q. Does POSTGRES have a user interface? A report generator? An
embedded query language interface?
A. No, no and no. On the other hand, "pgbrowse," a powerful and
extensible graphical user interface based on Tcl/TK, is available
from crseo.ucsb.edu (128.111.100.50) in pub/pgbrowse.
Q. What about a C-callable interface for writing applications?
A. There most definitely is one, called libpq. There is also an
interface for referencing POSTGRES data from shell and perl
scripts. See the POSTGRES Reference Manual for details.
Q. Is there a discussion group about POSTGRES?
A. Yes - the mailing list
postgres@postgres.berkeley.edu
has (as of this writing) over six hundred readers and gateways; you
can subscribe to the mailing list by sending mail to
postgres-request@postgres.berkeley.edu
with "ADD" as the Subject.
You UNsubscribe from the mailing list by sending mail to
postgres-request@postgres.berkeley.edu
with "DEL" as the Subject.
Q. How do I make a bug report?
A. If you find a bug, send a description of your database schema,
queries, and a stack dump (type "where" in DBX) if possible to
bug-postgres@postgres.berkeley.edu
Q. How do I find out about known bugs?
A. The known bug list for version 4.2 does not exist yet, but will be
placed in the file
pub/postgres/postgres-v4r2/postgres.bugs
as soon as we start getting feedback on the release.
Q. Please summarize the important files on s2k-ftp.cs.berkeley.edu.
A. Please see pub/postgres/postgres-v4r2/README.
Q. Please summarize the important POSTGRES mailing aliases.
A. Mailing Address Purpose
postgres@postgres POSTGRES general discussion and
announcements
postgres-request@postgres Administrative requests (ADD/DEL)
bug-postgres@postgres POSTGRES bug reports
postgres-questions@postgres Questions to the developers of POSTGRES
(see response to the next question)
Q. Please summarize the main contacts at the POSTGRES group.
A. Unfortunately, POSTGRES is no longer an active research project at
U.C. Berkeley, so there is no longer a POSTGRES group. Some of the
developers will probably be staying in touch on the previously
mentioned mailing lists, so that is your best bet.
Q. Is there a commercial version of POSTGRES?
A. Yes. Montage Software, Inc. has performed a substantial amount of
bullet-proofing and performance improvement and has added many new
features (true log-based crash recovery, an type system that makes
sense, SQL support). They also provide technical support. You can
contact them at:
Montage Software, Inc.
1111 Broadway, Suite 2000
Oakland, CA 94607
510-652-8000
510-652-8050 (fax)
sales@montage.com
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
^ permalink raw reply [nested|flat] 8+ messages in thread
* FAQ
@ 1995-10-16 00:20 Len Rose <len@netsys.com>
0 siblings, 0 replies; 8+ messages in thread
From: Len Rose @ 1995-10-16 00:20 UTC (permalink / raw)
To: legacy
Hi.. I have just joined the list and was looking for an up-to-date FAQ. I
have been unable to login to postgres.berkeley.edu as anonymous to locate
the sources, and would like to get myself up to date before asking anything
stupid.
Thanks
Len
--
len@netsys.com
http://www.netsys.com
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~1995-10-16 00:20 UTC | newest]
Thread overview: 8+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1992-08-14 16:24 FAQ Ng Kin Yee <ngkinyee@engin.umich.edu>
1993-07-06 20:36 FAQ Joseph Rajkumar <rajkumar@rajkumar.worldbank.org>
1993-07-06 21:41 ` Paul M. Aoki <aoki@postgres.berkeley.edu>
1993-07-14 05:46 FAQ Paul M. Aoki <aoki@postgres.Berkeley.EDU>
1994-05-18 09:26 FAQ David Alan Nelson <D.A.Nelson@newcastle.ac.uk>
1994-05-18 09:52 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
1994-05-18 23:54 ` Chris Bitmead <chrisb@cssc-syd.tansu.com.au>
1995-10-16 00:20 FAQ Len Rose <len@netsys.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox