aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
* I think in datatype.sgml line 506 or so:Bruce Momjian2000-11-16
| | | | | | | | | | | | | | | | | <entry>varchar(n)</entry> <entry>(4+x) bytes</entry> should be <entry>varchar(n)</entry> <entry>(4+n) bytes</entry> or <entry>varchar(x)</entry> <entry>(4+x) bytes</entry> Regards Laser Henry
* Repair markupPeter Eisentraut2000-11-15
|
* Rename parameter "hostname" to "virtual_host". Seemed very ambiguous...Peter Eisentraut2000-11-15
|
* Small polishing of syslog facility and ident settings. Only allow settingPeter Eisentraut2000-11-14
| | | | | at postmaster start, rename syslog_progid to syslog_ident, since syslog itself uses that term, fix doc markup.
* Extend CREATE DATABASE to allow selection of a template database to beTom Lane2000-11-14
| | | | | | | | | | cloned, rather than always cloning template1. Modify initdb to generate two identical databases rather than one, template0 and template1. Connections to template0 are disallowed, so that it will always remain in its virgin as-initdb'd state. pg_dumpall now dumps databases with restore commands that say CREATE DATABASE foo WITH TEMPLATE = template0. This allows proper behavior when there is user-added data in template1. initdb forced!
* Update and polish postmaster and postgres help output and man pages.Peter Eisentraut2000-11-14
|
* Add mention of new leading-slash handling of hostname to libpq docs.Bruce Momjian2000-11-14
|
* Add mention of hostname leading slash handling to all manual pages that use -h.Bruce Momjian2000-11-13
|
* Remove -k unix socketpath option from client side, allow hostname withBruce Momjian2000-11-13
| | | | leading slash to behave as a unix socket path.
* Ok, You guys are probably tired of me, BUT, here is another one, thatBruce Momjian2000-11-13
| | | | | | | | | | | | | adds the facility to set the program name used in syslog. (this includes the other ones). One gotcha, the parser doesn't like special characters in strings. For example, i tried to use pg-test, and if failed the parse coming from the postgresql.conf file. I don't think it's a showstopper.. Larry Rosenman
* UUNET is looking into offering PostgreSQL as a part of a managed webBruce Momjian2000-11-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | hosting product, on both shared and dedicated machines. We currently offer Oracle and MySQL, and it would be a nice middle-ground. However, as shipped, PostgreSQL lacks the following features we need that MySQL has: 1. The ability to listen only on a particular IP address. Each hosting customer has their own IP address, on which all of their servers (http, ftp, real media, etc.) run. 2. The ability to place the Unix-domain socket in a mode 700 directory. This allows us to automatically create an empty database, with an empty DBA password, for new or upgrading customers without having to interactively set a DBA password and communicate it to (or from) the customer. This in turn cuts down our install and upgrade times. 3. The ability to connect to the Unix-domain socket from within a change-rooted environment. We run CGI programs chrooted to the user's home directory, which is another reason why we need to be able to specify where the Unix-domain socket is, instead of /tmp. 4. The ability to, if run as root, open a pid file in /var/run as root, and then setuid to the desired user. (mysqld -u can almost do this; I had to patch it, too). The patch below fixes problem 1-3. I plan to address #4, also, but haven't done so yet. These diffs are big enough that they should give the PG development team something to think about in the meantime :-) Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get out what I have, which works (for the problems it tackles), now. With these changes, we can set up and run PostgreSQL with scripts the same way we can with apache or proftpd or mysql. In summary, this patch makes the following enhancements: 1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT, and command line options -k --unix-socket to the relevant programs. 2. Adds a -h option to postmaster to set the hostname or IP address to listen on instead of the default INADDR_ANY. 3. Extends some library interfaces to support the above. 4. Fixes a few memory leaks in PQconnectdb(). The default behavior is unchanged from stock 7.0.2; if you don't use any of these new features, they don't change the operation. David J. MacKenzie
* Add new 7.0.3 item to all places.Bruce Momjian2000-11-12
|
* Repair markupPeter Eisentraut2000-11-11
|
* Markup enhancements, some factual corrections.Peter Eisentraut2000-11-11
|
* Mention new AT TIME ZONE feature.Thomas G. Lockhart2000-11-11
|
* Eliminate word rotPeter Eisentraut2000-11-11
|
* Adjust INET/CIDR display conventions and reimplement some INET/CIDRTom Lane2000-11-10
| | | | | | | functions, per recent discussions on pghackers. For now, I have called the verbose-display formatting function text(), but will reconsider if enough people object. initdb forced.
* Add update of HISTORY file for 7.0.3.Bruce Momjian2000-11-10
|
* Fix typos.Tom Lane2000-11-10
|
* Add '-c name=val' flag for setting run-time parameters.Peter Eisentraut2000-11-08
|
* Add some configure checks for DocBook and related tools. With a somewhatPeter Eisentraut2000-11-05
| | | | | standard installation layout it should be possible to build the HTML and print documentation without additional manual setup.
* Update for recent developments (C++, shlib), minor fixesPeter Eisentraut2000-11-05
|
* Update for createlang options in docs.Bruce Momjian2000-11-04
|
* more procedural doc cleanupBruce Momjian2000-11-04
|
* Make PROCEDURAL optional in CREATE/DROP LANGUAGE.Bruce Momjian2000-11-04
|
* Update FAQ_DEV.Bruce Momjian2000-11-04
|
* Update FAQ_DEV.Bruce Momjian2000-11-04
|
* Add pg_dumpall --accounts-only option.Peter Eisentraut2000-11-02
|
* Change bool to boolean in docs.Bruce Momjian2000-11-02
|
* Add runtime configuration options to control permission bits and groupPeter Eisentraut2000-11-01
| | | | owner of unix socket.
* Fix java driver example.Bruce Momjian2000-10-27
|
* Integer binary operators, from Marko Kreen <marko@l-t.ee>. Renamed bitxorPeter Eisentraut2000-10-24
| | | | operator to '#' for consistency. Parser still needs work.
* Major overhaul of large-object implementation, by Denis Perchine withTom Lane2000-10-24
| | | | | | | | | | | | | kibitzing from Tom Lane. Large objects are now all stored in a single system relation "pg_largeobject" --- no more xinv or xinx files, no more relkind 'l'. This should offer substantial performance improvement for large numbers of LOs, since there won't be directory bloat anymore. It'll also fix problems like running out of locktable space when you access thousands of LOs in one transaction. Also clean up cruft in read/write routines. LOs with "holes" in them (never-written byte ranges) now work just like Unix files with holes do: a hole reads as zeroes but doesn't occupy storage space. INITDB forced!
* Minor updates/corrections for CREATE/DROP FUNCTION/AGGREGATE/OPERATOR.Tom Lane2000-10-23
|
* Some small polishing of Mark Hollomon's cleanup of DROP command: mightTom Lane2000-10-22
| | | | | | | | | as well allow DROP multiple INDEX, RULE, TYPE as well. Add missing CommandCounterIncrement to DROP loop, which could cause trouble otherwise with multiple DROP of items affecting same catalog entries. Try to bring a little consistency to various error messages using 'does not exist', 'nonexistent', etc --- I standardized on 'does not exist' since that's what the vast majority of the existing uses seem to be.
* Fix typo.Tom Lane2000-10-22
|
* Per my ongoing discussion with PeterE, here is the patch I applied toBruce Momjian2000-10-21
| | | | | | src/template/unixware: Larry Rosenman
* Remove portions of SSL documentation patch that were installed twice.Peter Eisentraut2000-10-21
|
* Fix discrepency in field names.Thomas G. Lockhart2000-10-20
| | | | | Thanks to Henry "He Weiping (Laser Henry)" <laser@zhengmai.com.cn> for catching this.
* Fix ids and xrefs to avoid duplicates.Thomas G. Lockhart2000-10-20
| | | | Remove copy/paste redundant extra section with slight merge of content.
* Remove ZP4, ZP5, ZP6 from docs since the current parser won't acceptThomas G. Lockhart2000-10-20
| | | | | | | | time zones with embedded numerals (parsing to a meaninless "ZP 4" instead). Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES is defined. Fix units in exposition on Julian calendar (from Lazer Henry I think...)
* Fix up id tag parameters to omit illegal underscores.Thomas G. Lockhart2000-10-20
| | | | Remove lots of extraneous trailing ^Ms from pg_restore.sgml.
* Fix silly typo in redirection example.Tom Lane2000-10-19
|
* The following patch was sent to the patches list:Bruce Momjian2000-10-18
| | | | | | | | | | | | | | | | | This patch forces the use of 'DROP VIEW' to destroy views. It also changes the syntax of DROP VIEW to DROP VIEW v1, v2, ... to match the syntax of DROP TABLE. Some error messages were changed so this patch also includes changes to the appropriate expected/*.out files. Doc changes for 'DROP TABLE" and 'DROP VIEW' are included. -- Mark Hollomon
* Added pg_restore (probably rename later)Philip Warner2000-10-18
|
* * doc/src/sgml/regress.sgml: Update for new driver script.Peter Eisentraut2000-10-17
| | | | | | | | | | | | * doc/src/sgml/installation.sgml: ditto. * src/test/regress/README: Regenerate. * doc/src/sgml/docguide.sgml: Explain how it was done. Explain how INSTALL and HISTORY are (now) generated. * doc/src/sgml/Makefile: Implement HISTORY generation to be analoguous to INSTALL.
* Remove duplicate requiressl entry.Bruce Momjian2000-10-17
|
* Update FAQ.Bruce Momjian2000-10-17
|
* Added pg_restore to allfiles.sgmlPhilip Warner2000-10-16
|
* Here is a patch against the same cvs tree as the SSL patch (Aug 20).Bruce Momjian2000-10-16
| | | | | | | | | | | | | | | | I hope I didn't mess the SGML up too bad, but somebody should definitly look that over. I tried to steal as much as I could from around :-) This patch updates: * Installation instructions (paragraph on how to compile with openssl) * Documentation of pg_hba.conf (added "hostssl" record docs) * Libpq documentation (added connection option, documentation of PQgetssl() function) * Add section on SSL to "Server Runtime Environment" If you beleive any particular area needs more attention, please let me know. //Magnus