Search Postgresql Archives

Re: FDW to postGIS Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you, Brent! You told me what I needed to know.

---
--------------------------------------
Susan E Hurst
Email:  susan.hurst@xxxxxxxxxxxxxxxxxx
Mobile: 314-486-3261

On 2022-03-06 19:35, Brent Wood wrote:
In line below...

 On Monday, March 7, 2022, 05:36:34 AM GMT+13, Susan Hurst
<susan.hurst@xxxxxxxxxxxxxxxxxx> wrote:

Let say that I have a database named stp. I also have another database


named geo that is a PostGIS database for storing geopolitical and

geospatial data. I want to set up a foreign data wrapper in stp to

connect to geo, so that for each address in stp, I only have to store

the primary key value of the lowest level geo unit, such as a city. I

can always display the city's county, state, country, whatever in
views

in stp. I plan to have other databases that need geo data so I want a

single source of truth for geopolitical and geospatial data.

My questions are:

1. Do I have to install PostGIS in stp?....or is it sufficient to

install PostGIS only in geo?

If you want to use Postgis functions & datatypes in stp you will need
Postgis there

2. Do I need the postgis extension in stp?  (I'm thinking yes, but I

don't want to guess.)

Isn't this the same as (1) above? (Postgis is installed via "create
extension postgis;")

3. I want to geocode addresses in stp. Do I need to install any

geocoding software in stp?...or can it be used from geo?

If you can geocode in geo & access the resulting data via fdw in stp,
you should not need geocoding tools in stp.
If you need to access spatial data from geo in stp & geocode in stp,
you will need the geocoding tools in stp.

Thanks for your help!

Sue

--

--------------------------------------

Susan E Hurst

Email:  susan.hurst@xxxxxxxxxxxxxxxxxx

Mobile: 314-486-3261





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux