Thread: postgresql 7.1.3

postgresql 7.1.3

From
David Fee
Date:
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


Re: postgresql 7.1.3

From
Oliver Elphick
Date:
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

Attachment

Re: postgresql 7.1.3

From
Doug McNaught
Date:
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