[GRASS5] Re: [GRASSLIST:987] Re: g.select.pg problem: list OK but refuse to select available database

From 'grasslist'

On Thu, Aug 21, 2003 at 12:18:33PM +0100, Glynn Clements wrote:
[...]

Note that the g.select.pg program in 5.0.2 (and earlier) doesn't allow
you to "undefine" a host. Once you use "g.select.pg host=...", all
subsequent connections will be via TCP/IP. You can select a different
host, but you can't revert to Unix domain sockets.

To revert to using a Unix domain socket to connect to a local
postmaster process, you have to manually delete the PG_HOST entry from
the $GISRC file (typically ~/.grassrc5).

This is fixed in the CVS HEAD version, and should be fixed in 5.0.3.

Is this already fixed in 5.0.3? Where to look for that?

Markus

Markus Neteler wrote:

> Note that the g.select.pg program in 5.0.2 (and earlier) doesn't allow
> you to "undefine" a host. Once you use "g.select.pg host=...", all
> subsequent connections will be via TCP/IP. You can select a different
> host, but you can't revert to Unix domain sockets.
>
> To revert to using a Unix domain socket to connect to a local
> postmaster process, you have to manually delete the PG_HOST entry from
> the $GISRC file (typically ~/.grassrc5).
>
> This is fixed in the CVS HEAD version, and should be fixed in 5.0.3.

Is this already fixed in 5.0.3?

Not yet.

Where to look for that?

cvs diff -r 1.11 -r 1.12 src.garden/grass.postgresql/g.select.pg/main.c

--- src.garden/grass.postgresql/g.select.pg/main.c 24 Nov 2002 12:39:58 -0000 1.11
+++ src.garden/grass.postgresql/g.select.pg/main.c 28 May 2003 05:30:26 -0000 1.12
@@ -61,6 +61,8 @@

     if (pghost->answer)
   G_setenv("PG_HOST", pghost->answer);
+ else
+ G_unsetenv("PG_HOST");

     if (list->answer) {
   fprintf(stderr, _("The following databases are in the Unix catalogue:\n"));

--
Glynn Clements <glynn.clements@virgin.net>

On Fri, Aug 22, 2003 at 09:41:20AM +0100, Glynn Clements wrote:

Markus Neteler wrote:

> > Note that the g.select.pg program in 5.0.2 (and earlier) doesn't allow
> > you to "undefine" a host. Once you use "g.select.pg host=...", all
> > subsequent connections will be via TCP/IP. You can select a different
> > host, but you can't revert to Unix domain sockets.
> >
> > To revert to using a Unix domain socket to connect to a local
> > postmaster process, you have to manually delete the PG_HOST entry from
> > the $GISRC file (typically ~/.grassrc5).
> >
> > This is fixed in the CVS HEAD version, and should be fixed in 5.0.3.
>
> Is this already fixed in 5.0.3?

Not yet.

> Where to look for that?

cvs diff -r 1.11 -r 1.12 src.garden/grass.postgresql/g.select.pg/main.c

--- src.garden/grass.postgresql/g.select.pg/main.c 24 Nov 2002 12:39:58 -0000 1.11
+++ src.garden/grass.postgresql/g.select.pg/main.c 28 May 2003 05:30:26 -0000 1.12
@@ -61,6 +61,8 @@

     if (pghost->answer)
   G_setenv("PG_HOST", pghost->answer);
+ else
+ G_unsetenv("PG_HOST");

     if (list->answer) {
   fprintf(stderr, _("The following databases are in the Unix catalogue:\n"));

Thanks,

sync'ed into 5.0.3.

Markus