pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhi i need to connect database from my system to another system
5+ messages / 2 participants
[nested] [flat]
* hi i need to connect database from my system to another system
@ 2006-07-03 10:13 Penchalaiah P. <penchalaiahp@infics.com>
0 siblings, 1 reply; 5+ messages in thread
From: Penchalaiah P. @ 2006-07-03 10:13 UTC (permalink / raw)
To: pgsql-sql
Hi good afternoon to every one..
I am using postgresql database server... in my system.. if I want to
connect to this database server from other system..Or how can I use this
database server in other machine ..
How can I do this..if any one have idea about this please give me brief
description
Thanks & Regards
Penchal reddy | Software Engineer
Infinite Computer Solutions | Exciting Times...Infinite Possibilities...
SEI-CMMI level 5 | ISO 9001:2000
IT SERVICES | BPO
Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities |
Retail & Distribution | Government
Tel +91-80-5193-0000(Ext:503)| Fax +91-80-51930009 | Cell No
+91-9980012376|www.infics.com
Information transmitted by this e-mail is proprietary to Infinite
Computer Solutions and/ or its Customers and is intended for use only by
the individual or entity to which it is addressed, and may contain
information that is privileged, confidential or exempt from disclosure
under applicable law. If you are not the intended recipient or it
appears that this mail has been forwarded to you without proper
authority, you are notified that any use or dissemination of this
information in any manner is strictly prohibited. In such cases, please
notify us immediately at info.in@infics.com and delete this mail from
your records.
Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your records.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: hi i need to connect database from my system to another system
@ 2006-07-03 11:58 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Penchalaiah P. <penchalaiahp@infics.com>
0 siblings, 0 replies; 5+ messages in thread
From: Richard Broersma Jr @ 2006-07-03 11:58 UTC (permalink / raw)
To: Penchalaiah P. <penchalaiahp@infics.com>; pgsql-sql
> I am using postgresql database server... in my system.. if I want to
> connect to this database server from other system..Or how can I use this
> database server in other machine ..
>
> How can I do this..if any one have idea about this please give me brief
> description
You need to start the postgresql server with the "-i" option to allow TCP/IP connections. Then
you need to configure your pg_hba.conf file to set the permissions about which users can connect
to which databases.
Notice the pg_ctl section for starting postgresql.
http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html
Notice the -o "options" section that can be set. (in this case you want -i)
http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html
Finally notice, the section on the pg_hba.conf file.
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF
Also, secure shell also works well when connecting from another system.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: hi i need to connect database from my system to another system
@ 2006-07-03 12:26 Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Richard Broersma Jr @ 2006-07-03 12:26 UTC (permalink / raw)
To: Penchalaiah P. <penchalaiahp@infics.com>; +Cc: pgsql-sql
> If u don't mind can u please tell me clearly.. where I have start -I or
> how to start postgresql with -I
> > I am using postgresql database server... in my system.. if I want to
> > connect to this database server from other system..Or how can I use
> this
> > database server in other machine ..
> >
> > How can I do this..if any one have idea about this please give me
> brief
> > description
>
> You need to start the postgresql server with the "-i" option to allow
> TCP/IP connections. Then
> you need to configure your pg_hba.conf file to set the permissions about
> which users can connect
> to which databases.
>
> Notice the pg_ctl section for starting postgresql.
> http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html
>
> Notice the -o "options" section that can be set. (in this case you want
> -i)
> http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html
>
> Finally notice, the section on the pg_hba.conf file.
> http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm
> l#AUTH-PG-HBA-CONF
>
> Also, secure shell also works well when connecting from another system.
Don't forget to include the pgsql-sql list in your reply's. :-) The individuals on this list have
varying degree of experience and knowledge of postgresql. So if you only respond to me, you would
be limiting yourself to my meager experience and knowledge. ;-)
To start off with, it would be helpful to know which OS version of PostgreSQL you are using. The
windows versions is pre-configured to start with the "-i" option for allowing TCP/IP connections.
Secondly, how are you trying to connect to your postgresql server from another system? What
error messages are you getting.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: hi i need to connect database from my system to another
@ 2006-07-03 12:46 Penchalaiah P. <penchalaiahp@infics.com>
0 siblings, 1 reply; 5+ messages in thread
From: Penchalaiah P. @ 2006-07-03 12:46 UTC (permalink / raw)
To: pgsql-sql
Hi
I am using windows xp operating system...
I want to know how to connect remote postgresql from my system.. I need
brief description from beginning..
Now I am using pg_HBF conf file to connect remote postgresql in that I
am giving host name , ip-address,mask and trust... but it is showing
error like
Could not connect to server: connection refused(0x0000274d\10061)
Is the server running on host 127.0.0.1 and accepting TCP\IP connection
on port 5432 ?
Regards
penchal
-----Original Message-----
From: Richard Broersma Jr [mailto:rabroersma@yahoo.com]
Sent: Monday, July 03, 2006 5:57 PM
To: Penchalaiah P.
Cc: General Postgresql List
Subject: RE: [SQL] hi i need to connect database from my system to
another system
> If u don't mind can u please tell me clearly.. where I have start -I
or
> how to start postgresql with -I
> > I am using postgresql database server... in my system.. if I want to
> > connect to this database server from other system..Or how can I use
> this
> > database server in other machine ..
> >
> > How can I do this..if any one have idea about this please give me
> brief
> > description
>
> You need to start the postgresql server with the "-i" option to allow
> TCP/IP connections. Then
> you need to configure your pg_hba.conf file to set the permissions
about
> which users can connect
> to which databases.
>
> Notice the pg_ctl section for starting postgresql.
> http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html
>
> Notice the -o "options" section that can be set. (in this case you
want
> -i)
> http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html
>
> Finally notice, the section on the pg_hba.conf file.
>
http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm
> l#AUTH-PG-HBA-CONF
>
> Also, secure shell also works well when connecting from another
system.
Don't forget to include the pgsql-sql list in your reply's. :-) The
individuals on this list have
varying degree of experience and knowledge of postgresql. So if you
only respond to me, you would
be limiting yourself to my meager experience and knowledge. ;-)
To start off with, it would be helpful to know which OS version of
PostgreSQL you are using. The
windows versions is pre-configured to start with the "-i" option for
allowing TCP/IP connections.
Secondly, how are you trying to connect to your postgresql server from
another system? What
error messages are you getting.
Regards,
Richard Broersma Jr.
Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email from your records.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: hi i need to connect database from my system to another
@ 2006-07-03 13:09 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Penchalaiah P. <penchalaiahp@infics.com>
0 siblings, 0 replies; 5+ messages in thread
From: Richard Broersma Jr @ 2006-07-03 13:09 UTC (permalink / raw)
To: Penchalaiah P. <penchalaiahp@infics.com>; pgsql-sql
> I am using windows xp operating system...
> I want to know how to connect remote postgresql from my system.. I need
> brief description from beginning..
> Now I am using pg_HBF conf file to connect remote postgresql in that I
> am giving host name , ip-address,mask and trust... but it is showing
> error like
>
> Could not connect to server: connection refused(0x0000274d\10061)
> Is the server running on host 127.0.0.1 and accepting TCP\IP connection
> on port 5432 ?
Actually, your PostgreSQL server is running on the IP address that is assigned to that computer.
The 127.0.0.1 in the pg_hba.conf file is the initial accepted client IP address that your
postgresql server will accepted connections from. 127.0.0.1 is basically means localhost. So,
your pg_hba.conf file is initial configured to only allow client connections from itself.
So in this case, if you want to connect from an IP address from a different computer, you will
need to specify that ip address in your pg_hba.conf file as well as the permissions.
But just to get started, you could try editing a line in your pg_hba.conf to this:
#host all all 127.0.0.1/32 md5
host all all <your client ip address goes here>/24 trust
host all all 127.0.0.1/32 trust
To understand all of this, you will need to read the introduction in your pg_hba.conf file. Also,
keep in mind that the above change is basically an "open door" to everything in your DB server.
So after you've had a change to get familiar with everything, you will want to tighten up on
how,what, and how access is granted to you system.
"Last but not least", you will need to restart your postgresql service so these changes will take
effect.
This should get you connected.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-07-03 13:09 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-03 10:13 hi i need to connect database from my system to another system Penchalaiah P. <penchalaiahp@infics.com>
2006-07-03 11:58 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-07-03 12:26 Re: hi i need to connect database from my system to another system Richard Broersma Jr <rabroersma@yahoo.com>
2006-07-03 12:46 Re: hi i need to connect database from my system to another Penchalaiah P. <penchalaiahp@infics.com>
2006-07-03 13:09 ` Re: hi i need to connect database from my system to another Richard Broersma Jr <rabroersma@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox