which filesystem will database be saved to?

[Shea Martin]

I am building postgres, and have ltd. space left on my / partition. As data
base grows which dir is going to be the one that gets larger? It is not very
apparent from the docs:

../configure --help gives:
...
--bindir=DIR user executables [EPREFIX/bin]
--sbindir=DIR system admin executables [EPREFIX/sbin]
--libexecdir=DIR program executables [EPREFIX/libexec]
--datadir=DIR read-only architecture-independent data [PREFIX/share]
--sysconfdir=DIR read-only single-machine data [PREFIX/etc]
--sharedstatedir=DIR modifiable architecture-independent data [PREFIX/com]
--localstatedir=DIR modifiable single-machine data [PREFIX/var]
--libdir=DIR object code libraries [EPREFIX/lib]
--includedir=DIR C header files [PREFIX/include]
--oldincludedir=DIR C header files for non-gcc [/usr/include]
--infodir=DIR info documentation [PREFIX/info]
--mandir=DIR man documentation [PREFIX/man]
...

I would prefer to keep the installation in standard location, and have the
volatile and growing part in my /var partition. I was considering
--datadir=/var/psql/data
--sharedstatedir=/var/psql/shared
--localstatedir=/var/psql/local

Thoughts, comments?

~S

[Shea Martin]

Shea Martin wrote:

I am building postgres, and have ltd. space left on my / partition. As
data base grows which dir is going to be the one that gets larger? It
is not very apparent from the docs:

./configure --help gives:
...
--bindir=DIR user executables [EPREFIX/bin]
--sbindir=DIR system admin executables [EPREFIX/sbin]
--libexecdir=DIR program executables [EPREFIX/libexec]
--datadir=DIR read-only architecture-independent data
[PREFIX/share]
--sysconfdir=DIR read-only single-machine data [PREFIX/etc]
--sharedstatedir=DIR modifiable architecture-independent data
[PREFIX/com]
--localstatedir=DIR modifiable single-machine data [PREFIX/var]
--libdir=DIR object code libraries [EPREFIX/lib]
--includedir=DIR C header files [PREFIX/include]
--oldincludedir=DIR C header files for non-gcc [/usr/include]
--infodir=DIR info documentation [PREFIX/info]
--mandir=DIR man documentation [PREFIX/man]
...

I would prefer to keep the installation in standard location, and have
the volatile and growing part in my /var partition. I was considering
--datadir=/var/psql/data
--sharedstatedir=/var/psql/shared
--localstatedir=/var/psql/local

Thoughts, comments?

~S

ps - is --datadir=DIR at buildtime, same as $PGDATA an runtime?