Re: Connexion to Postgresql using TCP/IP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Secrétariat <ets(at)rolland-fr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Connexion to Postgresql using TCP/IP
Date: 2004-07-23 17:43:33
Message-ID: 26667.1090604613@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?Q?Secr=E9tariat?= <ets(at)rolland-fr(dot)com> writes:
> I edit /etc/rc.d/init.d/postgresql,
> and I replace the values for PGDATA with the path to my database.
> Now I can connect the PC when I use :
> service postgresql start

> It was due to an update from PG 7.3 to PG 7.4 who has modified the init
> script postgresql !

That's exactly why it's considered a bad idea to edit an init script
directly --- since it's a package-supplied file, it'll be overwritten
any time you update the package.

> Is it possible to avaid this problem by using the :
> /etc/sysconfig/pgsql

That's what it's for --- you put the variable definitions in there
instead, and they'll not be touched in a package update.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcus Wegner 2004-07-23 18:18:47 Question about linux filesystem and psql
Previous Message Bruno Wolff III 2004-07-23 15:49:49 Re: select, columns, and aliases