Re: Version 1.4.4 installation problems ( IT WORKS ! )

[Oscar B. <os...@el...>]

Thanks to all the people replying to my 'crying out for help!'

For the person that may benifit from it:

To start Postgresql with the -i flag (to enable TCP/IP connections) on
Mandrake 8=2E0 do the following:

cd /etc/init=2Ed
emacs postgresql

Look for the line containing: echo -n "Starting postgresql service: "
(probably line 82)
The next line is then:
su -l postgres -c "/usr/bin/pg_ctl  -D $PGDATA -p /usr/bin/postmaster  start
>/dev/null 2>&1"

Change it to:

su -l postgres -c "/usr/bin/pg_ctl  -D $PGDATA -p /usr/bin/postmaster -o -i
start >/dev/null 2>&1"

Notice the "-o -i" between postmaster and start=2E

I assume the -o means 'options you want to give to the postmaster when
starting it'=2E
-i enables the TCP/IP connections=2E

Enjoy,

Oscar


----- Message d'origine -----
De : "Tomas Kuliavas" <tokul@bigfoot=2Ecom>
? : <sql-ledger-users@lists=2Esourceforge=2Enet>
Envoy=E9 : mardi 19 juin 2001 20:22
Objet : Re: Version 1=2E4=2E4 installation problems (nearly there now ! )


> > Oscar Buijten wrote:
> >
> > Hello again dear helpers,
> >
> > I have been trying several things=2E Changed this line;
> > postgres -c "/usr/bin/pg_ctl  -D  $PGDATA -p  /usr/bin/postmaster
> > start >/dev/null 2>&1
> > in several ways=2E Can't get it to work with this=2E
> >
> > Have tried to add : su postgres -c  'postmaster -i'   to /etc/profile
> > as well but no succes either=2E
> >
> > When I use; su postgres -c  'postmaster -i'    from the command line
> > postmaster switches on and I can use the SQL-ledger application=2E
> >
>
> You don't need to modify init=2Ed script if you want to make postgresql
> listen to tcp
>
> all you need is valid configuration file=2E
>
> "tcpip_socket =3D true" and "port =3D 5432" options=2E
>
> and postgres listens to tcp port=2E I did it with postgres build from
> sources and with postgres on Debian=2E :)
> --
> Tomas Kuliavas
>