can osm2pgsql support PGSERVICEFILE ?

[hadjiprocopis]

psql has this feature whereas you can specify a "service file" which contains username/dbname/password combinations (and other things like host, port, etc.) for connecting to a Pg db.
The location of the service file can be specified as an environment variable and can be made to be used just for the current session by doing something like this:

PGSERVICEFILE='myservicefile.pg' psql 'service=postgres' ...

and the service file contains something like:

[postgres]
host=
port=
dbname=mydbname
user=mydbuser
password=xyz

The benefit of this is that you do not specify a password on the command line and that the service file can be made to be temporary and specific to just one command, so no system-wide files with passwords, which I prefer personally.

I was wondering if that feature is supported by osm2pgsql. I mean I searched but could not find anything. I know one can specify --password apassword or -W to get a password prompt.

thanks a lot for this open source and free software.

[lonvia]

Yes, you can use all the PG* variables including PGSERVICEFILE and osm2pgsql will pick them up. It uses libpq under the hood.

[hadjiprocopis]

Hmm, sorry because I must be doing something wrong then with this (with or without -d gis):

PGSERVICEFILE=credentials-gis.pg osm2pgsql --create --slim -G --hstore --multi-geometry --tag-transform-script openstreetmap-carto.lua -C 2500 --number-processes 2 -S openstreetmap-carto.style monaco-latest.osm.pbf

it says:

ERROR: Connecting to database failed (context=check): connection to server on socket "/var/run/postgresql/.s.PGSQL..." failed: fe_sendauth: no password supplied

Whereas this works for psql:

PGSERVICEFILE=credentials-gis.pg psql 'service=gis'

Perhaps there is a way to insert that service=gis somewhere?

[lonvia]

Just use the PGSERVICE variable:

PGSERVICE=gis PGSERVICEFILE=credentials-gis.pg osm2pgsql ...

Or use a URI for the database parameter.

Please see the osm2pgsql documentation on details for the URI and the PostgreSQL documentation on details of environment variables.