Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group