Thread

1. RES: set DateStyle to 'SQL'

   Elielson Fontanezi <elielsonf@prodam.sp.gov.br> — 2002-07-26T16:56:16Z

   Friends, that is what the documents says:
   ---------------------------------------------------------------
   1.6.2. Environment Variables
   If you installed into /usr/local/pgsql or some other location that is not
   searched for programs by default, you need to add /usr/local/pgsql/bin (or
   whatever you set --bindir to in step 1) into your PATH. To do this, add the
   following to your shell start-up file, such as ~/.bash_profile (or
   /etc/profile, if you want it to affect every user): 
   
   PATH=/usr/local/pgsql/bin:$PATH
   If you are using csh or tcsh, then use this command: 
   
   set path = ( /usr/local/pgsql/bin $path )
   
   To enable your system to find the man documentation, you need to add a line
   like the following to a shell start-up file: 
   
   MANPATH=/usr/local/pgsql/man:$MANPATH
   
   The environment variables PGHOST and PGPORT specify to client applications
   the host and port of the database server, overriding the compiled-in
   defaults. If you are going to run client applications remotely then it is
   convenient if every user that plans to use the database sets PGHOST. This is
   not required, however: the settings can be communicated via command line
   options to most client programs. 
   ---------------------------------------------------------------
   
   	But... likely there are much more variables rather than PGDATA,
   PGHOST and PGPORT.
   	Where can I find them?
   
   E.F.:> -----Mensagem original-----
   E.F.:> De: Elielson Fontanezi 
   E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 11:42
   E.F.:> Para: Elielson Fontanezi
   E.F.:> Cc: pgsql-sql; pgsql-admin
   E.F.:> Assunto: RES: [GENERAL] set DateStyle to 'SQL'
   E.F.:> 
   E.F.:> 
   E.F.:> Hi friends!
   E.F.:> 
   E.F.:> 	Maybe I have not been clear.
   E.F.:> 	See, there are varibles like PGPORT, PG_HBA_SAMPLE, 
   E.F.:> POSTGRES_BKI,
   E.F.:> POSTGRESQL_CONF_SAMPLE and much more.
   E.F.:> 	Where ca I find related information to them? and list 
   E.F.:> of all them?
   E.F.:> 
   E.F.:> 	my regards,
   E.F.:> 
   E.F.:> E.F.:> -----Mensagem original-----
   E.F.:> E.F.:> De: Elielson Fontanezi [mailto:ElielsonF@prodam.sp.gov.br]
   E.F.:> E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 10:28
   E.F.:> E.F.:> Para: pgsql-general
   E.F.:> E.F.:> Cc: pgsql-sql
   E.F.:> E.F.:> Assunto: [GENERAL] set DateStyle to 'SQL'
   E.F.:> E.F.:> 
   E.F.:> E.F.:> 
   E.F.:> E.F.:> Hi folks!
   E.F.:> E.F.:> 
   E.F.:> E.F.:> 	There are a buch of varibles like DateStyle. I am 
   E.F.:> E.F.:> interested to set
   E.F.:> E.F.:> them
   E.F.:> E.F.:> all in script shell.
   E.F.:> E.F.:> 	I've tried in postgresql.conf, but I could not.
   E.F.:> E.F.:> 	I've tried in shell environment, but it did not work.
   E.F.:> E.F.:> 
   E.F.:> E.F.:> 	So, how can I do that?
   E.F.:> E.F.:>  
   E.F.:> 
   
   

2. Re: RES: [GENERAL] set DateStyle to 'SQL'

   Roberto Mello <rmello@cc.usu.edu> — 2002-07-26T21:53:48Z

   On Fri, Jul 26, 2002 at 01:56:16PM -0300, Elielson Fontanezi wrote:
   
   > The environment variables PGHOST and PGPORT specify to client applications
   > the host and port of the database server, overriding the compiled-in
   > defaults. If you are going to run client applications remotely then it is
   > convenient if every user that plans to use the database sets PGHOST. This is
   > not required, however: the settings can be communicated via command line
   > options to most client programs. 
   > ---------------------------------------------------------------
   > 
   > 	But... likely there are much more variables rather than PGDATA,
   > PGHOST and PGPORT.
   > 	Where can I find them?
   
   Perhaps you're looking for
   http://www.postgresql.org/idocs/index.php?runtime-config.html
   
   Please trim your replies to the list.
   
   -Roberto
   
   -- 
   +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
     Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
          http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
   A .45 beats a royal flush EVERY TIME