Discussion:
How to add a server on pgadmin
(too old to reply)
shieldy
2007-04-15 01:52:19 UTC
Permalink
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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Guillaume Lelarge
2007-04-15 08:39:05 UTC
Permalink
Post by shieldy
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 ***@postgresql.org so that your
message can get through to the mailing list cleanly
shieldy
2007-04-15 09:00:05 UTC
Permalink
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?
Post by Guillaume Lelarge
Post by shieldy
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.
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
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.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Raymond O'Donnell
2007-04-15 16:12:30 UTC
Permalink
Post by shieldy
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
***@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org
Raymond O'Donnell
2007-04-15 16:18:21 UTC
Permalink
Post by Raymond O'Donnell
"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
***@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org
shieldy
2007-04-16 04:13:08 UTC
Permalink
thankyou very much, I fixed it.
Post by Raymond O'Donnell
Post by Raymond O'Donnell
"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
---------------------------------------------------------------
---------------------------(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.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq
Loading...