Thread: fresh install of postgres 7.1 doesn't start postmaster with the "-i" flag
fresh install of postgres 7.1 doesn't start postmaster with the "-i" flag
From
danh@gelatinous.com
Date:
I used to run postgres 7.0 I just upgraded to postgres 7.1 my application wouldn't work until I added -o "-i" to the pg_ctl line in /etc/rc.d/init.d/postgresql ( i am running redhat 6.2 ) the -i flag is of course to enable tcp networking. I don't think i Had to do this with postgres 7.0, is this omission in postgres 7.1 intentional?
Re: fresh install of postgres 7.1 doesn't start postmaster with the "-i" flag
From
"Nick Fankhauser"
Date:
I'm not sure if its intentional, but it seems likely since this can now be set in postgresql.conf. Look here for more: http://www.postgresql.org/idocs/index.php?runtime-config.html (essentially, you just need to add a line that says: tcpip_socket = 1) -Nick > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of > danh@gelatinous.com > Sent: Tuesday, October 30, 2001 8:16 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] fresh install of postgres 7.1 doesn't start > postmaster with the "-i" flag > > > > I used to run postgres 7.0 > I just upgraded to postgres 7.1 > > my application wouldn't work until I added > > -o "-i" > > to the pg_ctl > line in /etc/rc.d/init.d/postgresql > > ( i am running redhat 6.2 ) > > the -i flag is of course to enable tcp networking. > > I don't think i Had to do this with postgres 7.0, > is this omission in postgres 7.1 intentional? > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Tuesday 30 October 2001 08:16 pm, danh@gelatinous.com wrote: > the -i flag is of course to enable tcp networking. > I don't think i Had to do this with postgres 7.0, > is this omission in postgres 7.1 intentional? The omission is intentional. As the other poster said, use the tcpip_socket option in postgresql.conf, located in /var/lib/pgsql/data on your redhat system. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11