PostgreSQL environment file on Mac OSX? -


postgresql seems have environment file allows settings environment variables. on linux (kubuntu 11.10 in case), located @ e.g. /etc/postgresql/8.4/main/environment , empty default, apart few helpful comments.

on mac osx lion, file not seem exist: expect @ e.g. /library/postgresql/9.0/data/ that's other configuration files are, not there - , if create it, not seem used.

how can set environment variables postgresql server on mac osx ?

there no standard way specify environment variables postgresql, assume file kubuntu specific.

what did ease life copying approach used oracle:

  • i have /etc/pgtab file on each server run postgresql databases;
  • i specify each cluster run on single line in /etc/pgtab;
  • i've created script pgenv based on /etc/pgtab shows menu of clusters (in case there're more one) , initialize paths , variables.

it works on macbookpro , on linux , hp-ux based servers.


Comments

Popular posts from this blog

delphi - How to convert bitmaps to video? -

jasper reports - Fixed header in Excel using JasperReports -

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -