Re: How to add a server on pgadmin

On 15/04/2007 10:00, shieldy wrote:
> but i just didnot know the server name and the Name , Host, and even the
> password, I install the postgresql on my own computer, so I have the
> enought access rights, but what should I fill the blank??

"Name" is just a descriptive name you can give the server instance in
pgAdmin to distinguish it in the list - it has no meaning outside pgAdmin.

"Host" is the name or IP address of the machine the server is running on
- if it's the same computer as the one on which you're running pgAdmin,
then "localhost" or "127.0.0.1" will do.

"Port" is the TCP/IP port on which the server is listening - this is
5432 by default, unless you chaned it when installing PostgreSQL.

"Username" and "Password" are the username and password of a database
user as which you can connect to the server. PgAdmin defaults to
"postgres", which by convention is the PostgreSQL super-user. I missed
what OS you said you were on, but if on Windows and you used the Windows
Installer package, then you would have been prompted for a password for
this user - use the same password here.

If PostgreSQL is running on Windows, then it runs as a service, and
"service" is the name of that service. Look in "Administrative Tools" ->
"Services" to find out what yours is called.

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------