agora inbox for postgres@postgres.berkeley.eduhelp / color / mirror / Atom feed
Is that possible to set PGDATA at run time? 2+ messages / 2 participants [nested] [flat]
* Is that possible to set PGDATA at run time? @ 1994-07-11 04:53 Toncan Duong <toncan@cse.unsw.edu.au> 0 siblings, 1 reply; 2+ messages in thread From: Toncan Duong @ 1994-07-11 04:53 UTC (permalink / raw) To: legacy Hi, Is that possible to set the PGDATA at run-time? What we want to achieve is to run the postgres backend/frontend at a machine different from the machine where the data directory is stored. It appears that excutables such as monitor, createdb, createuser, etc. read/write to the directory that has been set at compilation. (Went through the manual of 4.2. Haven't found any info. on the setting of environment variables like PGDATA.) thanks in advance toncan@cse.unsw.edu.au ============================================================================== 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] 2+ messages in thread
* Re: Is that possible to set PGDATA at run time? @ 1994-07-11 08:03 Paul M. Aoki <aoki@CS.Berkeley.EDU> parent: Toncan Duong <toncan@cse.unsw.edu.au> 0 siblings, 0 replies; 2+ messages in thread From: Paul M. Aoki @ 1994-07-11 08:03 UTC (permalink / raw) To: Toncan Duong <toncan@cse.unsw.edu.au>; +Cc: legacy toncan@cse.unsw.edu.au (Toncan Duong) writes: > Is that possible to set the PGDATA at run-time? it depends on what you mean by "run-time." it only matters when running the initialization utilities (initdb, newbki, cleardbdir), which are only run while installing the system, and the postmaster. none of the other programs look at it. > What we want to achieve is to run the postgres backend/frontend at a > machine different from the machine where the data directory is stored. backends always run on the same machine as the postmaster, because they are child processes of the postmaster. the postmaster must be started on the machine where the data files are located. the frontend can be on any machine. (the process architecture is explained in the user manual..) > It appears that excutables such as monitor, createdb, createuser, etc. > read/write to the directory that has been set at compilation. no. the backend servers started by those commands use the directory set at compilation, unless the postmaster was started with PGDATA set to a different directory (or with the -D option). > (Went through the manual of 4.2. Haven't found any info. on the setting > of environment variables like PGDATA.) there isn't much to explain about PGDATA since, after the data directory has been initialized, it is only used by the postmaster. look at the "postmaster" man page. there's also a brief mention in the user manual. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@CS.Berkeley.EDU | Berkeley, CA 94720-1776 | ...!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] 2+ messages in thread
end of thread, other threads:[~1994-07-11 08:03 UTC | newest] Thread overview: 2+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1994-07-11 04:53 Is that possible to set PGDATA at run time? Toncan Duong <toncan@cse.unsw.edu.au> 1994-07-11 08:03 ` Paul M. Aoki <aoki@CS.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox