From 4060456291693431d57ca64adf3973ea1dba81cc Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Fri, 18 Dec 1998 16:20:28 +0000 Subject: Update information on alternate database locations. These fixes are from Jeff Hoffmann . --- doc/src/sgml/manage.sgml | 79 +++++++++++++++++++++++------------------------- 1 file changed, 38 insertions(+), 41 deletions(-) (limited to 'doc/src/sgml/manage.sgml') diff --git a/doc/src/sgml/manage.sgml b/doc/src/sgml/manage.sgml index 22c0a918394..c450f522ec9 100644 --- a/doc/src/sgml/manage.sgml +++ b/doc/src/sgml/manage.sgml @@ -11,12 +11,14 @@ This section is currently a thinly disguised copy of the Tutorial. Needs to be a -Although the site administrator is responsible for overall management of the -Postgres installation, some databases within the -installation may be managed by another person, designated the database administrator. -This assignment of responsibilities occurs when a database is created. A user may be assigned -explicit privileges to create databases and/or to create new users. A user assigned both privileges -can perform most administrative task within Postgres, but will +Although the site administrator is responsible for overall management +of the Postgres installation, some databases within the +installation may be managed by another person, +designated the database administrator. +This assignment of responsibilities occurs when a database is created. +A user may be assigned explicit privileges to create databases and/or to create new users. +A user assigned both privileges can perform most administrative task +within Postgres, but will not by default have the same operating system privileges as the site administrator. @@ -82,18 +84,27 @@ occurs through the database backend, so that any location specified must be accessible by the backend. - Either an absolute path name or an environment variable -may be specified as a location. -Any environment variable specifying an alternate location must have -been defined before the backend was started. + Alternate database locations are created and referenced by an environment variable +which gives the absolute path to the intended storage location. +This environment variable must have been defined before the backend was started +and the location it points to must be writable by the postgres administrator account. Consult with the site administrator -regarding preconfigured alternate database locations. +regarding preconfigured alternate database locations. +Any valid environment variable name may be used to reference an alternate location, +although using variable names with a prefix of PGDATA is recommended +to avoid confusion +and conflict with other variables. - The environment variable style of specification + In previous versions of Postgres, +it was also permissable to use an absolute path name to specify +an alternate storage location. +Although the environment variable style of specification is to be preferred since it allows the site administrator more flexibility in -managing disk storage. +managing disk storage, it is also possible to use an absolute path +to specify an alternate location. +The administrator's guide discusses how to enable this feature. @@ -103,45 +114,29 @@ any path or environment variable specified has some additional path fields appended. -Alternate database locations must be prepared by running initlocation. +Alternate database locations must be prepared by running +initlocation. -To create a data storage area in /alt/postgres/data, ensure -that /alt/postgres already exists. -From the command line, type - -% initlocation /alt/postgres/data -Creating Postgres database system directory /alt/postgres/data - -Creating Postgres database system directory /alt/postgres/data/base - - - - -To do the same using an environment variable PGDATA2, type +To create a data storage area using the environment variable +PGDATA2 (for this example set to /alt/postgres), +ensure that /alt/postgres already exists and is writable by +the Postgres administrator account. +Then, from the command line, type % initlocation $PGDATA2 Creating Postgres database system directory /alt/postgres/data - Creating Postgres database system directory /alt/postgres/data/base - -To create a database in the alternate storage area /alt/postgres/data -from the command line, -type - -% createdb -D /alt/postgres/data mydb - - -or - +To create a database in the alternate storage area PGDATA2 +from the command line, use the following command: % createdb -D PGDATA2 mydb -and to do the same from within psql type +To do the same from within psql type * CREATE DATABASE mydb WITH LOCATION = 'PGDATA2'; @@ -195,7 +190,8 @@ running the Postgres terminal monitor programs (e -You might want to start up psql, to try out the examples in this manual. +You might want to start up psql, +to try out the examples in this manual. It can be activated for the mydb database by typing the command: @@ -237,7 +233,8 @@ mydb=> \g This tells the server to process the query. If you terminate your query with a semicolon, the \g is not - necessary. psql will automatically process semicolon terminated queries. + necessary. +psql will automatically process semicolon terminated queries. To read queries from a file, say myFile, instead of entering them interactively, type: -- cgit v1.2.3