[GRASSLIST:686] Postgresql

GRASS GRASS user
1

Hi,
    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 ?

Thanks.

uttam.

_________________________________________________________________
HCL Beanstalk PCs. You could win one. http://server1.msn.co.in/sp03/hclbeanstalktour/index.asp Interested?

2

Try the command

g.select.pg localhost database=databasename

(insteed of localhost use the host name of the database-server on which Postgresql is installed)

Good look
Thomas

Uttam Kumar schrieb:

Hi,
   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 ?

Thanks.

uttam.

_________________________________________________________________
HCL Beanstalk PCs. You could win one. http://server1.msn.co.in/sp03/hclbeanstalktour/index.asp Interested?

3

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@virgin.net>