Skip to main content
Question

Merging 5 different postgis db to new postgis db

  • January 6, 2021
  • 1 reply
  • 14 views

I have 5 postgis db with same schema and having same layer names. I want to merge all these five db into new db in new projection. I am trying to do it with by adding reader into single merge feature and adding reprojector and output to writer postgis new db.

I am getting the error :Fanout feature type public.roads failed to find feature type template public.roads.

How to do this? Any clue. I am using FME 2020.2​

1 reply

Forum|alt.badge.img+2

If it's a one time deal, use the 'Generate Workspace' function (CTRL-G) to configure the 1st one. Run it, then change the connection parameter in the navigator to the next one until you finish.

 

It will give you a lot more control over the counts of records and whatnot as well to ensure data integrity.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings