Thread

1. postgresql 7.1.3

   David Fee <dfee@laurcat.com> — 2002-05-06T16:37:26Z

   Owen,
   Do you know how to get postmaster to start with the " -i " flag?  I want to 
   use pgaccess and when I try to connect to the db, it gives an error message 
   saving that the postmaster isn't running with the " -i " flag or accepting 
   connections at port 5432.  If I start postmaster with " -i  " manually, it 
   works fine, but I need it to start automatically
   Thanks,
   Dave
   
   
   

2. Re: postgresql 7.1.3

   Lamar Owen <lamar.owen@wgcr.org> — 2002-05-07T01:45:02Z

   On Monday 06 May 2002 12:37 pm, David Fee wrote:
   > Owen,
   > Do you know how to get postmaster to start with the " -i " flag?  I want to
   > use pgaccess and when I try to connect to the db, it gives an error message
   > saving that the postmaster isn't running with the " -i " flag or accepting
   > connections at port 5432.  If I start postmaster with " -i  " manually, it
   > works fine, but I need it to start automatically
   
   Find the file 'postgresql.conf' -- on RedHat with an RPM installation it is in 
   /var/lib/pgsql/data.  Edit this file -- change the line '#tcpip_socket = 
   false' to be 'tcpip_socket = true'  -- note the lack of the # comment.
   
   Restart postmaster and you're done.  The -i switch is no longer necessary due 
   to the 'GUC' -- 'Grand Unified Configuration' file postgresql.conf.
   -- 
   Lamar Owen
   WGCR Internet Radio
   1 Peter 4:11
   
   

3. Re: postgresql 7.1.3

   Oliver Elphick <olly@lfix.co.uk> — 2002-05-07T13:17:35Z

   On Mon, 2002-05-06 at 17:37, David Fee wrote:
   > Owen,
   > Do you know how to get postmaster to start with the " -i " flag?  I want to 
   > use pgaccess and when I try to connect to the db, it gives an error message 
   > saving that the postmaster isn't running with the " -i " flag or accepting 
   > connections at port 5432.  If I start postmaster with " -i  " manually, it 
   > works fine, but I need it to start automatically
   
   If you are running pgaccess on the same machine, you don't need to start
   the postmaster with -i.  Just make sure that the hostname field in
   pgaccess' connection dialog is empty.  pgaccess will then connect
   through a Unix socket.
   
   -- 
   Oliver Elphick                                Oliver.Elphick@lfix.co.uk
   Isle of Wight                              http://www.lfix.co.uk/oliver
   GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
   
        "Dearly beloved, avenge not yourselves, but rather give
         place unto wrath. For it is written, Vengeance is 
         mine; I will repay, saith the Lord. Therefore if thine
         enemy hunger, feed him; if he thirst, give him drink;
         for in so doing thou shalt heap coals of fire on his 
         head. Be not overcome of evil, but overcome evil with 
         good."      Romans 12:19-21 
   

4. Re: postgresql 7.1.3

   Doug McNaught <doug@wireboard.com> — 2002-05-07T14:02:01Z

   David Fee <dfee@laurcat.com> writes:
   
   > Do you know how to get postmaster to start with the " -i " flag?  I want to 
   > use pgaccess and when I try to connect to the db, it gives an error message 
   > saving that the postmaster isn't running with the " -i " flag or accepting 
   > connections at port 5432.  If I start postmaster with " -i  " manually, it 
   > works fine, but I need it to start automatically
   
   Edit 'postgresql.conf' and set 'tcpip_socket' to 'true', then restart.
   
   -Doug