Skip site navigation (1) Skip section navigation (2)

Re: local usage was: Re: using pgsql on my comp only without

From: Mohan <mohanyes(at)shafika(dot)vetri(dot)com>
To: ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca
Cc: pgsql-novice(at)postgresql(dot)org,stm23 <STM23(at)student(dot)canterbury(dot)ac(dot)nz>
Subject: Re: local usage was: Re: using pgsql on my comp only without
Date: 2004-03-10 13:08:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Thanks for the wonderful explanation.
I installed postgresql in windows 2000, and when i configured to local host, i
got socket error.
I installed apache and configured it then it works fine.
Is that any webserver required to come out of Socket error?

ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca wrote:

> On Tue, 9 Mar 2004, Bruno Wolff III wrote:
> > On Wed, Mar 10, 2004 at 12:47:16 +1300,
> >   stm23 <STM23(at)student(dot)canterbury(dot)ac(dot)nz> wrote:
> >> hi, i am unable to setup my modem on my redhat 8.0 OS, so i
> >> don't think i can get TCP access.  is it possible to use pgsql
> >> entirely on my local computer (i.e creating my own databases &
> >> manipulating them on my comp)?
> >
> > You don't need a modem for tcp access on the same machine that is running
> > postgres. There is a loopback interface that is part of the OS that takes
> > care of that. You also have (the better) option of using domain sockets
> > for connecting to the database from the same host.
> Just getting a little more wordy here.
> I suppose it is possible to set up Linux such that the "localhost"
> doesn't exist, but in general if you have networking installed
> this thing called localhost will exist.  It is also known as the
> loopback interface, and is called 'lo' in some instances
> (ifconfig).
> A long time ago, people realised that in networking it was always
> handy to be able to get to "here".  If for no other reason, than
> to test network capable software.  Most programs happen to know
> what $CWD is (Current Working Directory), well localhost is a
> similar idea applied to a network.  In terms of an IP address,
> localhost is
> An example is to telnet to  This just lets you login to
> your own computer, but instead of the computer thinking you are
> logged in at the console, you are logged in over a network
> connection.
> So, to use postgres over a local networking connection, we will
> have some program establish a connection to on the port
> that the PostgreSQL postmaster is listening to (on my machine,
> that's 5432).  If I later decided to move my database to a
> different machine, or move the program to a different machine, all
> I need to do is to change the address (and possibly port number),
> I don't need to change how the program operates.
> We'll leave sockets and what domain they are in to a different
> message.  :-)
> Hopefully this is a little "better" description, in the case you
> didn't understand the more concise explanation offered earlier.
> Gord
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-03-10 14:58:22
Subject: Re: find close (duplicate) points + create index
Previous:From: ghaverlaDate: 2004-03-10 12:27:43
Subject: Re: find close (duplicate) points + create index

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group