Thread: How to add a server on pgadmin
after i have click the add server and get the new server Registration dialogue but I just didnot know how to fill the dialogue, anyone can help me ? thank you! btw: I have install postgresql 8.2 for windows on my computer. -- View this message in context: http://www.nabble.com/How-to-add-a-server-on-pgadmin-tf3578281.html#a9998985 Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
shieldy a écrit : > after i have click the add server > and get the new server Registration dialogue > but I just didnot know how to fill the dialogue, > anyone can help me ? thank you! > btw: I have install postgresql 8.2 for windows on my computer. > Read this : http://www.pgadmin.org/docs/1.6/connect.html All is explained on this web page. Regards. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://docs.postgresqlfr.org/ -->
and how ,thank you , I got this sentence: If pgAdmin is running on a Windows machine, it can control the postmaster service if you have enough access rights. Enter the name of the service. In case of a remote server, it must be prepended by the machine name (e.g. PSE1\pgsql-8.0). pgAdmin will automatically discover services running on your local machine. 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?? thank you! can you gave my a example? Guillaume Lelarge-3 wrote: > > shieldy a écrit : >> after i have click the add server >> and get the new server Registration dialogue >> but I just didnot know how to fill the dialogue, >> anyone can help me ? thank you! >> btw: I have install postgresql 8.2 for windows on my computer. >> > > Read this : > http://www.pgadmin.org/docs/1.6/connect.html > > All is explained on this web page. > > Regards. > > > -- > Guillaume. > <!-- http://abs.traduc.org/ > http://lfs.traduc.org/ > http://docs.postgresqlfr.org/ --> > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > -- View this message in context: http://www.nabble.com/How-to-add-a-server-on-pgadmin-tf3578281.html#a10000610 Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
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@iol.ie ---------------------------------------------------------------
On 15/04/2007 17:12, Raymond O'Donnell wrote: > "Port" is the TCP/IP port on which the server is listening - this is > 5432 by default, unless you chaned it when installing PostgreSQL. Typo: for "chaned" read "changed".... :-) R. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
thankyou very much, I fixed it. Raymond O wrote: > > On 15/04/2007 17:12, Raymond O'Donnell wrote: >> "Port" is the TCP/IP port on which the server is listening - this is >> 5432 by default, unless you chaned it when installing PostgreSQL. > > Typo: for "chaned" read "changed".... :-) > > R. > > --------------------------------------------------------------- > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > rod@iol.ie > --------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > -- View this message in context: http://www.nabble.com/How-to-add-a-server-on-pgadmin-tf3578281.html#a10009903 Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.