[GRASSLIST:691] Re: Postgresql

[Glynn Clements]

Uttam Kumar wrote:

>     I am using GRASS5.0.0 on Linux.When I select a database through the 
> command g.select.pg, it gives a message "select Postgres:unknown host name: 
> host". I think I have changed the host name in this command while using it 
> before by mistake.I have heard that once the host name is changed then there 
> is only one way to configure the host name back to it for the further 
> working of Postgresql.This is done through some configuration in some 
> Postgresql file.
> 
> Can anybody guide me what is the name of the "file" where the postgresql 
> host name can be changed and How ?

You can change the host name with "g.select.pg host=...".

However, once you have set a hostname, you can change it but you can't
remove it; i.e. you can't go back to using a Unix-domain socket, so if
the local postmaster process isn't configured to accept TCP
connections, you can't communicate with it.

The only way to remove the hostname setting altogether is to delete
the PG_HOST line from the ~/.grassrc5 file.

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