<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Richard Heimann [C] wrote:
<blockquote cite="mid:00aa01c840ff$271e1460$3b81fa84@aitgis" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered)">
<title>RE: [postgis-users] HELP adding spatial field to table</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0pt;
margin-left:0pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
pre
{margin:0pt;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;"> Question:
</span></font></p>
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Book Antiqua" size="3"><span
style="font-size: 12pt; font-family: "Book Antiqua"; color: navy;">I
have two
development boxes both running PostgreSQL/PostGIS. On set-up several
months ago
and the other today, the former has already had data loaded. I could
fairly
easily move the Shapefile from one box to the other and then load but I
know in
SQL Server I could connect to the other box and either use the data or
move it
to the new database. Therefore, my question is does PostgreSQL offer
similar
functionality? In other words, can you connect to other PostgreSQL
machines? I
feel like Ive seen this via the command-line (pgsql) but not phAdmin.
In either
case Im looking for help and confirmation. This more then just
academically
interesting and could save a great deal of time. Thanks in advance.</span></font></p>
</div>
</blockquote>
Yes, you can. However, in order to do this there are a few
pre-requisites you'll need to set up:<br>
<br>
1. You need to change your postgresql.conf file so that PostgreSQL is
listening for connections on the network (along with adding any
firewall rules required so that this can occur).<br>
2. You'll need to modify the pg_hba.conf file so that connections and
authentication are allowed over the network.<br>
3. You'll need to make sure that a user (with a password) is defined.
The postgres user (by default) has no password, so it can only connect
via the "trust" authentication mechanism...which is very insecure in
general, and worse over the network.<br>
<br>
Once these steps are complete, you can use the psql command to connect
over the network.<br>
<br>
It sounds like a lot of the issues you are having are admin
related...you might benefit from our PostgreSQL admin course
(<a class="moz-txt-link-freetext" href="http://www.otg-nc.com/training-courses/coursedetail.php?courseid=40&cat_id=8">http://www.otg-nc.com/training-courses/coursedetail.php?courseid=40&cat_id=8</a>)
... it covers a lot of the topics you've been asking about.<br>
<br>
On a side note, it's best to send a "fresh" email to the list for a new
topic (as opposed to using 'reply' to post a question). when you use
reply, many mailreaders will recognize that you are "replying" to an
existing thread and will not show your post as a "new" question
(rather, it will look like part of an old question..that many people
might ignore).<br>
<br>
Have a good holiday!<br>
<br>
thanks<br>
<br>
<pre class="moz-signature" cols="72">--
Chander Ganesan
The Open Technology Group
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
<a class="moz-txt-link-freetext" href="http://www.otg-nc.com">http://www.otg-nc.com</a>
</pre>
</body>
</html>