lio bod wrote:
> hello world,
>  =

> i'm playin with mkslonconf.sh and i'm referring to =

> http://slony.info/documentation/adminscripts.html
> it's said set several variables and i'm lookin for what value i should =

> use for PGSERVICE
> i tried some but the scripts says :
>  =

> psql: ERROR: Service file '/etc/sysconfig/pgsql/pg_service.conf'
>  =

> of course i don't have this file on my system (RHEL4 / postgres 7.4.19).
> should i?
>  =

> i just understand it's something relative to run postgres as a service.
>  =

> any clue?
>  =

> thx
You can find more documentation here:
http://www.postgresql.org/docs/8.2/static/libpq-pgservice.html

I don't think its behaviour has changed much between 7.4 and 8.2...

The idea is that you can identify a whole set of conninfo parameters via =

referencing a named entry in pg_service.conf.

Thus, supposing pg_service.conf contains the following:

[loganalysis]
dbname=3Dlog_analysis
port=3D5777
host=3Dlocalhost
user=3Dlog_analysis

## Log analysis database
[s1-log-analysis]
dbname=3Dlog_analysis
port=3D5777
host=3Dlocalhost
user=3Dlog_analysis

[s2-log-analysis]
dbname=3Dlog_analysis
port=3D6436
host=3Drg550-da-njmisc
user=3Dlog_analysis

[s3-log-analysis]
dbname=3Dlog_analysis
port=3D5757
host=3Dyrg-misc
user=3Dlog_analysis

You can use "PGSERVICE=3Ds3-log-analysis" in lieu of the (obviously rather =

longer)...  "PGDATABASE=3Dlog_analysis PGPORT=3D5757 PGHOST=3Dyrg-misc =

PGUSER=3Dlog_analysis"

If you're not using PGSERVICE, already, nothing necessitates that you =

start using it.  But if you are using it to organize connection info, =

mkslonconf.sh does support it...

-- =

output =3D reverse("ofni.sailifa.ac" "@" "enworbbc")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: cbbrowne.vcf
Type: text/x-vcard
Size: 286 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080304=
/3ac348d8/cbbrowne.vcf