Thread: Default data directory
Hello, We're building a test box for our webmaster to play in. It needs to have the same config as his production box. The postgres default data directory doesn't match the location of the data directory location on the production box. The postgresql.conf file has the line that says that it changes the default data location commented out. Is there somewhere else that postgres can get this information? I can't figure out how the Postgres that's running on the production web server knows where to look for its data. Thanks, Carol
Carol Walter <walterc@indiana.edu> writes: > I can't figure out how the Postgres that's running on the production > web server knows where to look for its data. Generally the location of the data directory is determined by a -D switch on the postmaster command line, or by setting the PGDATA environment variable in the script that launches the postmaster. Setting it in the configuration file would be circular logic, except in the uncommon sort of configuration where the config file doesn't live in the data directory (in which case the -D switch only indicates where the config files are). regards, tom lane
On Fri, Sep 5, 2008 at 12:44 PM, Carol Walter <walterc@indiana.edu> wrote: > Hello, > > We're building a test box for our webmaster to play in. It needs to have > the same config as his production box. The postgres default data directory > doesn't match the location of the data directory location on the production > box. The postgresql.conf file has the line that says that it changes the > default data location commented out. Is there somewhere else that postgres > can get this information? > > I can't figure out how the Postgres that's running on the production web > server knows where to look for its data. We don't quite have enough information to really troubleshoot this. What OS, and how was pg installed in each if they're different. If the webmaster needs a sandbox like production, then I would assume the two OSes are the same, right?
> Is there somewhere else that postgres can get this information? > I can't figure out how the Postgres that's running on the production web > server knows where to look for its data. Could it be the compile time setting? I guess you can try # pg_config --configure and the --prefix=... will likely be where the "data" sits? Regards, Ben Kim